This project demonstrates financial analysis and forecasting using Excel.
The model analyzes historical retail sales data and builds a 5-year financial forecast using a three-statement financial model.
Raw Data Cleaning
Sales analysis by region and category
Discount impact analysis on profitability
5-year financial forecast
Scenario analysis (Base Case, Best Case, Worst Case)
Income Statement
Cash Flow Statement
Balance Sheet
These statements are dynamically linked to simulate financial performance under different assumptions.
Some subcategories have reduced profits, and some have losses due to heavy discounting.
Some high-revenue categories generate weak margins due to aggressive discount strategies.
Technology products maintain stronger profitability even with moderate discounts.
Microsoft Excel
Pivot Tables
Financial Modelling
Scenario Analysis
Blessed Masunika