Posted: 10 Jun 2009 at 09:33 | IP Logged
|
|
|
Every day during the month 45,000 is hitting accounts receivable; assume 30 days in a month. 45,000 billed each day is an increase of 1,350,000 for any given month (45,000 * 30).
The question is really asking what the average receiable balance would be on any given day, so the 30 day period keeps rolling. Every day 45,000 of new charges come on accounts receivable and payments for 45,000 of previous charges come off. The amount being paid is comprised of 18,000 from those who owe you from 30 days ago and 27,000 from those who owe you from 10 days ago.
A "base" accounts receivable exists because for the very first month the A/R existed, it was increased by 1,350,000 and decreased by a portion of the payments for customers paying within the discount period. 60% of the payments for the 1,350,000 increase in A/R are received within the discount period. However, for the first month, the decrease to A/R for those payments would only be for 20 days; payments received for increases to A/R during the last 10 days of the month would fall into the next month. 40% of the payments for the 1,350,000 increase to A/R fall into the next month entirely. So, the decrease to A/R for the first month would be 540,000 (1,350,000 x 60% x 20/30). 1,350,000 - 540,000 = 810,000. Once you hit the beginning of the second month, the A/R would continue to roll as described above.
Hope this helps!
__________________ FAR-85 (5/01/09)
BEC-83 (5/30/09)
REG-81 (7/02/09)
AUD-84 (8/03/09)
|