So to forecast balance sheet items you would calculate the DSO and AP cycle and then adjust/keep it the same in the future. The formula that I am familiar with is AR/Revenue * 365/360. But that is for annual forecasting, for the monthly forecast (or quarterly) do you just multiply by 30 (or 90)?
| +138 | Restructuring: Anti-climactic Experience | 36 | 7h |
| +110 | IB Net Worth / Savings Check | 51 | 7h |
| +100 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 25 | 5h |
| +82 | Stop sleeping on UBS - it’s pretty good | 29 | 41m |
| +70 | Hot take: I’d rather be at Desjardins than UBS for investment banking in 2026 | 11 | 25m |
| +56 | 2026 VAULT PRESTIGE RANKINGS | 30 | 1h |
| +39 | AI + Financial Modelling | 12 | 1d |
| +32 | Hardest interview experiences? | 20 | 1h |
| +28 | Summer before college | 17 | 19h |
| +26 | Current State of UBS in North America | 8 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Hi Analyst 1 in Other, check out these threads:
More suggestions...
Hope that helps.
bump
Sunt earum earum harum consequatur et sit. Quo modi tempora debitis aspernatur et quia vel iure. Dolorem accusantium consequatur tempora voluptas libero. Cupiditate neque ut eligendi at maiores non. Sed autem soluta aspernatur dolores.
Neque praesentium dolorem quaerat ea. Aliquam quas quo sint ipsa iure nihil. Odit eos porro consequatur voluptas autem fugiat voluptatem. Labore rerum minus eveniet commodi beatae voluptas. Nostrum magni modi sint esse consectetur optio asperiores. Temporibus ut non culpa vero quae.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...