iggysaint/simple-mtn-DCF-Ghana

Streamlit dashboard that turns an MTN Ghana (Scancom PLC) DCF valuation into clear visuals and plain-English explanations. Academic project. # simple-mtn-DCF-Ghana Streamlit dashboard that turns an MTN Ghana (Scancom PLC) DCF valuation into clear visuals and plain-English explanations. Academic project. # MTN Ghana DCF Valuation Dashboard A simple Streamlit web app that turns a full DCF (Discounted Cash Flow) valuation of **MTN Ghana (Scancom PLC, GSE: MTNGH)** into clear visuals and plain-English explanations. Built as an academic project presentation layer — all the real analysis stays in Excel; this app only displays the results in an easy-to-understand way. --- ## Features - **Clear BUY / HOLD / SELL recommendation** with implied fair value vs current market price - **Valuation bridge** showing how Enterprise Value and Equity Value are built - **Historical trends** (2021–2025): Revenue, EBIT, Profit After Tax, and margins - **5-year FCFF forecast** with present value of cash flows - **Assumptions explained** in plain English (growth, margins, WACC, terminal growth, etc.) - **Sensitivity analysis** showing how the fair value changes with different beta and terminal growth rates **Key result from the model:** Implied fair value ≈ **GHS 17.06** vs current price **GHS 7.02** → **BUY** (~143% upside) --- ## Tech Stack - Streamlit – web app framework - Pandas – data handling - Plotly – interactive charts --- ## How to Run Locally 1. Clone the repository: ```bash git clone github.com cd mtn-ghana-dcf-dashboard 2. Install the required packages:pip install streamlit pandas plotly openpyxl 3. Run the app:streamlit run app.py 4. Open the link that appears in your terminal (usually localhost)