Can I provide my own specific revenue and margin assumptions?

Yes, the skill allows you to input specific revenue growth, EBITDA margins, CapEx, and tax rates, or it can provide industry-standard defaults if you are unsure.

Are the formulas in the Excel file hard-coded?

No, the model follows professional auditing standards where calculations in the FCF and Valuation sheets are dynamically linked to the Assumptions sheet.

Does it calculate WACC automatically?

You can provide a specific WACC, or the tool can use a default (typically 10% for large-cap) and then model the valuation sensitivity around that rate.

What financial methodology does this DCF model use?

The model utilizes the un-levered free cash flow (UFCF) method, projecting cash flows for 5 years and calculating a terminal value using the perpetuity growth method.

Excel DCF Modeler

Name: Excel DCF Modeler
Author: jeremylongshore

byjeremylongshore

•

883

Data Science & ML

Builds professional investment banking-grade discounted cash flow (DCF) models in Excel with automated financial projections and sensitivity analysis.

About

The Excel DCF Modeler skill automates the creation of comprehensive valuation workbooks following strict investment banking standards. It generates a structured four-sheet Excel file featuring detailed assumptions, five-year un-levered free cash flow projections, WACC calculations, and enterprise value determination. This tool is specifically designed for corporate finance professionals and financial analysts who need to perform rapid, accurate intrinsic value assessments with consistent formatting, robust formula linking, and integrated two-way sensitivity tables.

Key Features

Applies professional financial formatting including currency, percentages, and conditional formatting for heat maps.
Includes automated two-way sensitivity tables for WACC and Terminal Growth Rate variables.
Follows best practices like tapering growth rates and conservative terminal value defaults.
Calculates Terminal Value, Enterprise Value, and Equity Value per share using industry-standard formulas.
Generates multi-sheet Excel workbooks including Assumptions, FCF Projections, Valuation, and Sensitivity Analysis.
883 GitHub stars

Use Cases

Analyzing the impact of WACC and growth rate changes on a company's total enterprise value.
Performing rapid intrinsic valuation for M&A analysis or investment research.
Building standardized financial models for corporate planning and strategy presentations.

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

GitHub