The Analyst's Integrated Financial Model
Integrated IS, Balance Sheet & Cash Flow — 8-Year Model
Professional-grade 3-statement model with 3 years of historical actuals and 5-year projections. All three statements are fully linked — change one assumption, and everything updates.
6 tabs included:
README — Color guide & instructions
Assumptions — All inputs in one dashboard (growth, margins, DSO/DIO/DPO, CapEx, tax)
Income Statement — Revenue → Gross Profit → EBITDA → Net Income → EPS
Balance Sheet — Full asset/liability/equity schedule, WC auto-calculated
Cash Flow — CFO/CFI/CFF, FCF, FCF margin
Output Summary — One-page KPI dashboard, auto-populates
Built for: IB analysts, FP&A professionals, corporate finance teams, MBA students.
Use it to: Build 5-year projections, run bull/base/bear scenarios, or use as the foundation for a DCF or LBO model.
Color-coded to Wall Street standards: blue = inputs, black = formulas, green = cross-sheet links.
Built by an MBA candidate with PE investment analysis experience across institutional transactions.







