This repository presents a comprehensive Financial Model built in Microsoft Excel for UAC of Nigeria Plc (UACN) a diversified conglomerate operating in the Nigerian market. Designed with precision and foresight, this project embodies my expertise as a Data Analyst and Data Scientist, blending finance, strategy, and analytics into one cohesive system.
The model performs a full-suite analysis covering:
- Income Statement Projections
- Balance Sheet Estimates
- Cash Flow Forecasting
- Ratio Analysis & Valuation
- Scenario Testing
Built with clarity, flexibility, and stakeholder usability in mind, the Excel workbook allows dynamic updates, assumption flexibility, and automated results aggregation — ensuring strategic decision-makers are equipped with actionable insights.
📌 The attached PDF screenshot file shows a high-level visual of the model interface, key outputs, and structure — giving a quick overview of its depth and professional presentation.
- 📈 Forecast Horizon: 5-year forward projections based on macroeconomic and company-specific assumptions.
- 🔍 Dynamic Dashboards: Summary pages built with Excel formulas and logic, not just formatting.
- ⚙️ Integrated Assumptions: Inputs automatically drive all statements and calculations.
- 🧠 Analytical Rigor: Ratio analysis includes profitability, liquidity, efficiency, and investor metrics.
- 📉 Sensitivity Analysis: Vary key levers like inflation, volume, and pricing to assess scenario impacts.
I am Tosin Bello, a professional data analyst and data scientist passionate about financial modeling, business intelligence, and turning data into decisions. This model showcases the real-world applicability of Excel-powered analysis with a clean, corporate-ready design.
- LinkedIn: Tosin Bello
- Email: [email protected]
UACN Model(27122022).xlsx– Main Excel workbook with linked financials and model logic.UACN.pdf– Screenshot preview of key model components.
- Employer portfolio showcasing advanced Excel skills
- Financial analyst case study reference
- Client-ready business model template
- Training material for junior analysts
If you're looking for a data-driven analyst with strong financial modeling skills, feel free to connect or collaborate. Let's turn your data into strategy.
⭐ If you found this project insightful, feel free to star the repo or reach out for consulting, freelance, or full-time opportunities.