Currently working for a tech startup - I have been tasked with creating a weekly cash forecast... there are a few different tutorials online and I have been trying to adapt them so that they fit our business. Anyone out there use one in their corporate model? Any rules of the road/do's/don'ts that I should watch out for when building this out?
Career Resources
Career Advancement Opportunities
October 2026 Investment Banking
-
Evercore 01 99.5%
-
Moelis & Company 01 99.0%
-
JPMorgan 01 98.4%
-
Guggenheim Partners 02 97.9%
-
Morgan Stanley 06 97.4%
Overall Employee Satisfaction
October 2026 Investment Banking
-
Moelis & Company No 99.5%
-
Morgan Stanley 02 99.0%
-
Evercore 01 98.4%
-
Banco Santander 02 97.9%
-
BMO Capital Markets 13 97.4%
Professional Growth Opportunities
October 2026 Investment Banking
-
Evercore 01 99.5%
-
Moelis & Company 01 99.0%
-
Morgan Stanley 05 98.4%
-
Goldman Sachs 01 97.9%
-
JPMorgan No 97.4%
Total Avg Compensation
October 2026 Investment Banking
-
Vice President (16) $429
-
Associates (57) $264
-
3rd+ Year Analyst (8) $210
-
2nd Year Analyst (28) $184
-
Intern/Summer Associate (16) $161
-
1st Year Analyst (84) $151
-
Intern/Summer Analyst (76) $101
16 IB Interviews Notes
“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”
Leaderboard
| 1 |  |
99.2 |
| 2 | |
99.0 |
| 3 | |
99.0 |
| 4 | |
99.0 |
| 5 | |
98.9 |
| 6 | |
98.9 |
| 7 |  |
98.9 |
| 8 | |
98.9 |
| 9 |  |
98.9 |
| 10 | |
98.8 |
From 10 rejections to 1 dream investment banking internship
“... I believe it was the single biggest reason why I ended up with an offer...”
Hi techfin5, no, I never sleep and so I can respond to any lonely threads (like this one) at all hours of the night. Impressive, I know ;-)
You're welcome.
Was put in a similar situation at my company, except monthly cash flows. I'd recommend going down a sources and uses based on your team's forecast. Make sure you align with their calculations then break it down to weekly granularity. Each different revenue or expense stream should have it's own calculation tab supporting it.
We decided not to try and forecast the changes in working capital since it was a bit too detailed and we have a complicated business model. Each month we true up actuals to be that working capital plug. Be prepared to run scenarios across all of your inputs and assumptions so keep the model flexible when building it out.
Also, check out the Money in Excel plugin, i'd be curious if you would leverage that with business accounts to get real time transaction data, might be worth exploring but not sure of the application outside of personal banking.
^^ this. Nailed it.
This is a fine method for monthly cash flow, but would be difficult to translate accurately to weekly as you're using the indirect method.
OP, in order to do short-term cash forecasting, you should be using the simplified direct method (start with opening cash balance + inflows - outflows = ending cash balance). There are multiple ways to do it.. if you already have an indirect cash flow forecast, you can combine that with a P&L and get to the direct forecast.
Google 13-week finance forecast or 13-week cash flow forecast and a ton will come up.
That's how it's usually done. Update more often if you run a company with complex cash flow mechanics.
We update ours 2x to 1x a week usually. Then do full financials once a quarter. More often on full financials without a good use-case is a waste of time.
Impedit sunt nulla quasi. Suscipit itaque quam et quo ut dolorum dolorem sit. Ratione numquam itaque ut et.
Debitis et et perferendis nobis dolores commodi velit. Eum perspiciatis ullam fugiat. Adipisci necessitatibus nostrum ipsam cupiditate corrupti reprehenderit facere. Et sapiente natus mollitia. Voluptas quidem ea vel nemo animi dolore consequuntur odio. Aut unde dignissimos molestiae voluptatum dolore provident blanditiis quidem. Qui et animi maxime minima ex.
Rem inventore sed doloremque quisquam et. Vero eaque autem placeat ea. Est et possimus quod ratione dolor. Dolores nisi sequi accusamus et suscipit quaerat. Maiores dolorem ut expedita et commodi alias quam. Iste omnis accusantium vel aut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...