How to forecast working capital items ?

Hi everyone ! I'm wondering how can I forecast working capital and more specifically " current asset or current liabilities". I first took the opening and the closing balance previous year and I calculated the variation. But, I would like to find a better methods. If you can suggest me some articles, website I would be glad.

6 Comments
 

Given that I have never forecasted it, I would opt for one of the following methods, ordered form the one I would use to the last chance:

  • Ratio relative to the payroll/wages expenses (if the income st. explicits it, but pay attention because if the general expenses (SGA) include wages of managers, sellers etc. you can't use it)
  • Ratio relative to the number of employees (if you know the number)
  • Ratio relative to the revenue

Each one using the same formulas used in the DPO,DSO and DIO but substituting the denominator with the measure I suggested in the bulllet points.

 
Most Helpful

You need to look at pay period timing if you're trying to get a very accurate accrued payroll balance.

If you're just looking for trends then Ajeje's methods are fine, but if you need a specific 12/31 balance (and it's material) you need to look at pay periods. If employees are paid every 2 weeks then timing could make a big difference in the accrual

twitter: @CorpFin_Guy
 

Ut sit ex inventore enim laudantium. Est unde voluptatum impedit consequatur. Libero autem enim sint dolor et. Magnam nihil facere ut dolores ipsum atque.

Maxime distinctio id earum voluptatum. Culpa doloremque omnis laborum eligendi quae necessitatibus. Tempora distinctio eos quia quia praesentium.

Harum dolores quibusdam cupiditate. Consequatur iste nemo illum voluptatem voluptatem.

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.8%
  • Morgan Stanley 07 97.3%

Overall Employee Satisfaction

September 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 07 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan No 97.3%

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (51) $260
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (26) $182
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
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...”