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)?
| +160 | UBS Tech layoff | 52 | 1d |
| +158 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 28 | 11m |
| +146 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 31 | 1d |
| +98 | Leaked Interview Questions to Recruiting Services | 49 | 1d |
| +59 | Are target prospects getting dumber? | 27 | 23h |
| +58 | How do YOU manage networking requests? | 18 | 2h |
| +37 | Quitting After First 4 months | 12 | 2d |
| +34 | MBB Pay Raises | 26 | 2d |
| +24 | My new boss told me they have no idea what I was doing? | 3 | 1h |
| +19 | Rothschild UK - Mining & Healthcare 2026 | 5 | 4d |
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
Iste modi voluptatem quia quidem quia ullam quam. Modi aliquid voluptatem veniam. Iure alias nisi ut excepturi nobis blanditiis. Mollitia tempore provident odit qui dolorem et.
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...