dcf-model

This Skill automates DCF valuation modeling in Excel by generating 5-year forecasts across Bear, Base, and Bull scenarios. It uses linked formulas rather than static numbers to drive projections for revenue, margins, and free cash flow.

Yes, you can run WACC sensitivity analysis in Excel because this Skill generates a 5×5 sensitivity grid that recalculates on input changes. It explores various WACC and terminal-growth assumptions to support equity research and intrinsic-value work.

Yes, you need openpyxl installed because this Skill uses it to write live Excel formulas programmatically. This dependency enables the automated generation of linked financial projections and bottom-of-sheet sensitivity grids.

The best way to automate an enterprise-to-equity value bridge is using a dedicated WACC module to derive the implied price per share. This Skill includes a sanity-check on terminal value proportion to ensure your intrinsic-value calculations remain structurally accurate.

Yes, this DCF Excel model works for both mature and growth companies. It applies a repeatable workflow with deterministic formulas and Bear/Base/Bull scenario frameworks to handle intrinsic-value work across different company life cycles.

Deterministic formulas are used in financial modelling instead of static numbers to reduce manual errors and ensure live recalculation. This approach creates a repeatable workflow where changing an input automatically updates revenue, margins, and free cash flow projections.