Forward Sports (Pvt.) Ltd — Dynamic 5-Year Three-Statement Financial Model A fully-linked, scenar...Forward Sports (Pvt.) Ltd — Dynamic 5-Year Three-Statement Financial Model A fully-linked, scenar...
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Account's avatar
Account Sphere
• 1d
Forward Sports (Pvt.) Ltd — Dynamic 5-Year Three-Statement Financial Model
A fully-linked, scenario-driven financial model built in Excel for Forward Sports (Pvt.) Ltd, a Sialkot, Pakistan–based sporting goods manufacturer and exporter — forecasting FY2026–FY2030 off a FY2025 actual base year.
Scope of work:
1.Scenario-Driven Assumptions — built a live scenario switch (Base / Upside / Downside) driving revenue growth (3%–13%) and COGS as a % of revenue (59%–64%) through OFFSET + MATCH formulas, so the entire model recalculates from a single dropdown input
2.Operating Expense Build-Up — modeled SG&A, R&D, and Marketing as % of revenue over the forecast period, feeding directly into the income statement
3.Income Statement — fully linked 6-year P&L (2025A–2030F) from revenue through COGS, gross profit, operating expenses, and net income, all formula-driven off the assumptions tab
4.Balance Sheet — dynamic 5-year balance sheet with automatic balance checks tying back to the income statement and cash flow
5.Cash Flow Statement — indirect-method cash flow statement (CFO/CFI/CFF), reconciling net income to the change in cash and linking to the Balance Sheet
6.Ratios & Summary — a KPI panel with margin, efficiency, and return ratios, plus SUMIFS-based period totals for revenue, net income, and marketing spend
7.Dashboard — a forecast-summary dashboard with a scenario selector and revenue/net income/EBITDA-margin charts (Base case: ~19% EBITDA margin through the forecast, Net Income growing from ~$5.0M to $5.8M FY2026F–FY2028F)
Why it matters: Every figure flows from a single set of assumptions — change the active scenario and the entire model, from the P&L down to the dashboard chart, updates automatically. Nothing is hardcoded, which is exactly what makes it defensible in front of a client or professor.
Skills demonstrated: Financial modeling · Three-statement integration · Scenario/sensitivity analysis · Advanced Excel (OFFSET, MATCH, SUMIFS, dynamic named ranges) · Dashboard design · Forecasting
Financial AnalysisBookkeepingOperationsCapCutExcel VBAMicrosoft Excel
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started