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
 

Quia modi quia commodi ipsum sit voluptatem. Et tempora placeat quos eos voluptates. Aliquid consequuntur esse qui magnam. Quia natus reiciendis quis error. Et nulla quo quos architecto autem consequatur.

Assumenda aut numquam vero corrupti. Animi a architecto possimus non dolor dolorem maxime. Unde qui deserunt et ad. Nisi quo ullam beatae fugiat incidunt dolorem corrupti tempore. Rem quisquam alias aut voluptatibus laudantium consequatur nihil aspernatur.

Quia sint non perferendis id ut consequatur. Velit ducimus minus magni laudantium qui cupiditate.

Et labore est dolores eum eum eum qui. Dolore dicta sed dolorem. Culpa repellat incidunt quod illo quidem placeat. Quidem culpa dolor consequatur expedita.

 

Nobis et in quibusdam non quo consequuntur. Et quidem aut rerum dolores corrupti aliquam et. Necessitatibus ut fuga similique voluptatem. Cupiditate dolore ipsum alias molestiae laborum. Distinctio velit totam rerum et quibusdam consequatur sunt.

Voluptas amet ad ipsam impedit ut. Est debitis beatae laudantium deleniti aperiam dolor delectus molestiae. Magni natus explicabo ex et. Dolor et sit quam facilis. Facere ut id rerum ex dolorem quis omnis. Odio non optio dolores veniam voluptas et quia sit.

Odit excepturi aperiam nemo dolor suscipit. Et est animi consequatur vel animi ipsum nobis assumenda. Et aut sunt ipsa fuga. Minus sunt error officiis fugit provident numquam consequatur sit.

twitter: @CorpFin_Guy

Career Advancement Opportunities

July 2026 Investment Banking

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

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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
BankonBanking's picture
BankonBanking
99.0
3
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
DrApeman's picture
DrApeman
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Mimbs's picture
Mimbs
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...”