A fully integrated financial model built in Excel for Sip & Savor Beverage Co., a company in the FMCG (Fast-Moving Consumer Goods) beverage sector. The model links a 5-year Income Statement, Balance Sheet, and Cash Flow Statement to a DCF-based valuation and a full financial ratio suite, all driven from a single set of input assumptions.
This project models Sip & Savor Beverage Co.'s financial performance from 2024–2028, projecting revenue growth from an initial base of ~380M to ~620M by 2028, alongside margin expansion (gross margin improving from ~50.5% to ~54.2%). The model culminates in a DCF valuation of the firm, producing an Enterprise Value of ~657M and an Equity Valuation of ~97M, supported by a full set of profitability, liquidity, and solvency ratios.
- Microsoft Excel — advanced formulas, dynamic linking across sheets, pivot tables, sparklines, and a scenario-driven dashboard
- Techniques: 3-statement integration, DCF valuation (FCFF & FCFE), WACC-based discounting, ratio analysis
- 📊 Dynamic Dashboard — single-page overview of company performance and valuation
- 🔗 Fully Integrated 3-Statement Model — Income Statement, Balance Sheet, and Cash Flow Statement are linked so changes to assumptions flow through automatically
- 💰 DCF Valuation — both Free Cash Flow to Firm (FCFF) and Free Cash Flow to Equity (FCFE) approaches, with terminal value and WACC/Ke-based discounting
- 📈 Financial Ratio Suite — profitability (gross/operating/net margin, ROE, ROA), liquidity (current, quick, cash ratio), and solvency (debt-to-equity, debt ratio, interest cover) tracked across all 5 forecast years
- 🧮 Assumption-Driven Workings — a dedicated Input Data and Workings layer so the model can be flexed under different scenarios
- 📋 Pivot-Table Data Layer — raw data and pivot sheet supporting the dashboard views
| # | Tab | Purpose |
|---|---|---|
| 1 | Cover Page | Project title page |
| 2 | Summary | Headline KPIs — revenue, valuation, key line items at a glance |
| 3 | Table of Content | Navigation |
| 4 | Dashboard | Visual summary of performance and valuation |
| 5 | Input Data | Core assumptions driving the model |
| 6 | Workings | Supporting calculations and schedules |
| 7 | Income Statement | 5-year projected P&L |
| 8 | Balance Sheet | 5-year projected balance sheet |
| 9 | Cash Flow Statement | 5-year projected cash flows |
| 10 | Valuation | DCF (FCFF & FCFE), terminal value, discounting |
| 11 | Financial Ratios | Profitability, liquidity, and solvency ratios |
| 12 | Data / Pivot Sheet | Underlying data tables and pivot analysis |
- Revenue grows from ~380M (2024) to ~620M (2028), a ~63% increase over the forecast period, driven by steady top-line growth assumptions
- Gross margin improves from ~50.5% to ~54.2%, and operating margin more than doubles from ~14.1% to ~30.9%, pointing to strong operating leverage as the business scales
- Net profit margin is more volatile (dipping in 2028) due to tax and financing effects in the underlying workings
- Liquidity is strong throughout, with current ratio well above 3x in every year, though it trends down from ~8.2x (2024) to ~3.7x (2028) as current liabilities grow
- The DCF implies an Enterprise Value of ~657M against an Equity Valuation of ~97M
.
.
.
.
Emmanuel Sekyere Financial Analyst | Data Analytics [www.linkedin.com/in/emmanuelsekyere] · [https://github.com/E-SEKYER] · [sekmanuel@gmail.com]