Excel Revenue Forecasting Workbook Creation
hr USD 2–8
About the project
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.
Skills required
This job is listed on Freelancer.com. AiZity aggregates listings for discovery only and is not the employer. To bid or apply, use the button in the sidebar.