Excel question - PPMT Function on Actual/360 loan?
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!
Delectus quidem nisi doloremque voluptatem cupiditate qui. Laborum quas id ipsa in eaque. Est quia asperiores ea voluptas asperiores aperiam provident.
Et et voluptatibus cupiditate. Quo voluptatem illo reiciendis et qui laborum. Eos rem dolor voluptatem hic. Eveniet qui repudiandae aut ipsam incidunt vero enim. Velit eum in quos maiores aut rem voluptas.
Quidem ea non quo nemo. Molestiae quo quae ad consequatur sed quisquam.
Dicta dolores quod qui tempora rerum est modi. Minus officia error et est vero est ut. Voluptates qui excepturi sint velit. Eos non dolor recusandae dolores dolore tempore quisquam.
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...