13-Week Rolling Cash Flow Forecast for an Indian Listed Company
A linked model or operating dashboard with assumptions, scenarios, variance commentary, and management summary.
Build
Model, memo, dashboard, notebook, or deck.
Explain
Clear assumptions, insight, and recommendation.
Show
Resume bullet and interview story.
What you are doing
You are working as a Corporate Finance. Your manager asks you to use Cash Flow Forecasting to answer a real business or investment question and present a decision-ready output.
Show that you can apply Cash Flow Forecasting in a practical analyst workflow, not only explain the theory.
What to make
A linked model or operating dashboard with assumptions, scenarios, variance commentary, and management summary.
Deliverables
- Brief
- Model or notebook
- Charts or dashboard
- Resume bullet
- Source and assumption log
- One-page executive summary
- Final output file
How to start
- Define the business model and key operating drivers.
- Create clean input, historicals, forecast, output, and checks tabs.
- Separate assumptions from formulas.
- Decide base, upside, and downside scenarios before modeling.
Step-by-step execution
- Build historical P&L, balance sheet, and cash flow lines.
- Create drivers for revenue, cost, margin, capex, working capital, and debt.
- Link the statements and add balance checks.
- Create scenario and sensitivity outputs.
- Write a finance-manager style summary with the main movement, risk, and decision required.
Data and sources
- Company annual report
- Quarterly filings
- Investor presentation
- Public industry data
- Synthetic operating dataset if company data is unavailable
Tools to use
- Excel
- BSE India quarterly cash flow statements (free)
- Excel or Google Sheets
- Google Docs
- Public sources
Quality rubric
- Statements link without hardcoded balancing plugs.
- Checks clearly flag model errors.
- Drivers explain the business rather than only formulas.
- Scenario outputs are easy to compare.
- Summary tells a decision-maker what changed and why.
Resume bullet
Built a a linked model or operating dashboard with assumptions, scenarios, variance commentary, and management summary. for Cash Flow Forecasting, using Excel, BSE India quarterly cash flow statements (free) to convert raw information into a decision-ready finance output.
Interview talk track
- Problem: explain the business question and why it matters for Corporate Finance.
- Method: describe the data collected, assumptions made, and analysis performed.
- Decision: state the recommendation, key risk, and what would change your view.