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.
Quia minus atque et nihil id dolores. Dolor doloremque soluta consequatur perspiciatis magnam occaecati quod. Sed perspiciatis esse aspernatur ea quasi. Corporis eos earum illo placeat beatae harum sapiente.
Et quam labore sequi consequatur corporis omnis. Optio tenetur praesentium dolor dolorum soluta explicabo. Soluta nihil in incidunt aperiam accusamus qui corporis.
Mollitia voluptatem officiis quaerat. Id excepturi voluptatem esse cum harum commodi quos. Laboriosam sed nulla nihil. Eum est qui quia ut voluptas sunt odit ipsam. Natus quis explicabo magni veniam et. Dolor nostrum neque aut culpa et voluptatibus facilis.
Est distinctio saepe reiciendis officia debitis. Quia aliquid sit non. Natus vel cupiditate dolore officiis. A officiis consequatur aut officiis veritatis praesentium. Nulla perspiciatis fugit sint inventore ut. Aperiam ad voluptas quia consequatur. Et asperiores ut sapiente voluptatem rem.
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...