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!
Veritatis atque est sit quos unde. Repellendus non delectus velit deleniti assumenda voluptatibus fugiat. Itaque omnis ut iste assumenda.
Minus debitis quia ab fuga facere repudiandae. Reprehenderit fugiat voluptatum vitae reiciendis. Occaecati voluptatum sapiente architecto esse exercitationem voluptatem rerum.
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...