Question
Park Avenue Tire Company has been operating in Winnipeg for more than 30 years and has a very loyal customer base. The company sells and
Park Avenue Tire Company has been operating in Winnipeg for more than 30 years and has a very loyal customer base. The company sells and installs tires and the owners pride themselves on the excellent business relationships they have developed with both their customers and suppliers. The company often sells tires on credit, allowing customers to pay their balances within 30 days. Collection of accounts receivable has never been a problem, with most people paying their balances within 60 days. Park Avenue purchases tires from most of the large national brands and, due to the nature of the business, generally maintains a fairly large inventory. It is essential that the company have the necessary tires on hand to meet customer needs due to increased competition from large retailers such as Canadian Tire and Walmart. The company has always had sufficient cash to pay its suppliers immediately and take advantage of cash discounts. However, this month, for the first time ever, Park Avenue does not have sufficient cash in the bank to meet its supplier payments. Chris Park, son of the original owner, Ernest Park, is currently operating the business and is very concerned about the companys inability to maintain what he feels are adequate levels of cash. Your firm has been the accountants for Park Avenue Tire Company for the past 20 years. Chris has approached the firm expressing his concerns and asking for advice on how to solve the cash flow problems. As part of your analysis, you review the companys financial statements for the past three years. Excerpts from the financial statements are presented below.
Dec. 31, 2020 Dec. 31, 2019 Dec. 31, 2018 Current assets Cash $11,800 $35,600 $37,800 Accounts receivable 16,300 12,900 9,300 Inventory 173,600 123,300 117,300 Prepaid expenses 7,800 8.100 6,200 Total current assets $209,500 $179,900 $170,600 Current liabilities Accounts payable $64,500 $54,400 $31,600 Salaries payable 4,400 6,000 3,700 Income tax payable 1,600 1,300 1,900 Total current liabilities $70,500 $61,700 $37,200 During 2020, credit sales and cost of goods sold were $164,000 and $103,000, respectively. The 2019 and 2018 credit sales were $177,000 and $178,000, and the cost of goods sold for the same periods were $92,000 and $92,000, respectively. The accounts receivable and inventory balances at the end of 2017 were $5,500 and $94,000, respectively. (a1) Using the above data calculate the following ratios: (Round receivables turnover ratio and average collection period to 1 decimal place, e.g. 15.2, days in inventory to O decimal places, e.g. 152 and all other answers to 2 decimal places, e.g. 15.25.) During 2020, credit sales and cost of goods sold were $164,000 and $103,000, respectively. The 2019 and 2018 credit sales were $177,000 and $178,000, and the cost of goods sold for the same periods were $92.000 and $92,000, respectively. The accounts receivable and inventory balances at the end of 2017 were $5,500 and $94,000, respectively. (a1) Using the above data calculate the following ratios: (Round receivables turnover ratio and average collection period to 1 decimal place, e.g. 15.2 days in inventory to 0 decimal places, e.g. 152 and all other answers to 2 decimal places, e.g. 15.25.) 2020 2019 2018 a. Current ratio :1 :1 :1 b. Quick ratio :1 :1 :1 C. Receivables turnover ratio times times times Average collection period days days days Inventory d. turnover ratio times times times Days in inventory days days daysStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started