A five-year (2019–2023) financial statement analysis built in Excel for Novatech Solutions. The workbook consolidates the three core financial statements, horizontal and vertical analysis, a full ratio suite (profitability, liquidity, efficiency, solvency), and an interactive pivot-table dashboard to surface the underlying trends in the business's financial health.
- Microsoft Excel — 3-statement build, horizontal/vertical analysis, ratio calculations, pivot tables and charts
- Full 3-statement model: Income Statement, Balance Sheet, Cash Flow Statement (2019–2023)
- Horizontal analysis (year-over-year % change) and vertical analysis (common-size statements)
- 20+ financial ratios across profitability, liquidity, efficiency, solvency, and market categories
- Pivot table and interactive dashboard summarising the five-year trend
- Automated charts driven directly from the underlying data
Synthetic financial data built to simulate a mid-sized company over a five-year period, for demonstration and portfolio purposes.
- Revenue grew steadily from $350m to $500m (2019–2023), a 43% increase — but profitability moved in the opposite direction
- Net profit margin fell from 3.8% in 2019 to -0.2% in 2023, with the company posting a net loss in the final year
- Gross margin compression (51.4% → 50.0%) combined with a rising operating expense ratio (44.9% → 48.6%) squeezed operating income down to just 1.4% of revenue by 2023
- Liquidity deteriorated sharply: the current ratio dropped from 3.0x to 1.56x and the cash ratio from 1.25x to 0.19x, with the cash balance falling from $70.8m to $15m
- Leverage increased materially: the debt-to-equity ratio climbed from 0.85x to 1.60x, and interest coverage collapsed from 5.75x to 0.88x — meaning operating income could no longer comfortably cover interest expense by 2023
- Overall, the analysis tells a "growth-without-health" story: top-line expansion masked eroding margins, a widening reliance on debt, and a cash position under real strain
.
.
.
Built by Emmanuel Sekyere