# Lecture 7: Debt & Interest Schedules - Practice Exercises Guide

## Overview
This guide provides step-by-step exercises for building debt and interest schedules.

## Files Included
- `lecture-07-debt-schedule-data.csv` - Sample debt data for 3 companies
- `lecture-07-debt-schedule-template.csv` - Blank template for practice

## Exercise 1: Interest Calculation
Using the data provided, calculate annual interest for each debt instrument:
1. Revolver: SOFR (assume 5%) + Spread
2. Term Loans: SOFR + Spread
3. Fixed Rate Bonds: Use stated rate

## Exercise 2: Build Amortization Schedule
For Alpha Corp Term Loan A ($150M, 5% amort):
- Year 1: Beginning = $150M, Amort = $7.5M
- Continue for 5 years

## Exercise 3: Cash Sweep
Assume $20M excess cash available. Apply to highest-cost debt first.

## Solutions
Check your work against the completed schedules in lecture section 5.