End-to-end Financial Statement Analysis using Excel — includes data cleaning, ratio analysis, forecasting, and prescriptive modeling to simulate real-world financial analyst work. .
This project performs an end-to-end Financial Statement Analysis of a company’s performance using Microsoft Excel. It converts raw financial data into meaningful insights through data cleaning, ratio analysis, forecasting, and prescriptive decision modeling.
The goal is to simulate the work of a Financial Analyst, from structuring financial data to deriving management-level recommendations.
| Sheet Name | Purpose |
|---|---|
| 1️⃣ Raw Data | Original monthly financial data (Apr–Jul 2025). |
| 2️⃣ Cleaned Data | Standardized, formatted, and validated financial data for analysis. |
| 3️⃣ Analysis | Used Comparative financial Statement Analysis |
| 4️⃣ Ratios | Profitability, Liquidity, Efficiency, and Solvency ratios. |
| 5️⃣ Dashboard | Visual summary (Revenue, Costs, Margins, Profitability, Efficiency and Liquidity). |
| 6️⃣ Forecast | Projection model with What-If and Scenario Analysis - Forecasting Impact of Highest Cost Driver on PAT (Material Cost %, PAT impact). |
| 7️⃣ Prescriptive Analysis | Data-driven recommendations for management decisions. (Descriptive, Diagnostic, Predictive and Prescriptive Analysis involved) |
| 8️⃣ Executive Summary | One-page narrative summarizing key findings and insights. |
Trend Analysis (Revenue, Material Costs, and Expenses)
Ratio Analysis – Gross Margin, Net Margin, Current Ratio, Debt-Equity, etc.
Forecasting – Future projection of costs, revenues, and profits
What-If / Sensitivity Analysis – Impact of changing material cost % on Profit After Tax (PAT)
Prescriptive Analysis – Recommended management actions to improve profitability
Microsoft Excel
Data Cleaning & Formatting
Formula-based Calculations
Common Size Statement Analysis
Exponential Forecasting
What-If Analysis → Data Tables
Conditional Formatting & Visualization
Dashboard Creation with Charts and KPIs
Forecasting Models using Assumptions and Scenario Planning
1% reduction of material cost will lead to increase of PAT by 12.32% from current level.
Stable liquidity maintained with gradual improvement in net margin.
Material cost forms ~47% of total expenses, making it the prime optimization area.
Prescriptive analysis identifies strategies for cost control and margin improvement.
Financial Statement Analysis
Business Forecasting
Data Visualization & Dashboarding
Sensitivity and Scenario Analysis
Financial Modeling Logic in Excel
Analytical Communication
Communication
This Excel model replicates a real-world financial analysis workflow, turning raw financial data into executive-level insights. It’s designed to demonstrate analytical, problem-solving, and financial modeling skills for a Financial Analyst portfolio.
📍 Financial Analyst (Portfolio Project)
📧 Email : rjayakrishna37@gmail.com
LinkedIn : https://www.linkedin.com/in/jayakrishna-r-5a19b925b
📂 GitHub: https://github.com/jai0311