Preview

Accounts Receivable Turnover

Good Essays
Open Document
Open Document
545 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Accounts Receivable Turnover
Accounts Receivable Turnover = Net Sales/Average Net Account Receivables
Accounts receivable turnover ratio measures the effectiveness of a company in extending credit and collecting debts. It is an activity ratio that measures how efficiently a firm uses its assets.

Year
ABC
DEF
GHI
Industry Average
2012
31, 053/988 = 31.43
16,842/1,282.5 = 13.13
5,160/618 = 8.35
17.64
2013
32,722/1,042 = 31.4
18,657/937 = 19.91
5,858/494 = 11.86
21.06

In this table you see the accounts receivable turnovers from the 3 companies in year 2012 and 2013. For Company ABC, accounts receivable turnover in 2012 is 31.43 and 31.4 in 2013 with only a 0.03 change. As compared to companies DEF and GHI, company ABC has a much higher accounts receivable turnover. It suggests that when a company has a higher turnover, a company is operating either on cash basis or its credit collection side of the company is efficient. Company DEF is in the middle, its account receivables turnover in 2012 is 13.13 but showed an increase in 2013 where turnover is 19.91. The lowest accounts receivable turnover is company GHI in year 2012, where it had 8.35, and increased to 11.86 in 2013. Given that GHI has lower accounts receivable turnover, the company need to re-assess its credit policies to ensure timely collection of credit sales or maybe the credit policy is too tight that can result to loss of sales.
On the contrary, the industry average is way lower than Company ABC’s accounts receivable turnover, it’s around 56% - 67% higher than the normal level of account receivable turnover for the industry in both years. With very high values, this ratio may not be very favorable too. However, between the 3 companies, Company ABC, is still much better than the other when it comes to the account receivables turnover ratio because in both years, it is the only Company ABC that surpassed the industry average.
Average Net Receivables = Beginning Net Receivables + End Net Receivables/2

Year
ABC
DEF
GHI
2012
1976/2 =

You May Also Find These Documents Helpful

  • Good Essays

    Pinnacle Case Summary

    • 801 Words
    • 4 Pages

    When reviewing the ratio calculations, it is apparent that the company’s likelihood of failing financially in the next 12 months is low. This is because it is apparent that the short-term debt paying ratios are down from the previous years. For example, the current ratio has decreased from the preceding year concluding that the current assets can cover the current liabilities successfully. Also looking at days to collect receivables is also lowered which presents that it takes less days for the company to collect their receivables implying that the monies owed to them are coming in more quickly. Lastly, in order for a company to succeed they need to have a good turnover rate for the inventory which is just what Pinnacle company has. The inventory turnover ratio is low indicating that it is taking fewer days than before to sell inventory.…

    • 801 Words
    • 4 Pages
    Good Essays
  • Good Essays

    D. Accounts Receivable Turnover: Liquidity of assets measured by Accounts Receivable Turnover. Home Depot ratio in this department is 60.4. Optimal ratios are always higher, and Company G shows a steady decline (32.2—30.4) representing values below industry quartile benchmarks (30%/45%/66%). Ratios representing Company G are below industry average. Accounts Receivable Turnover represents weakness for Company G.…

    • 910 Words
    • 4 Pages
    Good Essays
  • Better Essays

    When it comes to preparing journal entries, there are different methods that are used with accounts receivable and bad debts such as the percentage of sales and the percentage of receivable methods. The percentage of sales estimates what percentage of credit sales will be uncollectible. This percentage is based on past experience and projected credit policy. The company applies this percentage to either the credit sales or the net credit sales of that current year. The percentage of receivables estimates what percentage of receivables will result in losses from the uncollectible accounts. The company uses an aging schedule in which classifies customer balances by the length of time they have been unpaid. After the company arranges the accounts by age, it determines the expected bad debt losses. The longer a receivable is past due, the less likely that it will be collected.…

    • 1283 Words
    • 6 Pages
    Better Essays
  • Satisfactory Essays

    fin 341

    • 363 Words
    • 2 Pages

    Inventory turnover ratios show the number of times a company’s inventory is “turned over” in a year. KR’s turnover ratio is 18.80 where as WFM has an inventory ratio of 31.28, which show that KR seems to have a better…

    • 363 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Fnt Task 1

    • 1124 Words
    • 3 Pages

    Next,” inventory turnover ratio” measures the number of times a company sells its inventory during a year. A high rate of turnover indicates ease in selling inventory; a low rate indicates difficulty. It’s calculated by cost of goods divided by average inventory. In 2011, the inventory turnover was 6.1. By 2012 the ratio decreased to 5.2. The decrease may be due to a slow ability to turnover merchandise in sales and paying a higher cost for goods. This is considered to be a major weakness rating in the lower third quartile group compared to industry’s…

    • 1124 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    This ratio shows the company how quickly accounts receivable are paid. A high turnover generally means more cash on hand for the company.…

    • 572 Words
    • 3 Pages
    Satisfactory 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
  • Powerful Essays

    A high inventory turnover ratio is sometimes not a good thing for it reveals that the company may not have enough inventories to sell. People can analyze inventory turnover ratio with days in the inventory ratio.…

    • 1907 Words
    • 8 Pages
    Powerful Essays
  • Powerful Essays

    3. Inventory turnover ratio is a ratio showing how many times a company's inventory is sold and replaced over a period. It’s important to continuous improvement because it helps the business to overview the bigger picture of the performance of the business. The business will have more control of their stock…

    • 2092 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    In order to resolve this problem, a combined effort from all departments within this organization must be implemented. This includes the Administrative department, the Finance department, the Health Information Management department, as well as the patient. Each department will provide a specific set of functions from various resources to the overall execution of the newly designed plan.…

    • 867 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Secondly I am going to compute Activity Ratios for both AT&T and Verizon. Inventory turnover is defined as the speed with which inventory is sold. For AT&T their inventory turnover is at 46.1 and Verizon’s is at 43.0. Receivables turnover is defined as the speed with which account receivable are collected (Mayo, 2012). For AT&T their receivables turnover is 9.6 and Verizon’s is 9.8. Total asset turnover is the measure of total assets required to generate sales (Mayo, 2012). AT&T and Verizon’s total asset turnover is 0.5.…

    • 687 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Accounts Receivable shows how much inventory (in days) is on hand. It indicates how quick a company responds to market and/or product can change. Not all companies have inventory for the metric.…

    • 775 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Fly-by-Night Case

    • 567 Words
    • 3 Pages

    There were many signals shown in the financial statements and other exhibits in the case that represented poor cash flow through Year 14. The most obvious of them all is that the collectability of the accounts receivables was problematic. It seemed as if Fly-by-Night had a good system of collecting their sales on account from year 9 to year 10 as the accounts receivable number decreased during those years. However, the accounts receivable account increased by more than six times through years ten and fourteen. Because of this poor system of collecting accounts receivable, Fly-by-Night’s cash flow would suffer. The same can be said about the inventory account. Because the amount of inventory increased by almost five times through years twelve and fourteen, the cash would continue to decrease at the same rate.…

    • 567 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Accounts Receivable

    • 298 Words
    • 2 Pages

    There are several controls in accounts receivable. A thorough audit should be daily comparing the checklist and the system records in customers’ accounts. This is to ensure the payment received is applied to the right customer. A second control is to check if customers’ balances in record are true. One simple way is to send current statements to customers monthly. Customers can help identify if there is any discrepancy between their record and the account statement. A third control is to reconcile customers’ accounts in a periodic basis. A transaction can be recorded only in customers’ account when a copy of final invoice is received. All the transactions should have the invoice as backup. A fourth control is the separation of duty. The person who has authority to approve order cannot record invoice in the system. An accounts receivable personal shouldn’t receive payment directly and should not have authority to access cash account. A fifth control is to have restricted control on customers’ accounts files including all necessary backup to support their account balance and creating new accounts. If there is no restriction access, anyone can alter or destroy records and backups. Without all proper backups, an account is less likely collectable. Even if it can be collected, it will prolong the return cycle. Only authorized personal can create accounts. This stops someone from creating dummy account for illegal use. A sixth control is on credit limit. The authority to prove credit limit should be given to credit manager only. If credit manager is absent, controller should take the responsibility. The credit manager should receive a credit application from customers. Then, he/she needs to reach out to the reference for credit check. Based on the feedback, he/she can approve the credit…

    • 298 Words
    • 2 Pages
    Good Essays

Related Topics