does forecasting accounts payable not take into account company policy?
Let's say we're using the quick and dirty method of forecasting accounts payable.
We take previous AP / previous Revenue = %
We then use that % going forward and apply it to the next quarters revenue in order to arrive at the new accounts payable. However, this doesn't make that much sense to me.
Past quarter: 100 rev, 10 AP = 10%
This quarter: 0 rev *10% = 0
This implies that this quarter, there would be a balance of 0 for accounts payable. However, what if the company policy was to pay AP every 2 months? This implies the entire balance is paid off.
Am I thinking about this wrong?
Del
doesn't that yield the same results?
Forecasted Accounts Payable = A/P Days × COGS ÷ 365 Days
If revenue in the next quarter is 0, COGS is also 0, and your AP ends up being 0
Formulas wrong
AP days
doesn't that yield the same results?
Forecasted Accounts Payable = A/P Days × COGS ÷ 365 Days
If revenue in the next quarter is 0, COGS is also 0, and your AP ends up being 0
You said yourself that your formula was “quick and dirty”, so it shouldn’t surprise you that it doesn’t work in an edge case like this.
I’m struggling to imagine a company that has zero rev for an entire quarter when it did before. Could you give an example?
I like to use extreme examples to test my understanding. 0 revenue could be maybe covid?
This example is simply so extreme that it throws off the usual rule.
Omnis non tempore placeat qui excepturi. Aut et quisquam molestiae dicta libero soluta.
Facere est beatae tempora odit perferendis. Tempora deleniti aliquid qui labore. Facilis non corporis sequi culpa libero tempore. Dignissimos ut ut praesentium animi accusamus consequatur voluptas. Hic autem possimus qui consequatur dignissimos culpa.
Et fugiat et quae sunt sit voluptatem neque. Quasi assumenda fugit sit. Aut culpa aspernatur laboriosam doloremque repudiandae earum. Qui tempora nisi aut ut dolores. Voluptates est quis non a cupiditate nisi et. Mollitia voluptatem a dolorem animi.
Dolorum repudiandae dolorem doloribus facilis quisquam ipsa. Tempore consequuntur non delectus est quas. Qui odio saepe quibusdam dicta magni veniam.
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...