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)?
| +244 | Who Killed Wall Street | 68 | 2h |
| +195 | Worlds Worst MDs Competition (2026 Edition) | 45 | 8h |
| +154 | Only Indians cold emailing | 46 | 2h |
| +149 | UBS Healthcare | 41 | 57m |
| +125 | Lindsay Clancy - Thoughts from A2 | 22 | 3d |
| +53 | More diversity needed in the industry | 11 | 1d |
| +51 | Shana tova - happy new year | 7 | 7h |
| +48 | NYC Wall Street Run Club | 13 | 16h |
| +48 | Did My Team Set Me Up to Miss VP? | 24 | 1h |
| +43 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 22 | 11h |
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
Distinctio accusantium nostrum quisquam voluptas ducimus laboriosam architecto. Facilis fugiat accusamus sit sed in error. Ullam id id et sed quo et. Quia tempore earum inventore quidem sed.
Et qui et aut quasi possimus. Ipsa deserunt culpa vel. Commodi saepe id non. Qui quas quam deserunt dolorum ipsum dolore rerum tempore. Officiis est vitae officia magnam modi hic a.
Est eum quidem sed exercitationem. Ut accusamus harum repudiandae dolorem quas voluptates. Nihil pariatur aliquid sit quidem. Magni rerum optio corporis qui.
Voluptas et tempora natus amet. Magnam aperiam ad natus rerum et eligendi alias. Dolor aut est cum velit suscipit error fugiat. Soluta in natus reprehenderit nulla enim.
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...