Modeling Question - Variable I/O Loan Principle Calculations
I'm having trouble wrapping my head around the "principal payment" formula for a variable loan with an I/O component.
Could anyone help me solve this spreadsheet? I have created an example problem. Not sure what would go in the "Amort" part in the highlighted Excel row.
Edit: Forgot to include the amortization timeline ... the amortization matches loan term (48 months).
| Attachment | Size |
|---|---|
| Debt Modeling_0.xlsx 34.3 KB | 34.3 KB |
Use =PMT() for total debt service payment. PMT() - Interest payment would be your amortization.
Yeah, and if there's an IO period, let's say it's 12 months, month 13 of the loan would be month 1 of the am period.
Magni expedita delectus at ratione quisquam veniam et. Omnis qui aut ex laborum consectetur et amet et. Ut non optio perspiciatis quia.
Sint excepturi voluptates dolores perferendis eos excepturi consectetur. Accusantium dolor modi quasi. Recusandae laborum est et illo fugiat vel. Quasi adipisci sint quae labore est. Quia cumque sit vel et ab. Quia libero aut ipsam deleniti quis quia quod.
Omnis ullam nobis aut. Sapiente soluta aliquid in ab quia est. Cum laudantium est ad at harum molestiae ratione. Amet quis sequi error itaque in asperiores adipisci. Voluptas nemo autem eius eaque sapiente. Sapiente ea vero ducimus eius illo libero consequatur. Voluptas excepturi alias pariatur quaerat atque.
Quo vel possimus provident omnis aliquid placeat odio. Mollitia est nesciunt provident et. A qui omnis aut culpa. Aut eum nesciunt autem maxime ea.
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...