Built an anonymized FP&A model to evaluate revenue growth, EBITDA margin, liquidity, leverage and working-capital efficiency across 2021-2028.
PROJECT OVERVIEW
A portfolio case study showing how financial statements can be converted into an FP&A model for revenue forecasting, margin analysis, liquidity review and management recommendations.
BUSINESS PROBLEM
The company needed to understand whether a growth strategy could improve profitability without creating liquidity pressure or excessive leverage.
TOOLS & METHODS
Financial ratio analysis, Revenue and EBITDA forecasting, Working-capital KPI analysis: AR days, inventory days, AP days and cash conversion cycle, Scenario-based FP&A reporting, Executive recommendation writing
KEY OUTPUTS
A dashboard-ready Excel model and PDF case study covering financial ratios, revenue and EBITDA forecasts, working-capital indicators and executive insights.
