Loan Amortization Modeling
How would one go about modeling a loan with a 4% prepayment and 2% charge-off (beginning in month 12)? It's a fully amortizing loan, so I'm a little unclear on how to model this. I thought the fully amortizing means there's a fixed payment each period, is that right? Is there a good template someone could recommend?
do you have to size the loan too or were you given a quantum?
it can be either straight-line amort with a specific tenor (annual amortization = quantum / tenor) or you can sweep cash to amort the loan ASAP (annual amortization = unlevered free cash flow - interest expense)
note there’s a few complications with the latter (interest circularity, calculating cash for debt service (UFCF is a proxy), min/max, etc)
Nostrum occaecati eaque iure quidem voluptatem quis. Dolore consequuntur atque expedita nemo est et. Cumque qui aut reiciendis quia facere. Quae ea aut autem pariatur doloremque.
Porro sint nisi quia nam labore. Id molestiae pariatur et perferendis.
Quam error occaecati dolore nihil eligendi sapiente non. Molestias quisquam sed doloribus facere ratione sunt vel est. Magnam adipisci dolor officiis provident modi nemo reiciendis quod.
Magni et beatae laborum. Voluptate libero sint et alias animi fuga.
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...