Study guide
13.1 Debt and Interest Schedules
Financial Modeling & Valuation Analyst FMVA
Track your progress as you read
Finished sections get a check mark.
1 Introduction
Current Exam Facts Program Path and How to Use This Guide
2 Chapter 1: Accounting Foundations
1.1 Accounting Principles 1.2 Reading Financial Statements 1.3 Accounting Decisions in Models
3 Chapter 2: Time Value and Capital Budgeting
2.1 Time Value of Money 2.2 NPV, IRR, and Decision Rules 2.3 Capital Budgeting Cash Flows
4 Chapter 3: Cost of Capital
3.1 Capital Structure 3.2 CAPM, Beta, and Cost of Equity 3.3 WACC
5 Chapter 4: Profitability and Returns
4.1 Profitability and Margins 4.2 Returns and DuPont Analysis 4.3 Per-Share Metrics and Growth
6 Chapter 5: Liquidity, Leverage, and Cash Flow
5.1 Liquidity and Working Capital Metrics 5.2 Leverage, Coverage, and Credit 5.3 Cash Flow Statement Analysis
7 Chapter 6: Excel Fundamentals
6.1 Shortcuts, Setup, and Navigation 6.2 Core Formulas and Error Handling 6.3 Named Ranges and Workbook Hygiene
8 Chapter 7: Excel Lookups and Financial Functions
7.1 Lookup Functions 7.2 Conditional Aggregations 7.3 Financial Functions
9 Chapter 8: Excel What-If Analysis and Auditing
8.1 Goal Seek and Data Tables 8.2 Formula Auditing and Protection
10 Chapter 9: Financial Modeling Guidelines
9.1 Model Structure and Layout 9.2 Color Conventions and Formatting 9.3 Integrity Checks and Documentation
11 Chapter 10: Three-Statement Modeling
10.1 Articulating the Three Statements 10.2 Building the Income Statement 10.3 Building the Balance Sheet and Cash Flow Statement
12 Chapter 11: Circularity and Model Audit
11.1 Circular References and Iteration 11.2 Auditing and Balancing a 3-Statement Model
13 Chapter 12: Operational Modeling
12.1 Revenue and Operating Drivers 12.2 Working Capital Modeling 12.3 Capex and Depreciation
14 Chapter 13: Debt Schedules, Scenarios, and Sensitivity
13.1 Debt and Interest Schedules 13.2 Scenario Analysis 13.3 Sensitivity Analysis
15 Chapter 14: Valuation Foundations
14.1 Valuation Methods and Enterprise Value 14.2 Unlevered Free Cash Flow
16 Chapter 15: DCF Valuation
15.1 DCF Structure, WACC, and Mid-Year Convention 15.2 Terminal Value and the Equity Bridge
17 Chapter 16: Comparable Valuation
16.1 Trading Comps and Multiples 16.2 Precedent Transactions and the Football Field
18 Chapter 17: Budgeting and Forecasting
17.1 Budget Types 17.2 Forecasting Techniques 17.3 Rolling Forecasts and Variance Analysis
19 Chapter 18: Presentation and Visuals
18.1 Chart Types and Selection 18.2 Dashboards and Data Visualization 18.3 PowerPoint and Pitchbooks 18.4 Presenting Model Outputs
20 Chapter 19: Professional Ethics and Qualitative Analysis
19.1 Professional Ethics 19.2 Qualitative Business Analysis
13.1 Debt and Interest Schedules
Key Takeaways Explain This Topic AI
The debt rollforward is Opening + draws − mandatory amortization − optional prepay = closing; Northline Packaging's $12,000,000 6% term loan amortizes $4,000,000 a year to a Year-1 close of $8,000,000.
When the case is silent, CFI's teaching default is interest = rate × (opening + closing) / 2; Northline Year-1 interest is 6% × $10,000,000 = $600,000, not 6% × opening $12,000,000.
Interest expense sits on the income statement; the cash change in principal is cash from financing; the closing balance, split current versus long-term, sits on the balance sheet.
A revolver is the cash plug that draws or repays so cash does not fall below a stated minimum; average-balance revolver interest is circular and is gated with the Circ Switch from Chapter 11.
Covenant tests in a case are typically leverage (Debt/EBITDA or Net Debt/EBITDA) and interest coverage (EBITDA/Interest); use the thresholds printed in the case, not a memorized CFI-official ratio.
Last updated: August 2026
Why a Debt Schedule Is Required
Quick Answer: CFI's three-statement linking rule is specific: interest is an income-statement expense, principal lives on the balance sheet, and the change in principal is cash from financing (CFF) . You cannot reverse-engineer principal from the interest line. Build a debt schedule . The rollforward is Opening + draws − mandatory amortization − optional prepay = closing . Interest = rate × average of opening and closing when the case is silent (CFI's teaching default), or rate × opening if the case says so. A revolver is the plug that holds cash at a minimum cash floor. Split closing debt into current (due within 12 months) and long-term . Test leverage and interest coverage with the thresholds the case prints — CFI does not publish official covenant ratios for you to memorize.
CFI's 2026 core stack puts 3-Statement Modeling and Auditing and Balancing a 3-Statement Model immediately before operational modeling. Financial modeling is about 30% of estimated FMVA final weight, and the Excel case studies (CFI's published pace is about 45 minutes per case, 60 maximum, inside a 3-hour , unpausable, 50-question exam) fail when the debt rollforward is missing or when interest is typed as a hardcoded dollar amount. Chapter 10 already stated the linking rule. This section builds the schedule that makes the rule true in live formulas.
A debt schedule is required for a second, practical reason. Interest is a flow . Principal is a stock . The interest line on the income statement does not tell you whether the company borrowed, repaid, or simply sat on a flat balance. Two firms can show the same $600,000 of interest and have completely different year-end debt — one because the rate is 6% on a $10 million average balance, the other because the rate is 12% on a $5 million average balance. Only the rollforward distinguishes those stories, and only the rollforward feeds CFF and the balance sheet.
The Rollforward Identity
Every facility — term loan, bond, notes payable, or revolving credit — gets the same skeleton:
Closing debt = Opening debt + draws − mandatory amortization − optional prepay
Line What it is Typical source
Opening Prior-year closing, or the amount outstanding at the model start Prior column, or a blue historical hardcode
Draws New borrowing during the year Case input, capex-financing assumption, or revolver plug
Mandatory amortization Contractual principal due this period Credit agreement / case (equal principal, mortgage-style, or percent of original)
Optional prepay Extra principal the borrower chooses to pay Cash sweep, excess-cash assumption, or a blue toggle
Closing Amount outstanding at year-end Formula: opening + draws − mandatory − optional
Do not put interest in this identity. Interest is not principal. A schedule that does opening × (1 + rate) is treating the loan like a compounding savings account and will double-count cash: you would reduce cash through the income statement (interest) and again through an inflated closing balance.
Mandatory amortization is the amount the borrower must pay this period under the contract. Optional prepay is extra. On the exam, mixing them is a classification error: a cash-sweep prepay can be turned off; a contractual $4 million amortization cannot. If the case gives a 20% per year paydown of original principal, that 20% is mandatory. If the case says "excess cash above $500,000 pays down the term loan," that excess is optional prepay.
Worked Example: Northline Packaging Three-Year Term Loan
Northline Packaging closes a $12,000,000 senior term loan on the first day of Year 1. The credit agreement in the case states:
- Coupon 6.00% per year
- Equal annual mandatory amortization of $4,000,000 (a three-year fully amortizing loan)
- No commitment fee
- Optional prepay allowed without penalty, but management's base plan is $0 optional prepay
- Interest convention not stated — use CFI's default of average balances
- Line Year 1 Year 2 Year 3
- Opening term loan $12,000,000 $8,000,000 $4,000,000
- Draws $0 $0 $0
- Mandatory amortization $(4,000,000) $(4,000,000) $(4,000,000)
- Optional prepay $0 $0 $0
- Closing term loan $8,000,000 $4,000,000 $0
- Average balance $10,000,000 $6,000,000 $2,000,000
- Interest at 6% $600,000 $360,000 $120,000
- Current portion (next 12 months) $4,000,000 $4,000,000 $0
- Long-term portion $4,000,000 $0 $0
Walk Year 1 in words. Opening is the $12,000,000 drawn at the start of the year. There is no additional draw. Mandatory amortization is $4,000,000 . Optional prepay is $0 . Closing = 12,000,000 + 0 − 4,000,000 − 0 = $8,000,000 . Average balance = (12,000,000 + 8,000,000) / 2 = $10,000,000 . Interest = 6% × 10,000,000 = $600,000 .
Year 2 and Year 3 follow the same formulas with no copied numbers. Year 2 opening is Year 1 closing. If you hardcode Year 2 opening as 8,000,000 instead of linking to Year 1 closing, a later optional-prepay toggle will not flow and the audit checks in Chapter 11 will miss it until you change a driver.
Now add a $1,000,000 optional prepay in Year 2 as a variant. Year 2 closing becomes 8,000,000 + 0 − 4,000,000 − 1,000,000 = $3,000,000 . Year 2 average becomes (8,000,000 + 3,000,000) / 2 = $5,500,000 , so interest falls to 6% × 5,500,000 = $330,000 . Year 3 opening is now $3,000,000 . Mandatory amortization cannot exceed remaining principal, so Year 3 mandatory is $3,000,000 , not a blind $4,000,000, and Year 3 closes at $0 . A formula that pays $4,000,000 in Year 3 after a Year-2 prepay overpays the lender and drives debt negative — an integrity error the case will flag.
Interest Convention: Opening Versus Average
Two conventions appear on FMVA cases. State which one you are using in the schedule header.
Convention Formula Circular? When to use
Opening (beginning) balance Interest = rate × opening No — opening is last year's close When the case says beginning-balance interest, or when you have iteration off and need a non-circular stub
Average balance Interest = rate × (opening + closing) / 2 Yes , if closing depends on interest (revolver / cash) CFI teaching default when the case is silent
Closing (ending) balance Interest = rate × closing Yes Only if the case explicitly says ending-balance interest; rarer
Day-count / stub Rate × principal × days/360 or days/365 Depends Bond models and mid-year draws; use only if the case gives a day count
On Northline's Year 1, opening-balance interest would be 6% × $12,000,000 = $720,000 — $120,000 more than the average-balance figure. That $120,000 flows through EBT, tax, net income, cash, and (if there is a revolver) the plug. Using the wrong convention is not a rounding difference. It is a different model.
Average-balance interest on a term loan with a fixed amortization schedule is only mildly circular: closing is determined by the principal identity, which does not depend on interest, so I = r × (opening + closing) / 2 can be computed in one pass. Average-balance interest on a revolver is circular, because interest changes cash, which changes the revolver draw, which changes closing revolver, which changes interest. That is the second circular loop from Chapter 11. Gate it with the Circ Switch (blue 1/0). Do not "fix" it by switching the term loan to opening-balance interest while the case asked for average.
Current Versus Long-Term Split
The balance sheet does not show one debt line in a CFI-quality model. It shows current portion of long-term debt (CPLTD) inside current liabilities and the remainder as long-term debt .
CPLTD = principal contractually due within the next 12 months.
For an equal-principal term loan, that is next year's mandatory amortization , capped at remaining principal. It is not an optional prepay you have not committed to. At the end of Northline Year 1, $8,000,000 is outstanding and $4,000,000 is due in Year 2, so the classified stack is $4,000,000 current + $4,000,000 long-term . At the end of Year 2, $4,000,000 is outstanding and all of it is due within 12 months, so $4,000,000 current + $0 long-term . A model that parks the entire $8,000,000 in long-term debt at the end of Year 1 understates current liabilities, overstates current ratio and working-capital ratios, and will miss a current-ratio covenant if the case has one.
A revolver is typically classified as entirely current because it is due on demand or within the facility year. If the case states a multi-year committed facility with no current amortization, follow the case. Do not invent a current split that the credit agreement does not support.
The Revolver as a Minimum-Cash Plug
Operating cash flow, capex, dividends, and term-loan amortization can drive forecast cash negative. CFI models almost never leave cash negative. They insert a revolving credit facility that draws when cash would otherwise fall below a minimum cash floor and repays (but not below zero) when cash would otherwise sit above that floor plus outstanding revolver.
Mechanically, in each forecast year:
Compute cash before revolver (the cash you would print if the revolver draw/repay were zero).
Required draw = max(0, minimum cash − cash before revolver).
Optional repay = max(0, min(opening revolver, cash before revolver − minimum cash)).
Closing revolver = opening revolver + draws − repay.
Interest on the revolver uses the same convention as the term loan, unless the case splits them.
Worked plug. Northline's case sets minimum cash = $400,000 . In Year 1, cash before revolver is $150,000 . Opening revolver is $0 . Required draw = max(0, 400,000 − 150,000) = $250,000 . Closing revolver = $250,000 . If the revolver rate is 8.00% and the convention is average, revolver interest = 8% × (0 + 250,000) / 2 = $10,000 . That $10,000 reduces net income and cash, so cash before revolver is slightly lower than $150,000 on the next iteration and the draw ticks up by a small amount. That is the intended circular loop. With the Circ Switch set to 0, multiply revolver interest (and usually the plug) by zero so the file can be reset after a #REF! cascade.
The revolver is not a forecast of management's borrowing plan. It is a plug . If the case already gives a term-loan draw that finances capex, do not also let the revolver silently fund the same capex without noticing. A revolver that grows every year while the term loan amortizes is a signal that operations plus capex cannot cover mandatory principal — exactly the credit story a covenant test is meant to catch.
Covenants: Leverage and Interest Coverage
Credit agreements constrain the borrower. FMVA does not publish official covenant thresholds. The case will. Two tests appear constantly:
- Test Typical formula What it asks
- Leverage Total debt / EBITDA, or net debt / EBITDA How many years of EBITDA to repay the stock of debt
- Interest coverage EBITDA / interest, or EBIT / interest How many times earnings cover the interest flow
Debt service coverage (when the case gives it) (EBITDA − maintenance capex) / (interest + mandatory amortization) Whether cash earnings cover interest and required principal
Suppose Northline's case states maximum Total Debt / EBITDA of 3.50x and minimum EBITDA / Interest of 4.00x . Year 1 EBITDA is $4,800,000 . Closing term loan is $8,000,000 and closing revolver is $250,000, so total debt is $8,250,000 . Leverage = 8,250,000 / 4,800,000 = 1.72x , under 3.50x — pass . Interest is $600,000 (term) + $10,000 (revolver) = $610,000 . Coverage = 4,800,000 / 610,000 = 7.87x , above 4.00x — pass .
If Year 1 EBITDA had been $2,000,000 with the same $8,250,000 of debt, leverage would be 4.13x and the leverage covenant would fail . Interest coverage would be 2,000,000 / 610,000 = 3.28x , also a fail on a 4.00x test. The model should flag this with CFI-style OK / Error conditional formatting. Do not "fix" a failed covenant by silently cutting the mandatory amortization. That would be rewriting the credit agreement.
Net debt versus gross debt matters. Net debt = interest-bearing debt − non-core cash . If the covenant is Net Debt / EBITDA and Northline holds $400,000 of minimum cash that the lender treats as surplus, net debt is 8,250,000 − 400,000 = $7,850,000 and leverage is 1.64x . Using the wrong numerator is as wrong as using the wrong threshold. Read the case definition; do not assume CFI has a single official ratio.
How Debt Hits the Three Statements
Map every line. This is the exam sentence CFI wants:
Item Income statement Cash flow statement Balance sheet
Interest expense Finance cost, above EBT Already inside net income , so it sits in CFO under the indirect method Not a stock; do not put it on the BS
Interest paid (if you show a supplemental line) Same expense CFO under U.S. GAAP; CFO or CFF under IFRS if the case says so —
- Draws No P&L CFF inflow Increases the debt stock
- Mandatory amortization and optional prepay No P&L CFF outflow Decreases the debt stock
- Closing debt No P&L Not a flow Current + long-term liability
Northline Year 1, ignoring the revolver for one beat: interest $600,000 on the income statement; CFF principal outflow $4,000,000 ; balance sheet debt $8,000,000 (of which $4,000,000 current). Starting the cash flow statement from net income already deducted the $600,000. Do not subtract interest again in CFF. That double-count is a classic integrity miss: cash on the BS will not equal ending cash on the CFS, and the plug test from Chapter 10 fails by the after-tax interest amount.
The $12,000,000 origination, if it occurs on the first day of Year 1, is a CFF inflow of $12,000,000 in Year 1 and the opening of the schedule. If it occurred in the last historical year, it is already in historical CFF and the forecast schedule starts at $12,000,000 with forecast CFF equal to amortization only. Match the case timing.
FMVA Exam Traps on Debt Schedules
Skipping the schedule and typing interest as a blue dollar amount. When revenue moves, interest should not stay glued unless the case says a fixed coupon on a fixed balance.
Using opening-balance interest when the case is silent. CFI's default is average. The Northline Year-1 gap is $720,000 versus $600,000.
Putting principal on the income statement or putting interest in CFF after starting from NI .
Letting amortization exceed remaining principal after an optional prepay.
Parking all debt in long-term and skipping CPLTD.
Treating the revolver as an operating cash flow. Draws and repayments are CFF; only the interest hits the P&L.
Inventing a 3.0x or 4.0x covenant because it "looks typical." The case states the test. If the case has no covenant, do not add one.
Leaving cash negative because you omitted the revolver plug, or leaving iteration on with no Circ Switch so a colleague with iteration off sees zeros.
The schedule is finished when: the rollforward ties, interest uses the stated convention, current + long-term = closing, CFF equals draws minus principal paid, the income statement shows interest, the balance sheet shows the split stock, cash stays at or above minimum, and any case-stated covenant flag is live.