Dcf Valuation

Builds discounted cash flow valuation models as banker-readable Excel workbooks with live formulas, a WACC x terminal-growth sensitivity grid, a reverse-DCF, and an explicit readiness gate. Use when the user asks to "build a DCF", "what is this company worth on a DCF basis", "run the WACC and terminal value", "what is the intrinsic value per share", or "what is the market implying". Do NOT use for LBO sponsor returns (use lbo-model), completing an existing three-statement template (use 3-statements), peer trading multiples, or non-valuation spreadsheets (use xlsx).

110 stars 122 forksDocuments & Office FilesOfficial

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add microsoft/cat-agent-skills --skill dcf-valuation
Manual install
git clone --depth 1 https://github.com/microsoft/cat-agent-skills.git /tmp/cat-agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/cat-agent-skills/submissions/finance-for-cowork/skills/dcf-valuation ~/.claude/skills/dcf-valuation

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# 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
Read the full skill on GitHub

Details

Skill name
dcf-valuation
Path
submissions/finance-for-cowork/skills/dcf-valuation/SKILL.md
License
MIT
Repo updated
15 November 2026

FAQ

What does the Dcf Valuation skill do?

Builds discounted cash flow valuation models as banker-readable Excel workbooks with live formulas, a WACC x terminal-growth sensitivity grid, a reverse-DCF, and an explicit readiness gate. Use when the user asks to "build a DCF", "what is this company worth on a DCF basis", "run the WACC and terminal value", "what is the intrinsic value per share", or "what is the market implying". Do NOT use for LBO sponsor returns (use lbo-model), completing an existing three-statement template (use 3-statements), peer trading multiples, or non-valuation spreadsheets (use xlsx).

How do I install the Dcf Valuation skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add microsoft/cat-agent-skills --skill dcf-valuation. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Dcf Valuation popular?

It lives in microsoft/cat-agent-skills, which has 110 GitHub stars and 122 forks.

Related skills

3 Statements

110

microsoft/cat-agent-skills

Completes existing income statement, balance sheet and cash flow templates while preserving layout, grounding historical inputs and linking forecast formulas with reconciliation checks. Use for "fill in a 3-statement template", "complete an IS/BS/CF framework", "populate my integrated financial model", "link statements in this template", or "finish the forecasts in my three-statement workbook". Do NOT use for blank-slate models or general workbook edits (use xlsx), DCF valuation (use dcf-valuation), or buyout modeling (use lbo-model).

AI, LLMs & Agents122

Accessibility Pass

110

microsoft/cat-agent-skills

Use this skill whenever the user asks to check, review, or fix the accessibility of a PowerPoint deck, Word document, HTML page, or Markdown file, and before handing over any deck or document this agent just generated, so it does not ship with missing alt text, untitled slides, or unreadable colour contrast.

Frontend & Design122

Accessible Learning Materials

110

microsoft/cat-agent-skills

Maintains instructionally equivalent, accessible variants of a set of learning materials — lessons, readings, slides, and handouts — with parity checks against the original learning goals and recorded approvals. Use when the user asks to "make these materials accessible", "audit this lesson set for accessibility", "create an accessible version of this reading", "check reading level and alt text", or "keep my accessible variants in sync". Do NOT use for individual student accommodation or support-plan decisions (IEP, EHCP, or local equivalent), and do NOT use for generic document formatting (us

Learning & Education122

Doc Format Converter

110

microsoft/cat-agent-skills

Use this skill whenever the user asks to convert a document or file from one format to another — Markdown, HTML, PDF, Word (.docx), PowerPoint (.pptx), Excel (.xlsx), CSV, or plain text (e.g. "turn this Word doc into a PDF", "make slides from this markdown", "save this page as markdown"). Only for producing a converted file as a deliverable. Do NOT use this skill to answer questions about a document's content — the analyzing-* skills handle that. Run the bundled scripts/convert.py instead of writing ad-hoc conversion code, BEFORE attempting any conversion yourself.

Documents & Office Files122

Dataset Analysis Report

110

microsoft/cat-agent-skills

Takes messy spreadsheet or CSV files, inventories them, profiles the join keys, cleans and joins the data, analyzes it with charts where useful, and ships an answer-first report that leads with the finding and states its caveats. Use when the user asks to "analyze these spreadsheets", "join these CSV files", "what does this data show", "clean and combine these exports", or "build a report from this data". Do NOT use for building a blank workbook or tracker (use xlsx), valuation modeling (use dcf-valuation), completing a three-statement template (use 3-statements), or reporting from a published

Documents & Office Files122

Exec Update

110

microsoft/cat-agent-skills

Compresses content you already have into an executive-ready update: strict TL;DR / Key numbers / Risks / Ask structure, ~150 words, answer first. Use when the user asks to "turn this into an exec update", "summarize this for my VP", "make this leadership-ready", "give me a TL;DR for the CFO", or "compress this into a status note". Do NOT use for assembling an update from your own recent activity, org-wide announcements, long-form reports (use docx), or analysis that does not exist yet.

Documents & Office Files122

Browse the most popular Claude skills, all documents & office files skills, or write your own with the skills generator.