Introduction to Financial Statements
Integrating Financial Statements
Discounted Cash Flow Model
Leveraged Buyout Model
Excel For Models
Monthly Debt Schedules Example
In response to subscriber email traffic, I thought I would post a couple examples of monthly debt schedules. This post includes an Excel template with two examples (
available for download at the bottom of this post
). The first it labeled "Senior Term Loan," and the second is labeled "Subordinated Notes."
Senior Term Loan:
This example debt schedule provides the option to project interest payments at LIBOR + a fixed rate, and
includes mandatory quarterly principal payments. There is a row for the cash flow sweep, but it is included as a manual input in this model (for a dynamic version in please see the
leveraged buyout video series
This example debt schedule includes a toggle that permits a portion of the interest be paid in kind (Payment-in-Kind or PIK). This feature can be activated or deactivated for any monthly period with a simple "Y" / "N" input.
Formulas and Functions: As you explore the template, you may notice functions that have not been explained previously on ASM. For a video explanation please see the following:
=SUM & =OFFSET to sum a specific number of cells.
=MOD to calculate quarterly interest payments.
Template available for download:
Click HERE to have updates like this one sent directly to your inbox.
Monthly Debt Schedule
should be simple.*
*Financial ones, anyway.