GSH Financial mark GSH Financial
(431) 305-0352 Book a Consultation
GSH FinancialGSH Financial

Home / Financial Tools / Integrated Three-Statement Financial Model & Debt Schedule Engine

Graduate-Level Modeling · Integrated Financial Modeling

Integrated Three-Statement Financial Model & Debt Schedule Engine

Every real operating model has the same circular problem: interest depends on cash, cash depends on income, income depends on interest. This one solves it properly, and proves it with a balance sheet that actually balances.

How To Use This Model

Reading This Tool

This is a full, linked three-statement model: income statement, balance sheet and cash flow statement, driven by roughly thirty operating, working-capital and debt-structure assumptions, projected up to seven years.

Interest expense depends on debt balances, which depend on cash flow, which depends on net income, which depends on interest expense, the classic circularity every real operating model has to solve. This one resolves it the same way a working LBO model does: by iterating to convergence rather than hardcoding an approximation, and it proves itself with a live balance-sheet check that should read exactly zero every single year.

Scenario

Revenue & Margins

Working Capital (Days)

CapEx & Depreciation

Debt Structure

Tax & Capital Policy

Starting Balance Sheet ($M)

Starting balance sheet inputs default to a balanced set. If you change them and Assets no longer equal Liabilities + Equity at Year 0, the model will still run, and the balance check on the Balance Sheet tab will show you exactly the constant offset that needs fixing.

Income Statement Summary

Base

Year 1 Revenue

-

Final-Year Revenue

-

Final-Year EBITDA Margin

-

Final-Year Net Income

-

Revenue, EBITDA & Net Income Trend

RevenueEBITDANet Income

Full Income Statement ($M)

Balance Sheet Health

-

Final-Year Total Assets

-

Final-Year Net Debt

-

Final-Year Net Debt / EBITDA

-

Max Balance Check Discrepancy

-

Net Debt / EBITDA Trend

Final-Year Asset Mix

Final-Year Liabilities & Equity Mix

Full Balance Sheet ($M)

Cash Flow Summary

-

Cumulative CFO (All Years)

-

Final-Year Ending Cash

-

Final-Year Revolver Balance

-

Peak Revolver Draw

-

Debt Paydown Schedule: TLA, TLB & Revolver

Term Loan ATerm Loan BRevolver

Final-Year Cash Build

Full Cash Flow Statement ($M)

Final-Year Net Income Across Scenarios (Current Assumptions Otherwise Held Constant)

Sensitivity Of Final-Year Net Income To Each Assumption

-

-

Why The Balance Check Is The Whole Point

-

What The Circularity Is Actually Solving

Interest expense should be based on the average debt balance across the year, but the ending balance depends on the revolver draw or paydown, which depends on cash flow, which depends on net income, which depends on interest expense. Rather than approximate this with a beginning-balance-only shortcut, or building an Excel-style circular reference with iterative calculation turned on, this model runs the same loop directly: guess, compute, feed the result back in, and repeat until the number stops moving. Thirty iterations is comfortably more than enough for this to converge to machine precision for any realistic input set.

Reading The Leverage Trend

-

What The Revolver Is Actually Telling You

-

Corporate Finance & Credit Modeling

The Core Architecture

EBITDA = Revenue × (1 − COGS% − SG&A%)
D&At = Gross PP&Et−1 / Useful Life
ΔWorking Capital = ΔAR + ΔInventory − ΔAP, where AR=Rev×DSO/365, Inv=COGS×DIO/365, AP=COGS×DPO/365
CFO = Net Income + D&A − ΔWorking Capital
Revolver Draw/(Paydown) = the plug that keeps ending cash at the minimum cash target, bounded by revolver capacity
Interest Expense = Σ Average Balancei × Ratei, solved iteratively against ending balances that depend on it

When To Actually Use This Model

  • Teaching integrated financial statement modeling, the core skill tested in every investment banking and private equity technical interview.
  • Building intuition for how a revolver, minimum cash covenant, and mandatory amortization schedule interact under different operating scenarios.
  • Stress-testing a company's or a deal's financing structure across base, upside and downside operating cases before committing real capital.

Key Assumptions & Limitations

  • Depreciation is modeled as a flat percentage of beginning gross PP&E rather than tracked capex-vintage by capex-vintage, a common simplification for models at this level of granularity.
  • Taxes are computed on positive EBT only, with no benefit for losses and no net operating loss carryforward tracking, a simplification versus a full tax schedule.
  • Working capital is driven purely by DSO/DIO/DPO ratios against revenue and COGS, real models often build a full schedule by account and customer/vendor cohort.
  • This model omits share count, EPS, and equity issuance/buyback mechanics to keep the parameter set focused on the operating and credit story.

Foundational References

Rosenbaum, J., & Pearl, J. Investment Banking: Valuation, LBOs, M&A, and IPOs. Wiley.

Benninga, S. Financial Modeling. MIT Press.

Want to layer an LBO return on top of this?

Open The LBO Return Modeler →