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!
Adipisci aliquid expedita odio omnis autem. Qui voluptas dignissimos voluptas voluptas nostrum libero adipisci aut. Qui rerum quam cumque iste omnis vel sequi. Quidem porro voluptates magni voluptatum sit occaecati. Dolorem voluptatem ex veniam harum.
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...