3 Year Financial Forecast Model
Budget / Salary₹12,500–37,500
TypeFreelance project
LocationRemote
Posted1 hour ago
I need a clear, flexible Excel model that shows where my business is headed financially over the next three years. The core objective is simple: give me an annual view of expected income and expenses so I can steer strategy with confidence.
Your task
• Build a clean, well-structured workbook in Microsoft Excel that projects revenue, direct costs, operating expenses, EBITDA, net income, and cash flow for FY 1-3.
• Include a separate assumptions sheet where key drivers (pricing, unit volumes, cost percentages, tax rates, growth rates) can be updated quickly.
• Automate roll-ups so changes on the assumptions sheet flow through every statement without manual tweaks.
• Add at least two scenario toggles (e.g., base / optimistic) to stress-test the numbers.
• Create a concise dashboard with charts that instantly highlight top-line growth, margin trends, and cash position.
Acceptance criteria
1. Every formula is traceable and free of hard-coded numbers (other than row headers and dates).
2. Year-end financial statements reconcile and balance.
3. I can adjust any key driver and see the impact in under five seconds.
4. The file opens without errors in Excel 2019 or later.
If you have a track record in financial modelling, a flair for neat spreadsheet architecture, and the ability to explain your logic clearly, let’s work together.
Your task
• Build a clean, well-structured workbook in Microsoft Excel that projects revenue, direct costs, operating expenses, EBITDA, net income, and cash flow for FY 1-3.
• Include a separate assumptions sheet where key drivers (pricing, unit volumes, cost percentages, tax rates, growth rates) can be updated quickly.
• Automate roll-ups so changes on the assumptions sheet flow through every statement without manual tweaks.
• Add at least two scenario toggles (e.g., base / optimistic) to stress-test the numbers.
• Create a concise dashboard with charts that instantly highlight top-line growth, margin trends, and cash position.
Acceptance criteria
1. Every formula is traceable and free of hard-coded numbers (other than row headers and dates).
2. Year-end financial statements reconcile and balance.
3. I can adjust any key driver and see the impact in under five seconds.
4. The file opens without errors in Excel 2019 or later.
If you have a track record in financial modelling, a flair for neat spreadsheet architecture, and the ability to explain your logic clearly, let’s work together.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.