# Aging Schedule of Accounts Receivable

Powerful Essays
1408 Words
Grammar
Plagiarism
Writing
Score
Aging Schedule of Accounts Receivable
ANSWERS TO QUESTIONS: 1. Table 1: Aging Schedule of Accounts Receivable AGE OF ACCOUNT | BALANCE OUTSTANDING | % OF TOTAL BALANCE OUTSTANDING | 0-15 days | \$ 20,000 | 19.59 % | 16-30 days | 30,000 | 29.39 | 31-60 days | 40,000 | 39.19 | 61-90 days | 10,000 | 9.80 | Beyond 90 days | 2,071 | 2.03 | TOTAL | \$ 102,071 | 100.0 % |

2. To evaluate the credit quality of Aero-Strip’s accounts receivables portfolio, we turn to their average collection period (ACP) and aging of accounts receivable. Knowing the ACP enables the firm to determine whether there is a general problem with the accounts receivable. The firm has credit terms of 2/10, net 30 so it would expect its ACP to equal about 30 days. Calculating the ACP of the firm, we get:
ACP=Accounts Receivable ×365 daysNet credit sales= \$100,000 ×365 days\$705,882=51.71 days

Since ACP is significantly higher than 30 days, the firm should review its credit policy. In addition, the industry norm for ACP is only 32 days.
Next, we turn to the aging accounts receivable schedule. Because Aero-Strip extends a credit term of 2/10, net 30 to its customers, its customers have 30 days to remit the payment. Looking at the aging schedule of A/R (answer in #1), the 48.98% of the balance outstanding with an age of 0-30 days is current. A portion of 19.59% takes the cash discount offered. The balances outstanding for 31-60 days, 61-90 days and beyond 90 days are overdue which represents 51.02% of the whole amount of outstanding balance. Of the balance outstanding, 39.19% is 1-30 days overdue, 9.86% is 31-60 days overdue and 2.03% is more than 60 days overdue. The 2.03% is usually seen as uncollectible and a bad- debt. This is another sign that something is wrong with the company’s credit policy. The collection seem generally slow and a noticeable irregularity in these data is the high percentage of balance outstanding that is 1-30 days overdue. Clearly, a problem must have occurred 31-60 days ago. The problem can be

## You May Also Find These Documents Helpful

• Good Essays

b. An examination of customers' accounts shows that accounts totaling \$679 should be written off as uncollectible. Using an aging of receivables, the company determines that the ending balance of the Allowance for Doubtful Accounts should be \$700.…

• 780 Words
• 4 Pages
Good Essays
• Good Essays

Shows the average number of days taken by the company to collect its receivables. The lower the ACP, the better.…

• 616 Words
• 4 Pages
Good Essays
• Powerful Essays

APPENDIX-A BALANCE SHEET ANALYSIS | | | Chipotle | 2011 | 2010 | Total liabilities | 381,082 | 310,732 | Total Shareholder 's Equity | 1,044,226 | 810,873 | Debt ratio | 27.70% | 26.73% |…

• 1971 Words
• 8 Pages
Powerful Essays
• Satisfactory Essays

Due to the credit policy of Milwaukee Surgical Supplies, about \$90,000 of the company is always tapped in receivables. The company thinks of reducing this balance by following a strict policy for non-discounted customers from 40 to 30 days. It will reduce the average collection period by 3 days and the receivables outstanding will be \$80,000. Home Infusion’s receivable balance would be \$20,000. This is quite less as compared with Milwaukee.…

• 292 Words
• 2 Pages
Satisfactory Essays
• Good Essays

Chiller Company has credit sales of \$5.60 million for year 2010. Chiller estimates that 1.32% of the credit sales will not be collected. Historically, 4% of outstanding accounts receivable is uncollectible. On December 31, 2010, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of \$3561. Chiller prepares a schedule of its December 31, 2010, accounts receivable by age. Based on past experience, it estimates the percent of receivables in each age category that will become uncollectible. This information is summarized here:…

• 2196 Words
• 9 Pages
Good Essays
• Good Essays

The company’s asset management ratios also show decreasing numbers. The inventory turnover ratios have decreased as well as the total asset turnover. This explains the number of times a company 's inventory is sold and replaced during a period. The company 's days sales outstanding (ACP) also rose from 36.00 in 1990 to 53.99 in 1992. This shows us that Mark X 's average number of days to collect revenues after a sale has increased. This number is unfavorable because this…

• 1418 Words
• 4 Pages
Good Essays
• Good Essays

Attached are the results from last weeks performance for those accounts that are past due with a past due balance 30+ days or older. As a unit, we reduced the number of these accounts this week by 1,043 and the past due balance by \$2,200,318.…

• 83 Words
• 1 Page
Good Essays
• Powerful Essays

The accounts receivable management ratios show a collection period that’s 9 days lower than the industry average. This is a sign of good management as the company wants to collect payment as quickly as it can. The company might be too tight with its crediting terms, and can possibly look at relaxing its crediting policy a little. The accounts receivable turnover ratio is 4.49 which further show that the company has an efficient collection system in place.…

• 1083 Words
• 5 Pages
Powerful Essays
• Better Essays

The company’s accounts payable is also a concern. Its accounts payable has grown by 17.94% per year on average, compared to its sales growth of 16.96% per year on average. Their accounts payable turnover has increased from 67.88 days and 70.22 days from 2007 to 2011 respectively. (Appendix B, E) This allows them to make it seem like they have more cash than they actually do, because they should be using it to repay their debts. This is also vulnerable to change even more, because of the cyclical pattern…

• 838 Words
• 4 Pages
Better Essays
• Good Essays

Riordan also exhibits possible concerns with its accounts receivables and inventory levels. The company has a receivable turn of 8.67, meaning that it takes and average of 42 days for its customer to pay on its bills. While this falls slightly…

• 245 Words
• 1 Page
Good Essays
• Good Essays

Want to improve the way you run your business? For any company, having overdue accounts wreak havoc on cash flow and liquid assets. In a small business, tracking down the guilty parties is both a financial and physical drain. It's easy to say "don't do business with deadbeats", but the realities of things are much more complex. Most firms bring in collection agencies for debt. Be sure to find out:…

• 535 Words
• 3 Pages
Good Essays
• Powerful Essays

Introduction Financial management focuses in finding the value in accounts receivable by emphasizing on improving the collections process and hence accelerating the cash flow. ‘Revenue Outstanding’ is the amount due from the customer as a result of an organisation’s normal business operation, that is, it is the amount that has been billed by organisations and is due, but which has not been collected. The management of ‘Revenue Outstanding’ is an important source of cash and hence an important parameter that the management should measure. The estimation of time to recoup the revenue outstanding is important to determine the profit of any organisation. Most prefer to receive payment immediately rather than to wait for it, especially because sometimes payment is never made in the latter scenario. There is no one general technique to estimate the time to recoup the revenue that can be adopted by all the organisations. It varies from organisation to organisation depending on the nature of business and the needs and strategies of the management. Although there is no certainty of receiving payments from all the customers, organisations use various methods to calculate the revenue outstanding or the payment that will be recovered later at a any particular point of time. The Weeks Billing Outstanding (WBO) measure calculates the revenue outstanding based on the total number of week’s billings required to recoup current Revenue Outstanding. The WBO is an important financial parameter, which shows the age in weeks, in an organization's accounts receivable and is defined in terms of the average time taken to convert the outstanding revenue into cash. The WBO measure helps the management to measure the effectiveness of collection activities and alert the management with problem accounts. If the WBO is low, then less time is spent to collect outstanding revenue. By quickly converting the billings…

• 1654 Words
• 7 Pages
Powerful Essays
• Good Essays

The more accurate allowance method would be the "balance sheet" approach or the age of the receivables.…

• 2371 Words
• 33 Pages
Good Essays
• Satisfactory Essays

Assignment 2 Exercise Robert’s Hardware Franchise Philippe Levy Financial Accounting MBA © Philippe Levy 1994-2014 1 CASE EXERCISE Home Repair Inc. offers the latest styles in residential hardware at competitive prices. In business since 1986, Home Repair operates under a franchise concept with 80 locations across Canada. Robert owns and operates a franchise.…

• 299 Words
• 4 Pages
Satisfactory Essays
• Better Essays

Further analysis showed Arlene that the firm 's average collection period was 60 days. The industry average, derived from the trade association data and information on three similar publishing companies, was found to be 42 days - 30% lower than Roche 's. Arlene estimated that if Roche initiated a 2% cash discount for payment within 10 days of the beginning of the credit period, the firm 's average collection period would drop from 60 days to the 42-day industry average. She also expected the following to occur as a result of the discount: Annual sales would increase from \$13,750,000 to \$15,000,000; bad…

• 1026 Words
• 5 Pages
Better Essays