This Excel file is an example of a schedule that would pull from a three statement model to evaluate a company's performance relative to debt covenants provided by lenders.
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).
Subordinated Notes: 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.