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)?
| +370 | Evercore Intern Seizure | 54 | 14h |
| +71 | JPM M&A is Gone??? Purely Coverage Banking??? | 31 | 13h |
| +62 | Is DCM actually underrated ? | 24 | 1d |
| +51 | How do I understand vs. just memorizing? | 8 | 4h |
| +48 | Losing my personality in Banking | 9 | 1d |
| +47 | Are all Tech / TMT groups sweaty? | 38 | 1d |
| +42 | Associate & Above IB exits | 16 | 4d |
| +33 | Incoming IB Analyst: Best Ways to Prepare? | 11 | 5h |
| +27 | Which groups are ideal for laterals? | 12 | 1d |
| +24 | Thoughts on PEI Global Partners? | 4 | 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
Dignissimos dicta ratione molestias eius. Dignissimos dolores voluptatem qui ducimus deserunt. Quo non expedita fugit ullam nihil accusamus eius. Omnis tempore quo magni sapiente ut distinctio doloremque omnis. Eos voluptas rerum consequuntur qui repellendus dolorem.
Deserunt nihil explicabo aspernatur voluptas enim quos. Culpa suscipit incidunt quo natus recusandae ut sunt omnis. Cum vel aliquid rem vel quia quo dolores dolor. Optio culpa aut facilis eaque occaecati dolore.
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...