skills.rest
open-neko
open-nekoOFFICIAL
Explore all skills by this author →
GitHub

dcf-model

Build DCF valuation models with live Excel workbooks and sensitivity tables.

11|Updated May 6, 2026
Search Tags:#financial modeling#excel#valuation#sensitivity analysis#dcf#wacc#equity analysis
One-click install
npx skills add https://github.com/open-neko/openneko --skill dcf-model-open-neko
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dcf-model
Source: https://github.com/open-neko/openneko/tree/main/packages/llm/assets/builtin-skills/dcf-model
Command: npx skills add https://github.com/open-neko/openneko --skill dcf-model-open-neko

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill eliminates the hours of manual, error-prone work required to build institutional-quality DCF valuation models that meet investment banking standards, removing the risk of formula errors, inconsistent scenario logic, and incomplete sensitivity analysis.

Core Features & Use Cases

  • Full DCF Workflow: Guides end-to-end model building from data retrieval and historical analysis to revenue projections, FCF calculation, WACC computation, terminal value, and equity bridging.
  • Scenario & Sensitivity Analysis: Supports Bear/Base/Bull case modeling with consolidated assumption blocks, plus auto-generated 5x5 sensitivity tables for key valuation drivers.
  • Use Case: An equity analyst can use this Skill to generate a client-ready DCF model for a public company in minutes, with all formulas live, cell comments sourced, and zero manual formula entry required.

Quick Start

Use the dcf-model skill to build a complete DCF valuation model for [Company Ticker] using the latest available financial data and consensus growth assumptions.

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 without manual formula errors?▼

You can generate an institutional-grade DCF valuation model in Excel with formula-driven projections, WACC calculations, and terminal value bridging automatically, ensuring zero manual formula entry errors.

How do you calculate WACC and terminal value for a discounted cash flow analysis?▼

A discounted cash flow analysis calculates WACC by computing the weighted cost of capital and derives terminal value to bridge equity value, following investment banking standards for accurate equity analysis.

Can I run sensitivity analysis and Bear/Base/Bull scenarios for equity valuation in Excel?▼

Yes, you can build equity valuation models featuring Bear/Base/Bull scenario blocks with consolidated assumptions and auto-generated 5x5 sensitivity tables for key valuation drivers directly in Excel.

What is the best way to create an institutional-quality DCF model for private company valuation?▼

The best way to create an institutional-quality DCF model for private company valuation is using automated generation that produces live Excel workbooks with sourced cell comments and investment banking standards compliance.

Does the generated DCF model work with openpyxl for live Excel formula updates?▼

Yes, the generated DCF model is fully compliant with openpyxl and excel-author conventions, ensuring all Excel workbook formulas remain live and function correctly without formula errors.

Related Skills

Explore More Finance & Accounting Skills→
ynulihaoynulihao
564

creating-financial-models

Create DCF models with sensitivity testing and Monte Carlo simulations.

Community
Advanced
anilcan-karaanilcan-kara

dcf-model

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

Community
Advanced
NITISH-gitbitNITISH-gitbit

lbo-model

Automate leveraged buyout model creation in Excel with openpyxl.

Community
Advanced
hmzainjamilhmzainjamil
1

dcf-valuation

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

Community
Advanced