Automated Stock Valuation - DCF + CCA Model for Investors & Analysts

Build professional-grade equity valuations in minutes, not hours — using nothing but Python and Excel.
This tool automatically pulls financial data, performs Comparable Company Analysis (CCA), and runs a full Discounted Cash Flow (DCF) model — then neatly exports it all to a pre-formatted Excel workbook.
Just plug in a stock ticker. The rest is done for you.


🧠 What You Get:
✅ Real-time financials pulled using free APIs
✅ Clean, formatted Excel output with charts, comps, and DCF
✅ Fast, editable Python script — no coding experience needed
✅ Works for trading, investing, or learning valuation modeling


🔍 What's Under the Hood:
🟢 Comparable Company Analysis (CCA):
Automatically pulls peers and compares key multiples like P/E, EV/EBITDA, and P/S to help you gauge if a company is under- or over-valued.
🔵 Discounted Cash Flow (DCF):
Projects future cash flows, applies a discount rate (WACC), and calculates the intrinsic value of the stock. Includes terminal value and optional sensitivity tables.
📊 Excel Output:
No messy templates — all outputs are clean, readable, and ready to share or edit. Think of it like a mini Bloomberg terminal, minus the subscription.


This is for educational use only. The data-fetching script relies on public APIs and light scraping. Make sure your usage aligns with any data providers' terms of service.


Walk-Through of the Model: https://youtu.be/uZFWxQeq-mk