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.







