This repository contains the final year group project for the Business Finance (MGT-232) course. The project presents a comprehensive comparative financial analysis of:
- Dewan Farooque Motors Limited (DFML)
- Indus Motor Company Limited (IMCL)
Our team analyzed the financial health, operational efficiency, and profitability of both companies using three years of financial data (2022–2024).
We applied:
- 🔍 Trend Analysis
- 📉 Ratio Analysis (Liquidity, Leverage, Coverage, Activity, Profitability)
- 📊 Common-Size and Index Analysis
- 🧮 Excel-based modeling
- 💡 Interpretations & strategic insights
| Metric | DFML | IMCL |
|---|---|---|
| Current Ratio (2024) | 0.28 | 1.58 |
| Net Profit Margin (2024) | -4600.09% | 5.44% |
| Return on Equity (2024) | -11.55% | 7.87% |
| Operating Cycle (2024) | 1133+ days | ~59 days |
| Total Debt to Asset | >200% | 0% (Debt-free) |
| File/Folder | Description |
|---|---|
Final_Report_DFML_vs_IMCL.pdf |
Full written report (DOCX converted to PDF) |
Financial_Model.xlsx |
Ratio calculations, trend charts, and analysis |
Executive_Summary.docx |
Concise interpretation and findings |
Charts/ |
Visuals used in report (PNG format) |
- Amna Malik –
- Atif Farid –
- Awais Manzoor –
- Hiba Asif –
Instructor: Sir Ather Yaqoob
- 📊 Microsoft Excel
- 📄 Microsoft Word
- 🧠 Financial Ratio Models
- 🧾 Data: Pakistan Stock Exchange (PSX), Indus Motors Annual Reports
📌 This project aims to demonstrate applied financial analysis skills and interpretive techniques for real-world corporate finance decision-making.