What happens if the terminal growth rate exceeds the WACC?

The skill includes error handling for terminal value calculations, alerting you if growth assumptions are mathematically unsustainable relative to the discount rate.

Can I customize the valuation assumptions?

Yes, the skill creates a dedicated assumptions sheet where you can modify revenue growth, margins, discount rates, and terminal growth factors.

What financial standards does the modeler follow?

The skill follows standard investment banking practices, utilizing 5-year projections, WACC discounting, and the Gordon Growth Model for terminal value estimation.

Does it support sensitivity analysis?

Yes, it automatically generates data tables that show how the company's value changes based on varying WACC and terminal growth rate assumptions.

Excel DCF Modeler

Name: Excel DCF Modeler
Author: Brmbobo

byBrmbobo

•

Productivity & Workflow

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

The Excel DCF Modeler skill streamlines the complex process of corporate valuation by generating structured, multi-sheet Excel workbooks based on investment banking standards. It automates the creation of assumptions sheets, five-year free cash flow projections, and terminal value calculations using the Gordon Growth Model. By handling the heavy lifting of formula linking and formatting, it enables financial analysts and developers to quickly derive Enterprise Value and Equity Value per share while performing robust sensitivity analysis on key drivers.

Key Features

01Multi-sheet Excel structure following financial best practices

02Built-in sensitivity analysis tables for growth and discount rates

03Dynamic WACC and Terminal Value calculations

041 GitHub stars

05Automated 5-year free cash flow (FCF) projections

06Calculation of Enterprise Value and Equity Value per share

Use Cases

01Performing M&A target analysis with custom synergy adjustments

02Building investment-ready financial templates for corporate finance reviews

03Generating quick valuation models for SaaS companies and startups

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add brmbobo/web2podcast excel-dcf-modeler

For use in Claude.ai and ChatGPT

Download Skill