Debt Amortization Schedule

Next, we add calculate the scheduled (i.e. required) amortization (i.e. repayment) of debt based on our assumptions about the terms of each debt instrument in the capital structure. Some forms of debt may amortize evenly over the term of the loan (e.g. Term Loan A in our model), or may have minimum amortization with a large “bullet” payment at the end of the loan (e.g. Term Loan B in our model).

Also, some debt may be prepaid early, while other debt may not. The interest on some debt (and preferred stock) may be paid-in-kind (“PIK”), meaning that rather than being paid out by the company in cash, interest accrues to the holders of PIK debt in the form of increased principal. For example, a 2% interest payment on $100 of PIK debt would result in a principal amount of $102 after the first interest payment.

 

Build Financial Models in Minutes

Enterprise-Grade Financial Modeling used by 80,000+ professionals across Investment Banking, Private Equity, and Corporate Finance. Ensure consistency, accuracy, and efficiency across your entire organization.

The amortization schedule calculations may seem a bit daunting at first, but all we are doing is checking each year to see how much of the debt principal must be repaid in that year. If, in a given year, the company is required to pay the loan in full, it pays the original principal amount less any prior amortization. Otherwise, the company is only required to repay the specified amortization amount.

Download Template

Download Template

Debt Amortization Schedule

Try Macabacus for free to accelerate financial modeling in Excel.

Discover more topics

Download The State of M&A Transactions
Download this report for expert guidance on innovative structures, cost-effective financing, and antitrust strategies to accelerate deals.
Read more
DCF Excel Template
Elevate your investment analysis with our free DCF model template. Understand discounted cash flow principles and perform accurate valuations in Excel.
Read more
Operating Model Excel Template
Download our free operating model Excel template. Forecast revenue, expenses, and key financial metrics for better decision-making.
Read more
LBO Excel Model
Try LBO modeling with our comprehensive Excel template. Understand key concepts, calculate returns, and gain actionable insights.
Read more