use-cases/dcf-model.md +70 −0 added
1---
2name: Model a DCF valuation
3tagline: Turn financial inputs into an editable valuation workbook.
4summary: Attach historical financials, valuation assumptions, and modeling
5 notes, then ask Codex for an editable DCF workbook you can inspect and revise
6 in Codex.
7skills:
8 - token: $spreadsheets
9 description: Create editable spreadsheet workbooks from attached inputs,
10 formulas, and assumptions.
11bestFor:
12 - Analysts turning historical financials and assumptions into a DCF workbook.
13 - Finance teams that want to inspect and iterate on the workbook in Codex.
14 - Teams preparing a valuation model from source files.
15starterPrompt:
16 title: Model a DCF valuation
17 body: >-
18 Use $spreadsheets to build a DCF workbook for the company in the attached
19 source files.
20
21
22 Include explicit operating drivers for revenue growth, margins, capex, and
23 working capital. Calculate unlevered free cash flow, WACC, terminal value,
24 and enterprise value. If capital structure and diluted share count are
25 provided, bridge to implied equity value and implied equity value per share.
26
27
28 Use any assumptions included in the source files. If an assumption is
29 missing, add a clearly labeled placeholder in the assumptions tab instead of
30 hiding it in a formula. If full balance sheet or cash-flow statement inputs
31 are missing, create the operating forecast needed for unlevered free cash
32 flow and flag the missing statement inputs.
33
34
35 Generate the result as an editable .xlsx workbook.
36 suggestedEffort: medium
37relatedLinks:
38 - label: Agent skills
39 url: /codex/skills
40 - label: File inputs
41 url: /api/docs/guides/file-inputs
42---
43
44## Introduction
45
46Codex can help you create a fully functional DCF workbook that you can inspect and revise.
47
48It can use multiple files as context, including the historical financials, valuation assumptions, and any modeling notes.
49You can provide these files directly, or use file references when the inputs live in Google Drive or another connected source. If so, provide the exact file references, as it will be more effective than asking Codex to search through all of your files.
50
51## Create the workbook
52
53
54
551. Attach the historical financials, valuation assumptions, and any modeling notes, or provide exact file references along with the source.
562. Run the starter prompt and ask for an editable `.xlsx` workbook.
573. Open the generated workbook in Codex. Expand it into the full-screen view to inspect the model tabs, formulas, assumptions, and valuation summary.
584. Continue in the same thread to check formula links, change assumptions, add scenarios, or tighten the model.
59
60
61
62When the workbook appears in the thread, open it in Codex and expand it full-screen. Review the source inputs, forecast drivers, valuation outputs, and sensitivity tables, then ask Codex to revise the same workbook from there.
63
64## Check the valuation
65
66Before using the workbook, ask Codex to review the model like a finance teammate would: source tie-outs, formulas, hardcoded assumptions, and valuation outputs.
67
68## Revise one assumption
69
70After reviewing the workbook in Codex, ask for targeted revisions in the same thread. Change one driver at a time so the impact is easy to inspect.