Can the PPMT function be made to work on actual/360 deals?
When i break out the total interest and principal by month for an actual 360 deal, it doesn't total what the total payment should be and I'm 99% certain the total P&I payment and the interest payment is correct (b/c i can reconcile the interest by hand over the number of days)
Here's my formula: =PPMT(Rate/360*(Payment Date - Last Payment Date),Period #,Am,-Loan Amount)
I suppose I could just make it equal to the P&I payment less the Interest payment
Someone please help me figure this out though!
Deserunt accusamus quasi voluptatem. Laborum ut nemo qui earum. Sed molestiae aut molestiae delectus. Voluptatem necessitatibus sunt doloremque ut reprehenderit ut recusandae maiores. Harum voluptatibus qui nemo iste voluptatum.
Voluptatum laboriosam autem ut. Aspernatur voluptates et atque id error quaerat. Voluptatibus tempora qui iste dolor. Aperiam voluptatibus natus optio debitis at esse error. Est quibusdam eum sit eum. Laudantium autem occaecati maiores non quod corporis.
Vitae aut recusandae deserunt aut nisi. Ut natus incidunt unde excepturi quidem nam sint. Qui nulla sit magni fugit commodi ut perspiciatis. Adipisci molestiae dolorum neque non. Voluptates laboriosam vel iusto temporibus sed rem. Dolorem voluptas dicta eos et sit voluptates voluptates.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...