Does it handle complex debt schedules or tax losses?

This skill creates a simplified DCF model focused on core valuation drivers. For advanced features like Net Operating Losses (NOLs) or complex capital structures, users can manually extend the generated Excel file.

Does it use real-time market data?

The skill primarily uses user-provided inputs or industry averages. While it can suggest values based on historical data provided during the chat, users should verify inputs for the most current market conditions.

What valuation methodology does this skill follow?

It follows standard investment banking and corporate finance practices, including Unlevered Free Cash Flow (UFCF) methodology and the Gordon Growth Method for terminal value.

Can I customize the assumptions after the model is built?

Yes, the model is built with a dedicated 'Assumptions' sheet where all formulas are linked, allowing you to change variables directly in Excel and see the results update instantly.

Excel DCF Modeler

Name: Excel DCF Modeler
Author: jeremylongshore

byjeremylongshore

•

883

•

데이터 과학 및 ML

Builds professional investment banking-standard discounted cash flow (DCF) valuation models directly in Excel.

The Excel DCF Modeler is a specialized tool for finance professionals and analysts that automates the creation of comprehensive 4-sheet valuation workbooks. It handles everything from multi-year free cash flow projections and WACC calculations to enterprise value estimation and two-way sensitivity analysis. By following industry best practices like tapering growth rates and conservative terminal growth, it provides a rigorous framework for valuing companies while ensuring mathematical consistency and professional formatting.

주요 기능

01Automated 4-sheet Excel workbook generation (Assumptions, FCF, Valuation, Sensitivity)

02Interactive two-way sensitivity tables for WACC and Terminal Growth Rate

03Investment banking standard formulas for WACC, NOPAT, and Terminal Value

04Professional formatting including currency, percentages, and conditional color scales

05883 GitHub stars

06Integrated validation to prevent mathematical errors like Growth exceeding WACC

사용 사례

01Rapidly prototyping valuation models for investment banking pitch decks

02Performing intrinsic value analysis for corporate finance or equity research

03Educational modeling to understand the impact of WACC and growth drivers on enterprise value

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills excel-dcf-modeler

For use in Claude.ai and ChatGPT

Download Skill