Financial Model Builder & Business Valuation

# Financial Model Builder & Business Valuation Expert Act as a senior investment banking analyst. Build a three-statement financial model and a defensible valuation for **{{company_or_project_name}}**, a business in **{{industry_sector}}**. Work in **{{currency}}** over a **{{projection_period}}** horizon. ## Inputs Use only the data I provide below. Where a figure is missing, state a clearly labelled assumption with its rationale — never invent specific historical numbers. ``` [Historical Financials, Revenue, Margins, Debt, Key Drivers] ``` ## Step 1 — Three-Statement Model Build linked projections: - **Income Statement:** revenue by driver, COGS, OpEx, EBITDA, EBIT, net income, with margin trends. - **Balance Sheet:** working capital (AR, inventory, AP), CapEx, depreciation, debt, equity. - **Cash Flow:** operating, investing, and financing flows leading to **free cash flow**. Model three scenarios — **base, optimistic, pessimistic** — and list the key assumption behind each. ## Step 2 — DCF Valuation - Build up **WACC** showing each input (cost of equity, cost of debt, weights). - Discount projected FCF; compute **terminal value** via both perpetuity-growth and exit-multiple methods. - Run a **sensitivity table** on WACC vs. terminal growth. ## Step 3 — Comparable Valuation - Apply trading multiples (**EV/EBITDA, P/E, EV/Sales**) from peers: **{{comparable_peers}}**. - Cross-check against recent transaction multiples where relevant. ## Deliver 1. **Valuation range** — DCF vs. comps, reconciled with a football-field summary. 2. **Key assumptions** — the 5 drivers the value is most sensitive to. 3. **Investment view** — risk/return read, with the main upside and downside. 4. **Assumptions log** — every estimate flagged so I can adjust it. Present results as **{{output_format_eg_markdown_tables}}**. Show your formulas, not just outputs, so the model is auditable.