Create a DCF Valuation Tab

Build a DCF tab with the following structure:

1. Header & Timeline Infrastructure

Row 1: Sheet name (dynamic formula)
Currency/FYE header row (e.g., "£'000 | FYE 31/03")
Timeline infrastructure rows: Period Start, Period End, Financial Year (minimum)
2. Units Column Include a units column (typically Column F) immediately after labels, showing:

£ for currency values
% for percentages/ratios
x for multiples
# for counts Units column should be center-aligned and inherit row formatting.
3. Summary Financials Link from the model and show each metric with supporting ratios underneath:

Revenue (+ YoY Growth %)
EBITDA (+ Margin % of Revenue)
D&A (+ % of Revenue)
EBIT (+ Margin % of Revenue)
Taxes (+ % of EBIT)
Capex (+ % of Revenue)
Change in NWC (+ % of Revenue)
Unlevered FCF (+ YoY Growth %, % of EBIT, % of Revenue)
UFCF Calculation: EBITDA − D&A = EBIT − Tax = NOPAT + D&A − Change in NWC − Capex

4. Supporting Schedules

NWC Schedule: Current Assets and Current Liabilities line items, calculating Net Working Capital and Change in NWC
Net Debt Schedule: Cash & Equivalents and Debt line items, calculating Net Debt
5. WACC Assumptions Placeholder inputs for: Risk-Free Rate, Equity Risk Premium, Beta → Cost of Equity; Cost of Debt, Tax Rate → Post-Tax Cost of Debt; Target E/(D+E) and D/(D+E) → WACC

6. DCF Valuation

Terminal value toggle (1 = Perpetuity Growth @ 3%, 2 = Exit Multiple @ 5.0x)
Mid-year discounting convention
Sum of Discounted FCFs + Discounted Terminal Value = Enterprise Value
Less Net Debt = Equity Value
Parameters: First discount year: 2026. Annual periods through 2042. Use existing workbook formatting.