DCF Valuation
Build a defensible discounted cash flow model as an Excel workbook, with calculation integrity
and decision readiness reported as two separate verdicts.
When NOT to Use
- Comparable-company screens or precedent-transaction analysis with no DCF —
outside this skill's scope.
- LBO sponsor returns — use
lbo-model; filling an existing three-statement template —
use 3-statements. Merger/accretion-dilution analysis — outside this skill's scope.
- Internal budgets, forecasts, expense trackers, or any non-valuation spreadsheet → use
xlsx
- Reviewing or fixing an existing deck → use
pptx
- General finance questions with no model deliverable — answer inline
Workflow
1. Preflight: source discovery (once per session, cache the result)
Check only the sources needed for this request, once per session. User-supplied
inputs come first; do not enumerate connections or call Power BI when they suffice.
For sources still needed, check what is reachable before assuming anything:
powerplatform-ListConnections — is there a usable connection at all?
powerplatform-FindConnectors — look only for what a DCF needs: a live Excel read
(shared_excelonlinebusiness), and any market/financial data source.
- Note availability of Power BI (
pbi_fabricaihub-*) and Dataverse for internal actuals.
There is normally no market-data connector. When none is reachable, fall back to
host-web_search and label every market input as web-sourced with the retrieval date. Never
present a web-sourced figure as if it came from a data feed.
2. Intake: new workbook or update in place
If the user attached or named an existing workbook, ask once with core-AskUserQuestion:
build a new dated workbook (reads theirs as input, leaves it untouched) or update theirs in
place (preserves their formatting and downstream links, but overwrites a live file). Never
guess — guessing "update" is destructive.
If nothing was attached, do not ask. Build fresh.
3. Gather inputs — source ladder, in this order
- Uploaded files — check
input/ first, always. Read with xlsx/pdf handling.
- SharePoint / OneDrive —
sharepoint_onedrive-SearchDrive and m365_search-SearchM365
for existing models, filings, and board materials. Use the Excel Online connector for a
live cell-level read when the user wants their working model treated as the source.
- Power BI / Dataverse — internal actuals where the company is the user's own or a
portfolio company.
- Web search — market data only (share price, risk-free rate, comps). Timestamp everything.
Never fabricate a number. A missing input becomes a clearly marked placeholder such as
[Add FY25 EBITDA], and the placeholder count drives the readiness gate in step 6.
4. Build the workbook with xlsx
Invoke the xlsx skill, or delegate to xlsx-agent, to build the workbook directly. Tab order is
fixed — see references/workbook-spec.md. Methodology (FCFF build,
CAPM, both terminal-value methods, the bridge, the reverse-DCF) is in
references/dcf-method.md.
- Live formulas everywhere downstream of an input. Every calculated cell references the
Assumptions & Sources tab; never paste computed results.
- Never substitute a default for a placeholder. An unresolved input stays visibly marked
(
[Add FY25 EBITDA]), and every cell that depends on it shows as not computable rather than
being filled with an assumed value to make the grid or the reverse-DCF compute.
- The sensitivity grid recalculates live. Each grid cell is its own formula over the FCF Build
rows at that cell's WACC and terminal growth (for example, SUMPRODUCT of FCF and discount
factors plus the discounted terminal value), so the centre cell equals the base case by
construction.
- The reverse-DCF is solved against the live model. Implied terminal growth has a closed form
and stays a live formula. For WACC or an operating assumption, solve iteratively against the
recalculated model and label the result as a solved value with its date and the inputs used.
- Recalculate with the xlsx workflow's supported recalculation before reading any value, then
deliver through the xlsx workflow.
5. Read the checks before describing anything
Run the check battery in the method reference against the recalculated workbook and record each
result on the Checks tab. Never narrate success from the fact that the workbook was built.
Report each check as PASS, FAIL, NOT RUN or NOT APPLICABLE with evidence. Missing evidence is
NOT RUN, never PASS; unresolved inputs, unsourced assumptions, future/stale dates or failed checks
force Screen-grade. A material failed check blocks the model.
6. Gate: two separate verdicts
The Summary tab carries two explicitly labeled fields that are allowed to disagree:
- Calculation integrity — tie-outs, formula-error scan, discounting consistency, bridge math.
- Decision readiness — evidence quality. Forced to Screen-grade whenever the placeholder
count is above zero, a market input is stale, or terminal assumptions are unsupported.
A workbook whose formulas all pass is not "OK" while forecast, WACC, terminal value, bridge, or
share-count evidence remains open. Say so plainly.
7. Rating and reverse-DCF
Only for a resolved, positive-price, positive-equity case, calculate the fixed
threshold analytical label from the method reference, never a personalized trade
recommendation. If inputs or verification are unresolved, emit No rating — not
verified instead of an actionable Buy/Hold/Sell. Same verified numbers must
produce the same analytical label. When readiness is Screen-grade, render it as
"Indicative — Screen-grade" and name the unresolved inputs.
Whenever the rating is Buy or Sell, the reverse-DCF is mandatory: hold the framework constant
and solve for the operating assumption, WACC, or terminal growth that reconciles to the current
price. State it as "the market is implying X" rather than "the market is wrong." Proximity to a
downside or upside scenario is not a substitute for this test.
8. Companions
- PowerPoint — build automatically only when the request names an audience ("for the
investment committee", "for the board", "I'm presenting this", "send to the client"). Otherwise
build the workbook only and close with a one-line offer: "Want this as a committee deck?"
- HTML — only on explicit request.
- Every companion is generated from the Checks tab and workbook outputs, never from chat
recollection, and carries the readiness stamp on its first slide or header.
- Render and visually inspect a companion before delivering it.
Output Format
Hero: model.xlsx, opening on Summary.
Companion: dcf_summary.pptx when audience signal is present; HTML on request.
Chat response leads with the valuation range, the implied premium/discount to current price, the
two readiness verdicts, the top three value drivers, and open items — in that order. Cite headline
outputs to workbook tab and cell.
Guardrails
- Never fabricate financials, share counts, prices, betas, or comps. Placeholder instead.
- Never overwrite a user's workbook without asking (step 2).
- Never send, email, or post the model or deck anywhere — deliver to
output/ only.
- Every market input carries a source label and retrieval date; flag any input past its staleness
window on the Summary tab.
- Headline outputs (EV, equity value, per-share value, premium/discount, solved assumption) must
trace to their upstream operating, WACC, terminal, bridge, share-count, and market inputs.
- Do not present a rating without the readiness verdict next to it.
- This is analytical support, not investment advice — state that on the Summary tab.
1---2name: "dcf-valuation"3description: >-4 Builds discounted cash flow valuation models as banker-readable Excel5 workbooks with live formulas, a WACC x terminal-growth sensitivity grid, a6 reverse-DCF, and an explicit readiness gate. Use when the user asks to "build7 a DCF", "what is this company worth on a DCF basis", "run the WACC and8 terminal value", "what is the intrinsic value per share", or "what is the9 market implying". Do NOT use for LBO sponsor returns (use lbo-model),10 completing an existing three-statement template (use 3-statements), peer11 trading multiples, or non-valuation spreadsheets (use xlsx).12metadata:13 source: https://skillmd.com/skills/microsoft/dcf-valuation14 icon: CalculatorMultiple15---1617# DCF Valuation1819Build a defensible discounted cash flow model as an Excel workbook, with calculation integrity20and decision readiness reported as two separate verdicts.2122## When NOT to Use2324- Comparable-company screens or precedent-transaction analysis with no DCF —25 outside this skill's scope.26- LBO sponsor returns — use `lbo-model`; filling an existing three-statement template —27 use `3-statements`. Merger/accretion-dilution analysis — outside this skill's scope.28- Internal budgets, forecasts, expense trackers, or any non-valuation spreadsheet → use `xlsx`29- Reviewing or fixing an existing deck → use `pptx`30- General finance questions with no model deliverable — answer inline3132## Workflow3334### 1. Preflight: source discovery (once per session, cache the result)3536Check only the sources needed for this request, once per session. User-supplied37inputs come first; do not enumerate connections or call Power BI when they suffice.38For sources still needed, check what is reachable before assuming anything:3940- `powerplatform-ListConnections` — is there a usable connection at all?41- `powerplatform-FindConnectors` — look only for what a DCF needs: a live Excel read42 (`shared_excelonlinebusiness`), and any market/financial data source.43- Note availability of Power BI (`pbi_fabricaihub-*`) and Dataverse for internal actuals.4445There is normally **no market-data connector**. When none is reachable, fall back to46`host-web_search` and label every market input as web-sourced with the retrieval date. Never47present a web-sourced figure as if it came from a data feed.4849### 2. Intake: new workbook or update in place5051**If the user attached or named an existing workbook, ask once** with `core-AskUserQuestion`:52build a new dated workbook (reads theirs as input, leaves it untouched) or update theirs in53place (preserves their formatting and downstream links, but overwrites a live file). Never54guess — guessing "update" is destructive.5556If nothing was attached, do not ask. Build fresh.5758### 3. Gather inputs — source ladder, in this order59601. **Uploaded files** — check `input/` first, always. Read with `xlsx`/`pdf` handling.612. **SharePoint / OneDrive** — `sharepoint_onedrive-SearchDrive` and `m365_search-SearchM365`62 for existing models, filings, and board materials. Use the Excel Online connector for a63 live cell-level read when the user wants their working model treated as the source.643. **Power BI / Dataverse** — internal actuals where the company is the user's own or a65 portfolio company.664. **Web search** — market data only (share price, risk-free rate, comps). Timestamp everything.6768**Never fabricate a number.** A missing input becomes a clearly marked placeholder such as69`[Add FY25 EBITDA]`, and the placeholder count drives the readiness gate in step 6.7071### 4. Build the workbook with xlsx7273Invoke the `xlsx` skill, or delegate to `xlsx-agent`, to build the workbook directly. Tab order is74fixed — see [references/workbook-spec.md](references/workbook-spec.md). Methodology (FCFF build,75CAPM, both terminal-value methods, the bridge, the reverse-DCF) is in76[references/dcf-method.md](references/dcf-method.md).7778- **Live formulas everywhere downstream of an input.** Every calculated cell references the79 Assumptions & Sources tab; never paste computed results.80- **Never substitute a default for a placeholder.** An unresolved input stays visibly marked81 (`[Add FY25 EBITDA]`), and every cell that depends on it shows as not computable rather than82 being filled with an assumed value to make the grid or the reverse-DCF compute.83- **The sensitivity grid recalculates live.** Each grid cell is its own formula over the FCF Build84 rows at that cell's WACC and terminal growth (for example, SUMPRODUCT of FCF and discount85 factors plus the discounted terminal value), so the centre cell equals the base case by86 construction.87- **The reverse-DCF is solved against the live model.** Implied terminal growth has a closed form88 and stays a live formula. For WACC or an operating assumption, solve iteratively against the89 recalculated model and label the result as a solved value with its date and the inputs used.90- Recalculate with the xlsx workflow's supported recalculation before reading any value, then91 deliver through the xlsx workflow.9293### 5. Read the checks before describing anything9495Run the check battery in the method reference against the recalculated workbook and record each96result on the Checks tab. **Never narrate success from the fact that the workbook was built.**97Report each check as PASS, FAIL, NOT RUN or NOT APPLICABLE with evidence. Missing evidence is98NOT RUN, never PASS; unresolved inputs, unsourced assumptions, future/stale dates or failed checks99force Screen-grade. A material failed check blocks the model.100101### 6. Gate: two separate verdicts102103The Summary tab carries two explicitly labeled fields that are allowed to disagree:104105- **Calculation integrity** — tie-outs, formula-error scan, discounting consistency, bridge math.106- **Decision readiness** — evidence quality. Forced to **Screen-grade** whenever the placeholder107 count is above zero, a market input is stale, or terminal assumptions are unsupported.108109A workbook whose formulas all pass is *not* "OK" while forecast, WACC, terminal value, bridge, or110share-count evidence remains open. Say so plainly.111112### 7. Rating and reverse-DCF113114Only for a resolved, positive-price, positive-equity case, calculate the fixed115threshold analytical label from the method reference, never a personalized trade116recommendation. If inputs or verification are unresolved, emit **No rating — not117verified** instead of an actionable Buy/Hold/Sell. Same verified numbers must118produce the same analytical label. When readiness is Screen-grade, render it as119**"Indicative — Screen-grade"** and name the unresolved inputs.120121Whenever the rating is Buy or Sell, the reverse-DCF is **mandatory**: hold the framework constant122and solve for the operating assumption, WACC, or terminal growth that reconciles to the current123price. State it as "the market is implying X" rather than "the market is wrong." Proximity to a124downside or upside scenario is not a substitute for this test.125126### 8. Companions127128- **PowerPoint** — build automatically **only when the request names an audience** ("for the129 investment committee", "for the board", "I'm presenting this", "send to the client"). Otherwise130 build the workbook only and close with a one-line offer: "Want this as a committee deck?"131- **HTML** — only on explicit request.132- Every companion is generated **from the Checks tab and workbook outputs**, never from chat133 recollection, and carries the readiness stamp on its first slide or header.134- Render and visually inspect a companion before delivering it.135136## Output Format137138**Hero:** `model.xlsx`, opening on Summary.139**Companion:** `dcf_summary.pptx` when audience signal is present; HTML on request.140141Chat response leads with the valuation range, the implied premium/discount to current price, the142two readiness verdicts, the top three value drivers, and open items — in that order. Cite headline143outputs to workbook tab and cell.144145## Guardrails146147- Never fabricate financials, share counts, prices, betas, or comps. Placeholder instead.148- Never overwrite a user's workbook without asking (step 2).149- Never send, email, or post the model or deck anywhere — deliver to `output/` only.150- Every market input carries a source label and retrieval date; flag any input past its staleness151 window on the Summary tab.152- Headline outputs (EV, equity value, per-share value, premium/discount, solved assumption) must153 trace to their upstream operating, WACC, terminal, bridge, share-count, and market inputs.154- Do not present a rating without the readiness verdict next to it.155- This is analytical support, not investment advice — state that on the Summary tab.