Definition
A debt schedule tracks each facility's balance, interest rate, amortization, and maturity to model cash and covenant impacts.
Formula
Ending balance = beginning balance + draws - principal payments
Example
A schedule shows $1M term debt declining by $25k per month with 7% interest.
How to use it
- Separate term loans, revolvers, and leases for clarity.
- Update rates when debt is floating to avoid forecast errors.
Common mistakes
- Ignoring fees and amortized financing costs.
- Assuming refinancing without validating lender terms.
Why this matters
This term matters because cash timing and risk are usually the difference between a plan that works on paper and a plan that survives. Use consistent definitions so decisions are comparable over time.
Practical checklist
- Write a 1-line definition for "Debt Schedule" that your team will use consistently.
- Keep the time window consistent (weekly/monthly/quarterly) when comparing trends.
- Segment results (channel/plan/cohort) before drawing big conclusions from blended averages.
- Sanity-check with a related calculator from the same category on MetricKit.
- Read the related guide (e.g., Loan amortization: how monthly payments and total interest work) for context and common pitfalls.
Where to use this on MetricKit
Calculators
- Pro Rata Investment Calculator: Estimate how much you need to invest in a new round to maintain your ownership percentage (simplified).
- Option Pool Shuffle Calculator: Estimate founder dilution impact when the option pool is increased to a target percent of post-money (simplified).
- SAFE Conversion Calculator: Estimate how a SAFE converts in a priced round using a valuation cap and/or discount (simplified).
- Convertible Note Conversion Calculator: Estimate how a convertible note converts in a priced round with interest plus a valuation cap and/or discount (simplified).
- Liquidation Preference Calculator (1x): Estimate investor proceeds at exit under a simple 1x non-participating liquidation preference vs converting to common (simplified).
Guides
- Loan amortization: how monthly payments and total interest work: A practical guide to loan amortization: monthly payment formula, why interest dominates early, and how term and rate affect total interest.
- Runway and burn: gross vs net burn, working capital, and cash levers: A practical guide to runway: compute net burn, understand why cash differs from profit, and how working capital and collections change runway.