dcf-model

To build a DCF valuation in Excel, you need to project revenue, calculate free cash flow, determine WACC, and compute terminal value. This skill automates that process, generating a complete model with 5x5 sensitivity tables and Bear/Base/Bull scenarios.

Yes, you can generate Bear, Base, and Bull scenarios for equity valuation by providing company inputs like revenue, margins, and beta. The skill computes the enterprise-to-equity value bridge and outputs per-share valuations across these distinct cases.

CAPM-based cost of equity calculates the required return using beta and the risk-free rate. In this DCF model, these inputs feed directly into the WACC computation, which discounts your projected free cash flows to present value.

You need to provide revenue, margins, debt, cash, shares, beta, tax rate, and the risk-free rate. The skill uses these inputs to calculate free cash flow, terminal value, and an explicit enterprise-to-equity value bridge for per-share valuation.

Yes, the financial modeling skill satisfies live-formula requirements in Excel. This means inputs like revenue, margins, debt, cash, and beta remain updateable, automatically recalculating the five-year projections and sensitivity tables.

The best way to create a 5x5 sensitivity table is to use a DCF model that automates the matrix calculations. This skill produces multiple 5x5 sensitivity tables to reveal valuation ranges and risk across different WACC and growth assumptions.