Automated DCF Valuation Platform

Overview

A Python-based valuation platform that automates the Discounted Cash Flow (DCF) process for publicly listed companies across global markets.

The model automatically extracts financial statements, forecasts Free Cash Flow to Firm (FCFF), calculates WACC using CAPM inputs, performs sensitivity analysis, and generates professional Excel reports.

---

Features

• Automated financial statement extraction
• Revenue forecasting engine
• FCFF forecasting
• Automated WACC calculation
• Country-specific risk-free rates
• Equity Risk Premium integration
• Sensitivity analysis
• Investment recommendation engine
• Excel report generation

---

Technologies Used

• Python
• Pandas
• OpenPyXL
• Yahoo Finance (yfinance)

---

Sample Output

Dashboard

Sensitivity Analysis

Terminal Output

---

Project Structure

DCF-Valuation-Tool/
│
├── main.py
├── data_fetcher.py
├── analysis.py
├── forecast.py
├── fcff.py
├── valuation.py
├── wacc.py
├── sensitivity.py
├── dashboard.py
├── formatter.py
├── excel_exporter.py
│
├── requirements.txt
└── README.md

---

Future Enhancements

• Comparable Company Analysis
• Monte Carlo Simulation
• PDF Equity Research Reports
• Portfolio Valuation Module