Monthly Budget Forecasting Analyst Needed
Budget: $50 – $0 USD
I need a clear, driver-based forecast that turns my raw financial figures into an accurate month-by-month budget. All revenue streams, cost centres, payroll data, and overhead invoices are already exported from our accounting system; what’s missing is a model that cleans the inputs, applies sound assumptions, and projects the next twelve months in a way management can trust at first glance.
You’ll be working with Excel or Google Sheets (your choice) and, if it speeds your work, light Power BI or Tableau visuals are welcome. Historical data is available in CSV and PDF; I’ll supply every file plus a brief on known seasonality factors.
Deliverables
• A flexible spreadsheet model that automatically updates forecasts when I paste new actuals
• A concise summary (PDF or PPT) highlighting key drivers, risks, and variance explanations
• A short Loom or live hand-off walk-through so I can maintain the model internally
Acceptance criteria
The model must reconcile to our last closed month within ±0.5 %, allow quick scenario toggling on revenue growth and cost inflation, and produce a ready-to-share management summary sheet. Once those checks pass, the project is complete.
You’ll be working with Excel or Google Sheets (your choice) and, if it speeds your work, light Power BI or Tableau visuals are welcome. Historical data is available in CSV and PDF; I’ll supply every file plus a brief on known seasonality factors.
Deliverables
• A flexible spreadsheet model that automatically updates forecasts when I paste new actuals
• A concise summary (PDF or PPT) highlighting key drivers, risks, and variance explanations
• A short Loom or live hand-off walk-through so I can maintain the model internally
Acceptance criteria
The model must reconcile to our last closed month within ±0.5 %, allow quick scenario toggling on revenue growth and cost inflation, and produce a ready-to-share management summary sheet. Once those checks pass, the project is complete.
Related categories:
Data Processing
Excel
Statistics
Business Analysis
Financial Analysis
Data Analysis
Power BI
Google Sheets