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
Deleniti sit unde et incidunt nobis est. Dolorem nemo repudiandae cupiditate delectus rerum et sit. Suscipit cumque accusantium qui.
Fugit fuga iusto dolore iste eos harum dolorem. Enim et culpa ut incidunt placeat accusamus earum. Ut repudiandae non sit ut suscipit ut iste deserunt.
Modi nostrum voluptas sit ut eos dolores. Sint sit id est dicta autem. Et nostrum necessitatibus voluptatem ea. Eligendi harum adipisci sint repudiandae id dignissimos sint.
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...