skills.rest
MuzeWinter
MuzeWinterCOMMUNITY
Explore all skills by this author →
GitHub

dcf-model-builder

Build FCFF and FCFE DCF valuation workbooks with WACC and terminal value.

1|2|Updated Jun 16, 2026
Search Tags:#excel#valuation#dcf#wacc#investment banking#terminal value#equity bridge
One-click install
npx skills add https://github.com/MuzeWinter/CooperAPI-Plugin --skill dcf-model-builder-muzewinter
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model-builder
Source: https://github.com/MuzeWinter/CooperAPI-Plugin/tree/main/plugins/investment-banking/skills/dcf-model-builder
Command: npx skills add https://github.com/MuzeWinter/CooperAPI-Plugin --skill dcf-model-builder-muzewinter

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill turns raw financial inputs and valuation assumptions into a structured, code-backed DCF export, removing the manual work of building intrinsic valuation models from scratch.

Core Features & Use Cases

  • DCF Valuation Workflows: Build FCFF or FCFE models with WACC, terminal value, EV-to-equity bridges, and per-share outputs.
  • Workbook and Export Delivery: Generate banker-readable Excel workbooks, deterministic exports, and optional HTML valuation companions.
  • Validation and QA: Check plan structure, source readiness, scenario consistency, sensitivities, and calculation integrity before delivery.
  • Use Case: A banker can use this Skill to produce a public-company price target model with downside, base, and upside cases, then review sensitivities and bridge assumptions in a polished workbook.

Quick Start

Use the dcf-model-builder skill to build a DCF valuation workbook for the target company and return the valuation range, key assumptions, and decision-readiness status.

Frequently Asked Questions about dcf-model-builder

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I build a DCF valuation model with WACC and terminal value in Excel?▼

You build a DCF valuation model by inputting validated financial assumptions, which generates a formula-driven Excel workbook calculating FCFF or FCFE, WACC, terminal value, and the EV-to-equity bridge.

What is the difference between FCFF and FCFE intrinsic valuation workflows?▼

FCFF intrinsic valuation discounts free cash flow to the firm at WACC to find enterprise value, while FCFE discounts cash flow to equity holders to derive equity value directly, both requiring distinct terminal value and bridge calculations.

How do I calculate an EV-to-equity bridge and per-share outputs for a price target?▼

Calculating an EV-to-equity bridge involves subtracting net debt and other adjustments from enterprise value to determine equity value, which is then divided by share count to produce per-share outputs and price targets.

Can I generate scenario sensitivities and downside cases for investment banking valuations?▼

Yes, you can generate scenario sensitivities for investment banking valuations by running downside, base, and upside cases, allowing you to review calculation integrity and bridge assumptions before delivery.

Does this DCF model builder support deterministic exports and HTML valuation companions?▼

Yes, the DCF model builder supports deterministic exports and optional HTML valuation companions alongside the primary Excel workbook, ensuring calculation integrity, logs, and citation-ready provenance for financial analysis.

What validated plan inputs and source-backed assumptions are needed for DCF calculations?▼

DCF calculations require validated plan inputs and source-backed assumptions for revenue growth, margins, WACC components, and terminal value rates to execute deterministic or formula-mode workflows with proper QA checks.

Related Skills

Explore More Finance & Accounting Skills→
ynulihaoynulihao
564

creating-financial-models

Create DCF models with sensitivity testing and Monte Carlo simulations.

Community
Advanced
cxnaivecxnaive

merger-model

Build M&A accretion and dilution analysis workbooks in Excel format.

Community
Advanced
devMoezdevMoez
1

comps-analysis

Build an Excel workbook with formula-driven operating metrics and valuation multiples for peer-set benchmarking.

Community
Advanced
zeronx798zeronx798

lbo-model

Construct dynamic leveraged buyout models in Excel with formula-driven calculations.

Community
Advanced