DCF Valuation Model (Excel)

Objective

Build an end-to-end Discounted Cash Flow (DCF) valuation model to estimate the intrinsic value of a listed company and support investment decision-making.

What this model covers

• Forecast of Revenue, EBIT, Taxes, CAPEX, Working Capital
• Free Cash Flow to Firm (FCFF)
• WACC-based discounting
• Terminal Value calculation
• Sensitivity analysis (WACC vs Terminal Growth)

Tools Used

• Microsoft Excel

Files in this repository

• DCF_Valuation_Model.xlsx — Full valuation model
• Assumptions.md — Key assumptions used
• Investment_Conclusion.md — Summary conclusion template

Key Skills Demonstrated

Financial Modeling • Valuation (DCF) • Forecasting • Sensitivity Analysis • Corporate Finance