Required stack
필요 기술
Microsoft ExcelVBA
Project brief
프로젝트 내용
I need a fully-linked 24-month rolling cash-flow forecast built from scratch in Excel. Please design a clean, intuitive template rather than repurposing an off-the-shelf layout. The model must capture both revenue streams and every expense category I specify, update automatically as I overwrite actuals, and extend the horizon one month forward each time.
You will receive my historical figures and key assumptions as soon as we agree on the structure. Formulas should be visible, well-labeled and easy to audit; no hard-coded numbers buried in the logic. I also want summary visuals (monthly net cash, cumulative position) on a separate dashboard sheet for quick reference.
Deliverables
• One .xlsx file containing the forecast, summary dashboard and clearly documented assumptions.
• Brief walkthrough notes explaining how to update inputs and roll the timeline forward.
I’ll review by stress-testing a few what-if scenarios, so please allow for at least two rounds of minor revisions before we close.
You will receive my historical figures and key assumptions as soon as we agree on the structure. Formulas should be visible, well-labeled and easy to audit; no hard-coded numbers buried in the logic. I also want summary visuals (monthly net cash, cumulative position) on a separate dashboard sheet for quick reference.
Deliverables
• One .xlsx file containing the forecast, summary dashboard and clearly documented assumptions.
• Brief walkthrough notes explaining how to update inputs and roll the timeline forward.
I’ll review by stress-testing a few what-if scenarios, so please allow for at least two rounds of minor revisions before we close.