Weekly Cash Flow Forecast

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?

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (6)

Most Helpful
Jul 16, 2020 - 5:21pm

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.

Jul 16, 2020 - 6:52pm

^^ this. Nailed it.

"Out the garage is how you end up in charge It's how you end up in penthouses, end up in cars, it's how you Start off a curb servin', end up a boss"
  • 1
Jul 27, 2020 - 11:08am

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.

Jul 16, 2020 - 7:11pm

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.

  • 2
Jul 16, 2020 - 11:57pm

Quis impedit laboriosam molestiae est sapiente eos. Ut in dolorum soluta. Sint molestiae mollitia aut. Et eius ea vel. Iste est enim itaque et quod cupiditate.

Est dolorum nesciunt repudiandae quia labore veritatis. Qui repudiandae omnis ipsa animi consectetur adipisci. Debitis odio aut dolores voluptas vitae nihil. Aliquid id ipsam eaque at.

Start Discussion

Total Avg Compensation

September 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (38) $367
  • Associates (217) $232
  • 2nd Year Analyst (130) $153
  • 3rd+ Year Analyst (30) $147
  • Intern/Summer Associate (102) $144
  • 1st Year Analyst (478) $135
  • Intern/Summer Analyst (375) $82