Excel Revenue Forecasting Workbook Creation

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted2 hours ago
I need an Excel-based workbook that turns my raw sales figures and assumptions into a clear, quarterly revenue forecast.

Key Requirements:
- Fully editable model with a dedicated Input sheet (historical data, growth assumptions, pricing changes, seasonality factors).
- Dynamic calculation sheets that generate the projected P&L by quarter for at least the next three years.
- At-a-glance dashboards (charts, variance bars, conditional-format heat maps) so stakeholders can read the numbers easily.
- Clear documentation inside the file: named ranges, brief comments, and a quick user guide tab.
- The framework should be expandable later to monthly or annual views without rewriting everything.

Skills Required:
Advanced Excel (INDEX/MATCH, dynamic arrays, Power Query), Financial Modeling, Data Visualization, and Business Analysis.

Please send a short note on how you would structure the workbook, any similar models you have built, and your estimated timeline.
visual basic excel business analysis financial analysis excel vba excel macros data visualization financial modeling
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.