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.

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

01Applies professional financial formatting including currency, percentages, and conditional formatting for heat maps.

02Includes automated two-way sensitivity tables for WACC and Terminal Growth Rate variables.

03Follows best practices like tapering growth rates and conservative terminal value defaults.

04Calculates Terminal Value, Enterprise Value, and Equity Value per share using industry-standard formulas.

05Generates multi-sheet Excel workbooks including Assumptions, FCF Projections, Valuation, and Sensitivity Analysis.

06883 GitHub stars

Use Cases

01Analyzing the impact of WACC and growth rate changes on a company's total enterprise value.

02Performing rapid intrinsic valuation for M&A analysis or investment research.

03Building 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