skills.rest
anilcan-kara
anilcan-karaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

dcf-model

Build institutional-quality DCF valuation models in Excel with live formulas.

Updated Jun 17, 2026
Search Tags:#excel#valuation#financial-modeling#dcf#sensitivity-analysis#wacc#equity-valuation
One-click install
npx skills add https://github.com/anilcan-kara/nozich-agent --skill dcf-model-anilcan-kara
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/anilcan-kara/nozich-agent/tree/main/optional-skills/finance/dcf-model
Command: npx skills add https://github.com/anilcan-kara/nozich-agent --skill dcf-model-anilcan-kara

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manual DCF valuation modeling is often tedious, error-prone, and hard to scale across multiple scenarios. This Skill provides a repeatable framework to build institutional-quality Excel models with live formulas, Bear/Base/Bull outcomes, and 5x5 sensitivity tables.

Core Features & Use Cases

  • Build end-to-end DCF models in Excel following investment-banking standards.
  • Support revenue projections, FCF builds, WACC calculations, terminal value, and scenario analysis (Bear/Base/Bull) with 5x5 sensitivity tables.
  • Aligns with excel-author conventions to ensure deterministic formula outputs and reproducible recalculation.

Quick Start

Provide company inputs and run the generated DCF model to produce a full valuation.

Frequently Asked Questions about dcf-model

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

FAQPage Schema
How do I build a DCF valuation model in Excel with live formulas?▼

DCF valuation modeling in Excel is automated through live formula construction, covering revenue projections, FCF builds, WACC calculations, and terminal value to produce deterministic, reproducible equity valuations.

How does sensitivity analysis work for DCF models?▼

Sensitivity analysis for DCF models generates 5x5 data tables that test valuation resilience against changing inputs, providing Bear, Base, and Bull scenario outcomes for comprehensive equity value assessment.

Can I use Excel for institutional-quality financial modeling with mid-year discounting?▼

Excel supports institutional-quality financial modeling by applying mid-year discounting conventions to present value of FCFs and terminal value calculations, yielding precise equity value outputs aligned with investment-banking standards.

What is the best way to automate Bear, Base, and Bull scenario analysis in a DCF model?▼

Automating Bear, Base, and Bull scenario analysis in a DCF model requires a repeatable framework that applies deterministic projections and live formulas, producing comprehensive valuation outputs across multiple scenarios.

Does this DCF modeling approach require manual formula entry for WACC and FCF builds?▼

DCF modeling with this approach eliminates manual formula entry errors by applying automated live formula construction for WACC calculations and FCF builds, ensuring deterministic and reproducible recalculation.

Related Skills

Explore More Finance & Accounting Skills→
luisschmitzheadlineluisschmitzheadline
23

creating-financial-models

Automate DCF, sensitivity, Monte Carlo, and scenario financial models.

Community
Advanced
JoeyJoziahJoeyJoziah

financial-modeling

Build DCF, comparable company, and LBO financial models with sensitivity testing.

Community
Advanced
KaakatiKaakati
3

valuation

Perform multi-method business valuation using DCF, comparable companies, and precedent transactions.

Community
Advanced
hmzainjamilhmzainjamil
1

dcf-valuation

Build discounted cash flow valuation models from historical financials and forecast assumptions.

Community
Advanced