OXFORD VALUATION PARTNERS Draft D1

Purpose

This form builds a draft 409A (gap list + Draft D1). It does not issue a signed Final. Equity value is the weighted conclusion of DCF, guideline public companies, and/or a supplied invested-capital figure, then allocated with OPM. Beige Book text feeds current economic conditions.

1. Company

2. Files (names go in the appendix; only CSV is parsed)

The logo sits on the front cover (same place as the client brand on the Word template). If you skip it, a dashed placeholder is used.

3. Value and last round

Leave supplied equity blank if DCF or GPC will produce the conclusion. OPM still needs a positive equity value from one of those methods.

4. Cap table (shares)

Preferred liquidation preference is aggregate, not per share. Options are fully diluted unissued/pool + outstanding options (treated as one option class at zero strike for this MVP unless you enter a strike below).

6. WACC (DCF In.)

Matches the workfile: CAPM = RF + β×ERP + size + company-specific, rounded to 50 bps; build-up = RF+ERP+industry+size+SRP; WACC = we×ke + wd×kd×(1−t). Private-venture rate is a selected alternative (often 40% for early-stage).

7. DCF (income approach)

Same roll-forward as DCF_GG / DCF_ExitMult: NOPAT after NOL, FCF = NOPAT + D&A + other non-cash + equity financing − capex − ΔNWC, mid-year (stub year uses days to first FYE / 365). Gordon TV = FCFn×(1+g)/(WACC−g). Exit TV = 50/50 last-year revenue and EBITDA × selected multiples after GPC size adjustment. Equity = NPV − debt + cash.

Projection years (WC % as a decimal, e.g. 0.12). Blank years are skipped.

YearRevenueCOGSOpex (ex D&A)D&ACapexEq. financingNCCWC % sales

8. Guideline public companies (GPC)

GL Comps - Final: concluded multiple × (1 − size adjustment) × subject metric, then − debt + cash. Two indicators, default equal weight. Paste the median (or selected) multiple from the comps set; the full CapIQ screen stays in the workfile.

9. Equity conclusion weights

Leave blank to split evenly across whichever of DCF, GPC, and supplied equity actually produced a number (this workbook’s sample was 100% DCF exit-multiple).

10. Beige Book / current economic conditions

Not a number in the Excel workfile — it is the economic-overview source for D1. Default is the February 2026 national summary plus New York District. Swap in the edition nearest the valuation date (a new book was scheduled 2 Sep 2026). UK drafts: replace with a Bank of England Monetary Policy Report extract.

5. OPM assumptions

Previous drafts

CompanyValuation dateFMV / shareCreated
xyz Corp 2005-05-06 — 3 Sep 2026 00:56 Open preview
xyz Corp 2005-05-06 — 2 Sep 2026 20:22 Open preview
xyz Corp 2019-05-05 $6.11 2 Sep 2026 17:00 Open preview
xyz Corp 2019-05-05 $6.11 2 Sep 2026 16:51 Open preview
xyz Corp 2019-05-05 $6.11 2 Sep 2026 16:48 Open preview
xyz Corp 2019-05-05 $6.11 2 Sep 2026 16:47 Open preview
xyz Corp 2019-05-05 $6.11 2 Sep 2026 16:43 Open preview
xyz Corp 2019-05-05 $6.11 2 Sep 2026 16:37 Open preview
xyz Corp 2019-05-05 $6.11 2 Sep 2026 16:20 Open preview
rrrr 2026-02-03 $0.04 2 Sep 2026 16:19 Open preview
rrrr 2026-02-03 $0.04 2 Sep 2026 15:45 Open preview
xyz Corp 2019-05-05 $6.11 2 Sep 2026 15:44 Open preview
xyz Corp 2019-05-05 $6.11 2 Sep 2026 15:38 Open preview
xyz Corp 2019-05-05 $6.11 2 Sep 2026 15:35 Open preview
Example Bio Ltd 2026-09-01 £0.74 2 Sep 2026 15:34 Open preview