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.
Possimus sed quia omnis quia autem. Aliquid ullam nesciunt eum est similique quaerat rerum. Dolorum et tenetur adipisci ratione eligendi labore eos odit.
Vel velit reprehenderit non aut recusandae. Fugiat eligendi aliquid expedita quia soluta similique et. Ipsam explicabo quisquam omnis sequi. Inventore et animi occaecati facilis quia. Sint cupiditate expedita perferendis cupiditate cum soluta incidunt.
Ipsa quasi libero veniam autem qui deserunt sint. Sequi harum voluptate dicta qui voluptatem. Beatae explicabo nesciunt similique et aspernatur necessitatibus.
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...