Excel Financial Forecast Dashboard
Budget: $250 – $750 AUD
I need a full three-statement model in Excel that links an income statement, balance sheet, and cash-flow forecast, then presents the results through an easy-to-read dashboard. My source data already lives in several spreadsheets and databases, so the file you build must pull that data in seamlessly and stay synced whenever the inputs change.
The workbook should offer:
• Interactive charts that let me toggle between time periods and scenarios
• Automated data updates so the numbers refresh without manual copy-pasting
• Clear separation of reports in multiple tabs, each with a logical layout and consistent formatting
Deliverables will be considered complete once:
1. All three financial statements reconcile and roll forward for at least the next 12 months.
2. The dashboard visualises key metrics (revenues, margins, cash position, liquidity ratios) and responds instantly to new inputs.
3. External data connections are documented and can be refreshed with a single click.
4. The file is unlocked, well-commented, and handed over with a short Loom or written walkthrough so I understand the flow.
If you have experience building dynamic Excel models with Power Query, pivot charts, or VBA to streamline updates, please jump in—I am ready to share sample data and move quickly.
The workbook should offer:
• Interactive charts that let me toggle between time periods and scenarios
• Automated data updates so the numbers refresh without manual copy-pasting
• Clear separation of reports in multiple tabs, each with a logical layout and consistent formatting
Deliverables will be considered complete once:
1. All three financial statements reconcile and roll forward for at least the next 12 months.
2. The dashboard visualises key metrics (revenues, margins, cash position, liquidity ratios) and responds instantly to new inputs.
3. External data connections are documented and can be refreshed with a single click.
4. The file is unlocked, well-commented, and handed over with a short Loom or written walkthrough so I understand the flow.
If you have experience building dynamic Excel models with Power Query, pivot charts, or VBA to streamline updates, please jump in—I am ready to share sample data and move quickly.