INTL
Freelancer
보통
외주
원격 가능
24-Month Cash Flow Forecast
예산
$30~$250 USD
예상 기간
1~2주
난이도
보통
기술 스택
Microsoft Excel
VBA
AI 분석 요약
엑셀 기반의 24개월 롤링 현금 흐름 예측 모델을 구축하는 프로젝트입니다. 자동 업데이트, 쉬운 감사 기능, 대시보드 시각화 등이 요구되며, 엑셀 전문가 및 재무 모델링 역량이 필수적입니다.
프로젝트 원문 설명
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.
Freelancer에서 원본 확인
원본 보기