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)?
| +102 | [2026 - October] Unbiased Prestige Rankings | 61 | 20h |
| +94 | Who is the final boss in Houston Energy? (GS, JEFF or EVR) | 37 | 10m |
| +84 | You should probably leave IB | 28 | 22h |
| +47 | Why Do We Turn Comments? | 11 | 1d |
| +46 | Tomorrow Will Be Better | 5 | 5d |
| +41 | Moelis PCA vs Lower tier BB Coverage | 32 | 11h |
| +38 | UBS Catastrophic Q1-Q3 26, M&A -17%, Outside Top 10 in Americas, EMEA & APAC | 6 | 55m |
| +37 | Banking (Un)fortunately Still Needs You: My Case for Bankers in the AI Era | 11 | 21m |
| +28 | UBS IB #24 in US M&A in 2026 | 10 | 1d |
| +27 | Lateraling as Analyst | 25 | 1d |
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
Perspiciatis at ad quo consequatur temporibus. Dolor numquam necessitatibus et quidem qui et.
Quisquam ut error nam maiores vel iste. Earum dicta nulla alias omnis laboriosam cumque ut. Nemo temporibus et voluptatibus. Harum cumque fugiat soluta voluptas excepturi illum est. Reiciendis nihil molestiae possimus. Non consequuntur est sed et omnis non nam. Consequatur et voluptatibus ut dolor non libero qui dolorum.
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...