theonline.mba
← Back to unit 4: Debt, Interest and Capital Structure Schedules

FIN 401 · Unit 4 · Lesson 1 of 4

Core Principles of Debt, Interest and Capital Structure Schedules

Debt, Interest and Capital Structure Schedules

Lesson

Debt schedules convert capital structure into cash interest and covenant math

Crestline Holdings generates $1.20B consolidated revenue and $156M EBITDA across four segments. CFO Victoria Hale, VP Corporate Development Ian Cho, Treasurer Marcus Webb, and Corporate Controller Elena Park coordinate modeling on $420M net debt and $89M levered free cash flow.

Victoria Hale requires 9.5% WACC discipline and segment-level forecasts before capital committee. Industrial ($480M), Healthcare ($310M), Consumer ($260M), and Logistics ($150M) each carry distinct drivers.

Marcus Webb manages $335M term loan B and a $85M revolver against $420M net debt. FIN 401 Unit 4 builds tranche-level schedules that feed interest, amortization, and covenant certificates.

A debt schedule error of $3M in interest can flip coverage ratios from pass to fail. Crestline treats each tranche as a roll-forward with documented rates and fees.

This lesson opens Debt, Interest and Capital Structure Schedules in FIN 401. You will learn why the topic exists as a managerial discipline, not merely a spreadsheet skill, and how Crestline's $1.20B revenue base makes small assumption errors expensive.

Crestline Holdings is a diversified mid-market portfolio company with four operating segments and the anchor company for finance electives FIN 401 through FIN 406. Consolidated revenue is $1.20B with $156M EBITDA (13.0% margin) and $420M net debt. CFO Victoria Hale, VP Corporate Development Ian Cho, Treasurer Marcus Webb, and Corporate Controller Elena Park coordinate modeling, valuation, portfolio policy, transactions, and risk management across four segments: Crestline Industrial Solutions ($480M revenue, $62M EBITDA, earnings before interest, taxes, depreciation, and amortization); Crestline Health Services ($310M revenue, $41M EBITDA, earnings before interest, taxes, depreciation, and amortization); Crestline Consumer Brands ($260M revenue, $28M EBITDA, earnings before interest, taxes, depreciation, and amortization); Crestline Logistics ($150M revenue, $25M EBITDA, earnings before interest, taxes, depreciation, and amortization).

Victoria Hale's finance organization treats Crestline as both an operating company and an internal case study. Every lesson applies finance mechanics to decisions she faces: refinancing the term loan, valuing a bolt-on acquisition, hedging steel input costs, or briefing the board on sum-of-the-parts value.

Tranche roll-forward mechanics

Each tranche: beginning balance + draws - mandatory amort - optional prepay + PIK (payment-in-kind, interest added to principal) = ending balance. Term loan B begins $335M with 1% annual amort ($3M).

Revolver availability = commitment - drawn + cash sweep repayments. Draws trigger when minimum cash breached.

Fees (commitment, unused line) hit interest expense separately for lender reconciliation.

Foundational lens on tranche roll-forward mechanics within Debt, Interest and Capital Structure Schedules. At Crestline's scale ($156M EBITDA, $420M net debt), tranche roll-forward mechanics affects refinancing timing, acquisition headroom, and board narratives. Core Principles of Debt, Interest and Capital Structure Schedules requires you to explain the idea to a smart colleague who has not taken the course, using at least one Crestline segment number.

Victoria Hale's review standard: if tranche roll-forward mechanics cannot be tied to a named owner and metric, it stays out of the board deck. Elena Park maps each concept to a close-pack line item or model tab. Ian Cho maps it to screening criteria or synergy line. Marcus Webb maps it to covenant or hedge policy.

Interest: cash vs PIK vs capitalized

Cash interest = average balance x (SOFR + spread) for floating or fixed coupon for termed debt. Crestline cost of debt 6.5% blends tranches.

PIK toggles are lender-approved only; modeled as yellow scenario switch.

Capitalized interest on major capex projects flows through CFI, not operating interest.

Foundational lens on interest: cash vs pik vs capitalized within Debt, Interest and Capital Structure Schedules. At Crestline's scale ($156M EBITDA, $420M net debt), interest: cash vs pik vs capitalized affects refinancing timing, acquisition headroom, and board narratives. Core Principles of Debt, Interest and Capital Structure Schedules requires you to explain the idea to a smart colleague who has not taken the course, using at least one Crestline segment number.

Victoria Hale's review standard: if interest: cash vs pik vs capitalized cannot be tied to a named owner and metric, it stays out of the board deck. Elena Park maps each concept to a close-pack line item or model tab. Ian Cho maps it to screening criteria or synergy line. Marcus Webb maps it to covenant or hedge policy.

Covenant definitions and headroom

Net leverage = net debt / lender EBITDA. Base 2.69x vs covenant 4.0x gives headroom 1.31x or ~$204M EBITDA equivalent.

Interest coverage = lender EBITDA / cash interest. Victoria Hale tracks headroom quarterly in lender EBITDA definition, not management add-backs.

Covenant step-downs post-acquisition are flagged in Ian Cho's models.

Foundational lens on covenant definitions and headroom within Debt, Interest and Capital Structure Schedules. At Crestline's scale ($156M EBITDA, $420M net debt), covenant definitions and headroom affects refinancing timing, acquisition headroom, and board narratives. Core Principles of Debt, Interest and Capital Structure Schedules requires you to explain the idea to a smart colleague who has not taken the course, using at least one Crestline segment number.

Victoria Hale's review standard: if covenant definitions and headroom cannot be tied to a named owner and metric, it stays out of the board deck. Elena Park maps each concept to a close-pack line item or model tab. Ian Cho maps it to screening criteria or synergy line. Marcus Webb maps it to covenant or hedge policy.

Refinancing and transaction layering

Refinancing sources and uses: new debt proceeds = old debt repayment + cash to balance sheet + fees.

Acquisition debt layering: new term loan + assumed debt + revolver draw; pro forma interest from day-one balances.

Prepayment premiums modeled as financing cash outflow, not operating expense.

Foundational lens on refinancing and transaction layering within Debt, Interest and Capital Structure Schedules. At Crestline's scale ($156M EBITDA, $420M net debt), refinancing and transaction layering affects refinancing timing, acquisition headroom, and board narratives. Core Principles of Debt, Interest and Capital Structure Schedules requires you to explain the idea to a smart colleague who has not taken the course, using at least one Crestline segment number.

Victoria Hale's review standard: if refinancing and transaction layering cannot be tied to a named owner and metric, it stays out of the board deck. Elena Park maps each concept to a close-pack line item or model tab. Ian Cho maps it to screening criteria or synergy line. Marcus Webb maps it to covenant or hedge policy.

Lender certificate reconciliation

Modeled balances must tie to lender statements within $500K per tranche each quarter.

Marcus Webb maintains a certificate mapping tab: model row to legal definition clause.

Discrepancies trigger Elena Park review before certification signature.

Foundational lens on lender certificate reconciliation within Debt, Interest and Capital Structure Schedules. At Crestline's scale ($156M EBITDA, $420M net debt), lender certificate reconciliation affects refinancing timing, acquisition headroom, and board narratives. Core Principles of Debt, Interest and Capital Structure Schedules requires you to explain the idea to a smart colleague who has not taken the course, using at least one Crestline segment number.

Victoria Hale's review standard: if lender certificate reconciliation cannot be tied to a named owner and metric, it stays out of the board deck. Elena Park maps each concept to a close-pack line item or model tab. Ian Cho maps it to screening criteria or synergy line. Marcus Webb maps it to covenant or hedge policy.


Worked example: Term loan B roll-forward and coverage

Base year term loan $335M at 6.5% cash interest, 1% amort.

Part A: Interest and amort

Cash interest ≈ $22M (simplified all-in). Mandatory amort = $3M. Ending balance ≈ $332M before optional prepay.

Part B: Coverage

Lender EBITDA $156M. Cash interest total (term + revolver) ≈ $27M. Coverage ≈ 5.71x.

Part C: Reconciliation

Net debt check: term ending + revolver drawn - cash = model net debt vs $420M. Interest ties to income statement line. Debt ending ties to balance sheet.

Part D: Managerial read

Victoria Hale will not approve optional $20M prepay unless coverage stays above 3.0x under SOFR +100 bps stress.


Worked example: Amortization omission at a fictional peer

Ridgeline Corp (fictional) modeled interest on a flat $400M debt balance while ignoring 2% mandatory amort. Projected coverage overstated by 0.4x; actual breach followed in year two. Crestline mandates tranche roll-forwards with amort lines visible.

Peer contrast: Ridgeline Corp ignored mandatory amortization and overstated interest coverage by 0.4x until covenant breach.


Common mistakes beginners make

MistakeReality
Flat debt balance with no amortizationRoll forward each tranche with contractual amort and prepays
Using management EBITDA for covenant mathMap lender EBITDA per credit agreement
Interest on ending balance onlyUse average balance or document convention
Prepayment premium in EBITDAClassify premiums as financing cash flows
Revolver capacity ignored in liquidityModel availability and minimum cash jointly

Practice problem

If SOFR rises 75 bps on $250M floating exposure, compute incremental annual interest. If lender EBITDA is $156M, compute new coverage if base interest was $28M.

Solution

Incremental interest = $2M. New interest ≈ $30M. Coverage = $156M / $30M ≈ 5.22x vs 5.57x base.


Practice problem 2

Build sources and uses for $350M new term loan refinancing $335M old loan with $8M fees and $7M cash to balance sheet. Verify balance.

Solution

Sources: $350M. Uses: $335M + $8M + $7M = $350M. Balanced.

Key takeaways

  • Tranche roll-forwards drive interest, balance sheet, and covenants.
  • Lender EBITDA and management EBITDA stay parallel but distinct.
  • Refinancing and M&A debt layers need sources-and-uses discipline.
  • Coverage and leverage headroom are decision metrics, not afterthoughts.
  • Core Principles of Debt, Interest and Capital Structure Schedules at Crestline ties Debt, Interest and Capital Structure Schedules to decisions Victoria Hale can defend under scrutiny.

After this lesson

  1. Apply Debt, Interest and Capital Structure Schedules to a decision at your employer or a public company. Write the decision frame, one table, and a check line.
  2. List one Crestline stakeholder who would disagree with a naive application of this lesson and write the dissent case fairly.
  3. Continue to Lesson 2: Designing an Approach to Debt, Interest and Capital Structure Schedules.

Applying Core Principles of Debt, Interest and Capital Structure Schedules at Crestline scale

When Crestline Holdings evaluates core principles of debt, interest and capital structure schedules, Victoria Hale's team starts from audited facts: $1.20B consolidated revenue, $156M EBITDA, $420M net debt, and segment margins ranging from 10.8% (Consumer Brands) to 16.7% (Logistics). CFO Victoria Hale, VP Corporate Development Ian Cho, Treasurer Marcus Webb, and Corporate Controller Elena Park align debt, interest and capital structure schedules with monthly close packs, lender covenant tests, and board materials. A lesson concept that sounds abstract becomes concrete when tied to revolver availability, term loan amortization, and pension underfunding of $17M.

Consider how a 50 basis point change in industrial segment EBITDA margin affects Crestline. Industrial revenue is $480M; 50 bps on revenue equals roughly $2M in annual EBITDA before corporate allocations. At a 9.5% WACC (weighted average cost of capital, the blended return required by debt and equity providers), that swing moves enterprise value by approximately $25M using a simple perpetuity intuition. That is why core principles of debt, interest and capital structure schedules is not academic for Ian Cho's corporate development team; it is how Crestline avoids overpaying for bolt-ons or under-hedging commodity exposure.

The debt, interest and capital structure schedules workflow at Crestline deliberately separates base, downside, and upside cases before capital committee. Elena Park's controllers label outputs before they reach Victoria Hale's Monday review. Exploratory acquisition screens become normalized earnings bridges only after purchase accounting rules are mapped. Descriptive ratio spikes trigger covenant sensitivity tables rather than same-day dividend changes. Transaction models still require guardrail checks on working capital seasonality, pension contributions, and FX (foreign exchange) translation so a revenue win does not hide margin erosion in euros.

Document definitions alongside every model line. Crestline's EBITDA add-back policy specifies restructuring caps, synergy phase-in timing, and stock-based compensation treatment. Debt schedules define cash interest versus PIK (payment-in-kind, interest added to principal rather than paid in cash) toggles. Portfolio return metrics document gross versus net of fees for pension assets. When definitions live in a shared model dictionary, Crestline builds institutional memory instead of re-debating the same spreadsheet row every quarter.

Extended Crestline scenario: cross-functional read

Imagine Crestline's Q3 review for core principles of debt, interest and capital structure schedules. The board asks whether refinancing the $335M term loan justifies paying a prepayment premium. Industrial segment leaders ask whether steel hedges belong in treasury or procurement. Healthcare segment asks whether normalized earnings understate physician recruiting costs. A weak debt, interest and capital structure schedules answer addresses only one function. A strong answer shows how evidence flows: normalized segment EBITDA becomes unlevered free cash flow, debt capacity sets acquisition headroom, and sensitivity tables translate rate shocks into covenant cushion.

Work the arithmetic on a conservative example. Suppose debt, interest and capital structure schedules analysis shows levered free cash flow rising from $89M to $96M if industrial working capital days fall by four. At constant multiple, equity value rises, but only if the working capital release is sustainable rather than a one-time squeeze on suppliers. Multiply the $7M uplift by Crestline's target EV/EBITDA (enterprise value to EBITDA, a valuation multiple comparing total firm value to operating earnings*) range of 8.0x to 9.5x to communicate magnitude to directors who do not live in spreadsheet tabs. Pair the point estimate with a downside case where supplier terms normalize within two quarters.

Stakeholder conflict is normal. Ian Cho may push to announce a deal before synergy validation completes. Marcus Webb may push to retain revolver capacity for rate volatility. Victoria Hale must decide under calendar pressure from lender amendment windows. Core Principles of Debt, Interest and Capital Structure Schedules gives you language to negotiate those tensions with model quality standards rather than charisma. If debt capacity is insufficient, the decision is reduce price or improve operations, not pretend a 0.25x turn of EBITDA fixes leverage overnight.

Translate lessons to your own context by replacing Crestline names while keeping structure. Pick one decision your organization faces this quarter. Write the decision question, three key assumptions, primary output metric, covenant or policy guardrail, and inconclusive outcome before opening Excel. If you cannot write those elements, you are not ready to circulate a model regardless of how polished the charts look.

Technical mechanics and checks (finance modeling patterns)

For core principles of debt, interest and capital structure schedules, Crestline analysts show work the way auditors show tie-outs. A three-statement model prints revenue growth, EBITDA bridge, cash flow walk, and ending cash with a check that sources equal uses within $1M rounding. A debt schedule multiplies beginning balance by contractual rate, subtracts mandatory amortization, and reconciles to ending balance per tranche. A valuation table discounts free cash flows at WACC and reconciles enterprise value to equity value via net debt and non-operating items. An LBO returns table shows entry multiple, exit multiple, debt paydown, and IRR (internal rate of return, the annualized return that sets net present value to zero).

Use plain-language assumptions before formulas. Example for refinancing: if SOFR (Secured Overnight Financing Rate, the benchmark for many floating-rate loans) rises 75 bps, annual cash interest on floating exposure increases by principal times 0.75%. Still verify seasonality with year-over-year EBITDA comparisons and document concurrent one-offs that could violate independence of forecast drivers.

For spreadsheet replication, write the grain first. Segment-level tables suit sum-of-the-parts valuation. Consolidated monthly tables suit covenant compliance. Daily cash tables suit revolver borrowing base tests. Crestline forbids ambiguous one-word outputs like "returns" without specifying gross IRR, money multiple, or public-market equivalent. Each definition implies different formulas and different managerial meaning.

Common executive questions (and disciplined answers)

Executives ask short questions that require long disciplined answers. "How sure are we?" maps to sensitivity tables, covenant headroom, and independent model review, not bravado. "What is the dollar impact?" maps to EBITDA or FCF delta times appropriate multiple with explicit stationarity assumptions. "Can we close faster?" maps to risk of signing before diligence findings are priced. "Why trust management adjustments?" maps to policy caps, auditor concurrence, and trailing evidence. "Why not just use the stock price?" maps to market noise versus intrinsic cash flow drivers.

Crestline's credible answer format for core principles of debt, interest and capital structure schedules is three bullets: recommendation, evidence strength (historical, normalized, pro forma), and next validation step if limitations matter. A fourth bullet lists what would falsify the recommendation within one reporting cycle. That discipline prevents the finance team from becoming either a bottleneck or a rubber stamp.

Practice the translation loop until it is habit. Business question to model architecture to assumptions to outputs to board ask. When the loop is complete, Crestline funds what survives skepticism. When the loop is broken, the company buys false precision cheaply and pays for it at refinancing or acquisition close.

Practice extension: self-check without peeking

Before reading any solution in this lesson again, open a blank workbook tab and complete four rows. Row one: write Crestline's business question that core principles of debt, interest and capital structure schedules helps answer. Row two: list model inputs you would mark blue versus black versus green. Row three: name primary output, one sensitivity driver, and one covenant guardrail. Row four: state the decision you would make if the output moves favorably versus unfavorably. Compare your rows to the worked example and practice problem. Gaps indicate what to re-read.

If you are studying outside diversified industrials, substitute your company but keep numeric discipline. A SaaS operator might replace EBITDA with ARR (annual recurring revenue) and net debt with convertible notes. A bank might replace segments with business lines and capital ratios. The structural habits from FIN electives remain: define terms, show checks, label scenario type, and tie results to decisions with explicit limitations.

Connection to core finance coursework

Corporate finance core introduced DCF (discounted cash flow, valuing cash streams at a required return), WACC, and capital budgeting. Managerial accounting introduced variance analysis and segment reporting. FIN 401 through FIN 406 apply those foundations to Crestline-scale decisions: integrated models, equity research discipline, pension portfolio policy, M&A execution, sponsor economics, and treasury risk.

When you present to executives, integrate the stack in one narrative arc rather than jargon layers. Example: normalized industrial EBITDA supports a 9.0x multiple in sum-of-the-parts; debt schedule shows 3.2x net leverage post-refinancing; rate hedge reduces one-year earnings volatility by 40 bps at the EBITDA line. That integrated story is what capstone memos require.

Deep dive: Crestline metrics reused every month

Consolidated EBITDA follows Crestline's management definition: operating income plus D&A plus approved restructuring add-backs capped at $8M annually. Net debt equals total debt less cash and equivalents; revolver drawings count even if offset temporarily. Levered FCF starts from EBITDA, subtracts cash taxes, capex, and interest, and adjusts for working capital using segment-specific drivers. Segment EBITDA excludes unallocated corporate costs until the consolidation bridge. Adjusted EPS (earnings per share) uses diluted shares outstanding of 48,000,000 and normalizes one-time items per board policy.

These definitions appear boring until someone changes them silently. A definitional shift in add-backs can fake accretion in an acquisition model. Core Principles of Debt, Interest and Capital Structure Schedules training includes insisting on definition links in model tabs. When Crestline compares public comps to private targets, shared definitions are the chain between market price and intrinsic value.

For debt, interest and capital structure schedules, also document data sources and refresh cadence. ERP actuals update nightly; treasury cash updates hourly; pension valuations mark quarterly; acquisition targets provide monthly management packs. A model output without timestamp and owner is a rumor. Elena Park's team rejects tabs that lack both.

Walk through a numerical reconciliation each quarter. Beginning cash plus cash flow from operations plus financing flows should approximate ending cash within known FX translation differences. Segment EBITDA should sum to consolidated EBITDA after corporate allocation. Debt tranche balances should tie to lender statements within fees accrued. Reconciliation does not guarantee truth, but it catches link errors before the board does.

Managerial judgment prompts for Core Principles of Debt, Interest and Capital Structure Schedules

  1. If evidence is historical only, what is the cheapest forward test Crestline could run before signing?
  2. If Ian Cho wants to announce a deal and Marcus Webb wants more revolver headroom, what pre-written rule breaks the tie?
  3. Which stakeholder loses most if Crestline accepts a false positive on core principles of debt, interest and capital structure schedules?
  4. What would a smart skeptic ask about normalization, synergy timing, or commodity pass-through?
  5. What single covenant or policy guardrail would convince you to pause an otherwise attractive output?

Write ninety-word answers as a memo appendix. Use Crestline numbers wherever possible. This exercise converts lesson prose into decision reflexes you will use under lender and board time pressure.

Additional study path: compare this lesson's worked example to the practice problem. Identify one assumption that changed and explain how that change alters the decision. Then compare to Unit 6 integrative review structure: decision ask, labeled evidence, limitations, next validation. Course integration is intentional; finance electives compound when you reuse the same company, metrics, and vocabulary across units.

Lesson exercise

35 min

Core Principles of Debt, Interest and Capital Structure Sche Drill

Complete this exercise for **Core Principles of Debt, Interest and Capital Structure Schedules** using Crestline Holdings (or your employer with the same structure). 1. Attempt the lesson practice problem without reading the solution. 2. Verify with the check line or reconciliation rule from the worked example (Term loan B roll-forward and coverage). 3. Transfer the framework to a second context: one Crestline segment or a public company 10-K. 4. Write 100-150 words: managerial read for Victoria Hale including one downside scenario. 5. List one metric that would change your recommendation within 60 days.

Deliverable

Workbook tab or memo section filed under FIN 401 Unit 4 with tables and check lines visible.

Rubric

  • Practice problem attempted before solution review
  • Reconciliation or check line passes with stated tolerance
  • Second context uses real company data or Crestline segment facts
  • Managerial read names stakeholder tradeoff, not generic advice