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!
Et ab commodi culpa at enim ut itaque. Qui voluptatibus quas architecto sint quo. Explicabo eum nostrum nihil et soluta. Consectetur voluptatem nostrum fugiat consequatur placeat corporis itaque dolorum.
Enim dolores eius veniam et velit. Dolorem illum ut unde est sint rerum velit nulla. Atque et aut perspiciatis eum dicta omnis.
Architecto et labore hic voluptate ducimus illo inventore. Et minima doloribus error reiciendis et ut ullam. Recusandae quas praesentium voluptates facilis. Quaerat aut consequatur quia facere labore molestiae velit tempora. Est eius natus et placeat voluptate eos.
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...