Financial Forecasting Data Analysis Support
Budget: ₹12,500 – ₹37,500 INR
I manage the finance function of a medium-sized company and need a data-savvy accountant to turn our historical numbers into clear, forward-looking insight. All raw data—from the general ledger and trial balance to recent expense spreadsheets—will be provided in Excel and CSV formats.
Your core assignment is to build a robust financial-forecasting model that projects cash flow, revenue, and key cost drivers over the next 12–24 months. I’m open to the tools you prefer—whether that’s advanced Excel formulas, Power BI dashboards, Python with pandas, or a mix—so long as the output is easy for non-technical leadership to interpret.
Deliverables I must see:
• A dynamic forecast workbook or script with clearly labeled input cells and assumptions
• Visual summaries (charts or dashboards) highlighting trends, break-even points, and risk scenarios
• A brief walkthrough document or Loom video explaining how to update the model going forward
Accuracy, transparency in calculations, and an eye for telling the “story” behind the numbers will be the key acceptance criteria. Once we agree on scope, I’m happy to set milestones for initial model, revisions, and final hand-off.
Your core assignment is to build a robust financial-forecasting model that projects cash flow, revenue, and key cost drivers over the next 12–24 months. I’m open to the tools you prefer—whether that’s advanced Excel formulas, Power BI dashboards, Python with pandas, or a mix—so long as the output is easy for non-technical leadership to interpret.
Deliverables I must see:
• A dynamic forecast workbook or script with clearly labeled input cells and assumptions
• Visual summaries (charts or dashboards) highlighting trends, break-even points, and risk scenarios
• A brief walkthrough document or Loom video explaining how to update the model going forward
Accuracy, transparency in calculations, and an eye for telling the “story” behind the numbers will be the key acceptance criteria. Once we agree on scope, I’m happy to set milestones for initial model, revisions, and final hand-off.