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)
Aspernatur amet ut ut pariatur. Pariatur maxime cupiditate dolorum aliquam unde. Voluptate enim voluptates non sed enim id. Omnis rerum sed nesciunt aut velit eveniet eum.
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...