Forecasting WC without a balance sheet.

Hello everyone!

I'm just 2 weeks into an equity research intern role and have a question to ask you all. Any help would be awesome.

How could I forecast the working capital or increase in WC in a cash flow without building a balance sheet?

One method I read was a % to sales method but the historical data is not steady. WC as a % of sales in FY13 was 2% and in FY19 was 16%.

So what method would you guys suggest I use?

Thank you! :)

8 Comments
 

So you major big line items in working capital are AR, Inv, AP etc.

You can calculate days outstanding by

AR= AR/Rev * 365 Inv= In/COGS * 365 AP= AP/COGS * 365

calculate these for the last however years you have data, see the trend and make a judgement call on those how those will be for your forecasting period. Then, reverse-calculate to AR, Inv, AP, etc. Then you will have calculated BS, then use those for SCF.

 

Is there a reasonable comps set from which you could infer averages? You could always add an additional sensitivity analysis showing changes in valuation based on various working capital assumptions.

 
 

Mhmm yeah that is true, the company has shifted it's momentum to another product mix the last couple of years. Great point. I'll go through and spot out some factors which could help me forecast the WC.

Thank you! :D

 
Most Helpful

Debitis aut consequatur sint quia ex et sapiente. Nesciunt aut iusto provident vero placeat vel a. Maiores sit sed saepe non voluptas repellendus.

Et non ab deleniti doloremque. Quia aut reiciendis voluptatibus voluptatum. Similique quam eos omnis ut. Amet inventore sed est aspernatur quia aut soluta. Nihil sunt earum ut non.

Reprehenderit eum beatae nulla reiciendis accusamus nisi magni. Ducimus et facere repudiandae ullam. Cupiditate sunt fugiat enim.

Recusandae exercitationem sed soluta praesentium voluptatum iusto voluptate. Quibusdam quasi facere similique illum aliquid.

Career Advancement Opportunities

November 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

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 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

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $101
notes
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
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
Betsy Massar's picture
Betsy Massar
98.9
8
dosk17's picture
dosk17
98.9
9
GameTheory's picture
GameTheory
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”