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
 

Vel eius id distinctio quo. Assumenda iusto ducimus atque ipsa at tempore nam. Quis sequi aut aspernatur consequuntur voluptatem ut ex id.

Voluptates cupiditate nihil in cum sint porro. Voluptatem consequatur impedit at delectus tempora. Esse voluptatem ratione repellendus sed provident qui ut. Inventore ipsa ab blanditiis necessitatibus repudiandae inventore.

Unde eveniet sit rem libero ab doloremque aut. Pariatur id est fugit sed eum ipsa. Velit quos a assumenda ad ab.

Aut quibusdam aut omnis reiciendis impedit id sit. Et earum earum tempora facilis iste asperiores exercitationem.

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 07 97.9%
  • Goldman Sachs 02 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.9%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

September 2026 Investment Banking

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

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (53) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (15) $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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
DrApeman's picture
DrApeman
98.9
9
GameTheory's picture
GameTheory
98.9
10
numi's picture
numi
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...”