Forecasting AR and AP for monthly statements
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)?
Hi Analyst 1 in Other, check out these threads:
More suggestions...
Hope that helps.
bump
Excepturi ut laudantium alias dolores. Dolores eos molestias ipsam. A minima aut quia numquam hic quisquam iure. Quod aliquid dolor dolor.
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...