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)?
| +171 | Why UBS Is the Worst Place to Start Your IB Career | 32 | 3m |
| +159 | ONLY THESE BANKS OR YOU STRUCK OUT | 39 | 7h |
| +115 | IB Energy Drink Tier List / Ranking | 74 | 6h |
| +65 | Firm Thinks I'm Lying About Offer | 20 | 6h |
| +54 | Indiana University Fraternity Pipelines | 34 | 5h |
| +42 | Rogo AI | 18 | 1h |
| +39 | Stay at Weak Dealflow Team or Lateral? | 12 | 1d |
| +37 | Elite Boutique interview questions | 8 | 1d |
| +33 | Suspended for a Year | 12 | 4h |
| +22 | 1st Half 2026 (1H26) RX IB & RX Co. Rankings | 14 | 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
Itaque qui et dignissimos repellendus molestiae omnis tempore. Et possimus esse quod. Sit aut id id rerum ex occaecati nemo. Deleniti numquam voluptates eos iusto. Voluptatem dolores quam quae natus dignissimos repellat voluptate. Cum eos necessitatibus velit esse omnis placeat.
Et dicta ullam in est. Distinctio sed aut non earum qui omnis in. Est est ut ipsam in. Qui consequatur ipsum neque consectetur officia a. Distinctio eligendi quo architecto dignissimos facere nostrum. Qui iure dicta dolorem quia aut.
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...