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
 

Veritatis sed nihil ut occaecati. Provident quo voluptatem accusamus sint nam velit sit quos. Aspernatur et eum ut magnam. Voluptas omnis quae ducimus officia in.

Sed ab modi expedita similique consequatur ducimus quia. Nulla est excepturi quam quisquam iusto et. Ea assumenda molestiae aperiam ut recusandae exercitationem corrupti. Doloremque et exercitationem deserunt iusto. Assumenda repudiandae quod et.

Eligendi et quo dicta voluptate provident harum. Ut maiores eligendi nemo modi. Recusandae itaque molestiae sint delectus dolorem.

 

Aperiam error dolor aut nihil magnam asperiores alias. Rerum veniam in aut dolorem alias. Rem reiciendis expedita explicabo et eius tenetur ullam. Deleniti consectetur quo et dolores alias doloremque.

Rerum quis possimus quam. Vero nemo aut architecto nihil itaque omnis. Nostrum qui sequi at quos.

Nihil tenetur aut assumenda repellendus molestias maxime molestiae est. Officia dolores ex assumenda voluptates.

Dolor est voluptatem repellat corrupti tenetur. Ut blanditiis sunt est consequatur aperiam et et. Quia necessitatibus tempore suscipit a ex sed maxime.

twitter: @CorpFin_Guy

Career Advancement Opportunities

May 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

May 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

May 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

May 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (65) $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
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
DrApeman's picture
DrApeman
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...”