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!
Mollitia inventore sint aspernatur quidem. Explicabo dolore velit voluptatem beatae qui expedita non.
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...