Question

In: Accounting

Below is selected data of Pronto Company: Balance Sheet Data As of December 31: 2012 2011...

Below is selected data of Pronto Company:

Balance Sheet Data

As of December 31:

2012

2011

Accounts receivable

$671,000

$642,000

Allowance for doubtful accounts

    31,000

    22,000

Net accounts receivable

$640,000

$620,000

Inventories - LCM

$542,500

$642,500

Income Statement Data

Net credit sales

$3,150,000

$3,000,000

Net cash sales

     800,000

     600,000

Net sales

$3,950,000

$3,600,000

Cost of goods sold

$2,390,000

$2,160,000

Selling, general and adm. expenses

475,000

350,000

Other

150,000

125,000

Total operating expenses

$3,015,000

$2,635,000

Net income

$   935,000

$   965,000

Required:

a. What is the accounts receivable turnover for 2012?

b. What is the inventory turnover for 2012?

c. Comment on the change of quality of the account receivables from 2011 to 2012. Assuming the estimate of the Allowance account is about right, is it justifiable to accept the change of account receivable quality from 2011 to 2012?

Solutions

Expert Solution

A) Ans:

Accounts Receivable Turnover Ratio For 2012= Net Credit Sales/Average Account Receivables

=$31,50,000/$630,000=5 Times

Net Credit Sales=$31,50,000

Average Accounts Receivables=$620,000+$640,000/2=$630,000

B)Ans:

Inventory Turnover Ratio For 2012= Cost of Goods sold/Average Inventory

=$23,90000/$592,500=4.03 Times

Cost of Goods sold=$2,390,000

Average Inventory=$642,500 +$542,500/2=$592,500

C) Ans:

Based on the Comparative information ,The accounts receivable has a positive indication that the quality of account receivables is acceptable and Increased

Account receivables turnover during 2011= Net Credit Sales/Average Account Receivables=

=$3,000,000/620,000=4.84 and However in 2012=5 times,,Positive

Average accounts receivables =620,000

Inventory turnover ratio for 2011 = Cost of Goods sold/Average Inventory

=$2,160,000/$642,500=3.36 Times in 2012 4.03 times, Positive.

Cost of Goods sold=$2,160,000

Average Inventory=$642,500


Related Solutions

Oriole Company’s balance sheet at December 31, 2021, is presented below. Oriole Company Balance Sheet December...
Oriole Company’s balance sheet at December 31, 2021, is presented below. Oriole Company Balance Sheet December 31, 2021 Cash $13,680 Accounts payable $8,900 Accounts receivable 21,100 Common stock 21,800 Allowance for doubtful accounts (740) Retained earnings 13,330 Inventory 9,990 $44,030 $44,030 During January 2022, the following transactions occurred. Oriole uses the perpetual inventory method. Jan. 1 Oriole accepted a 4-month, 8% note from Betheny Company in payment of Betheny’s $4,800 account. 3 Oriole wrote off as uncollectible the accounts of...
Morgan Company’s balance sheet at December 31, 2019, is presented below. MORGAN COMPANY Balance Sheet December...
Morgan Company’s balance sheet at December 31, 2019, is presented below. MORGAN COMPANY Balance Sheet December 31, 2019 Cash $30,000 Accounts Payable $12,250 Inventory 30,500 Interest Payable 300 Prepaid Insurance 6,084 Notes Payable 60,000 Equipment 38,520 Owner’s Capital 32,554 $105,104 $105,104 During January 2020, the following transactions occurred. (Morgan Company uses the perpetual inventory system.) 1. Morgan paid $300 interest on the note payable on January 1, 2020. The note is due December 31, 2021. 2. Morgan purchased $240,000 of...
Oriole Company’s balance sheet at December 31, 2021, is presented below. Oriole Company Balance Sheet December...
Oriole Company’s balance sheet at December 31, 2021, is presented below. Oriole Company Balance Sheet December 31, 2021 Cash $13,680 Accounts payable $8,900 Accounts receivable 21,100 Common stock 21,800 Allowance for doubtful accounts (740) Retained earnings 13,330 Inventory 9,990 $44,030 $44,030 During January 2022, the following transactions occurred. Oriole uses the perpetual inventory method. Jan. 1 Oriole accepted a 4-month, 8% note from Betheny Company in payment of Betheny’s $4,800 account. 3 Oriole wrote off as uncollectible the accounts of...
Sheridan Company’s balance sheet at December 31, 2021, is presented below. Sheridan Company Balance Sheet December...
Sheridan Company’s balance sheet at December 31, 2021, is presented below. Sheridan Company Balance Sheet December 31, 2021 Cash $13,500 Accounts payable $8,300 Accounts receivable 20,600 Common stock 21,900 Allowance for doubtful accounts (860) Retained earnings 12,710 Inventory 9,670 $42,910 $42,910 During January 2022, the following transactions occurred. Sheridan uses the perpetual inventory method. Jan. 1 Sheridan accepted a 4-month, 8% note from Betheny Company in payment of Betheny’s $3,600 account. 3 Sheridan wrote off as uncollectible the accounts of...
Sheridan Company’s balance sheet at December 31, 2021, is presented below. Sheridan Company Balance Sheet December...
Sheridan Company’s balance sheet at December 31, 2021, is presented below. Sheridan Company Balance Sheet December 31, 2021 Cash $13,500 Accounts payable $8,300 Accounts receivable 20,600 Common stock 21,900 Allowance for doubtful accounts (860) Retained earnings 12,710 Inventory 9,670 $42,910 $42,910 During January 2022, the following transactions occurred. Sheridan uses the perpetual inventory method. Jan. 1 Sheridan accepted a 4-month, 8% note from Betheny Company in payment of Betheny’s $3,600 account. 3 Sheridan wrote off as uncollectible the accounts of...
Sheridan Company’s balance sheet at December 31, 2016, is presented below. Sheridan Company Balance Sheet December...
Sheridan Company’s balance sheet at December 31, 2016, is presented below. Sheridan Company Balance Sheet December 31, 2016 Cash $13,850 Accounts payable $8,650 Accounts receivable 21,200 Common stock 19,000 Allowance for doubtful accounts (810 ) Retained earnings 15,800 Inventory 9,210 $43,450 $43,450 During January 2016, the following transactions occurred. Sheridan Company uses the perpetual inventory method. Jan. 1 Sheridan Company accepted a 4-month, 8% note from Betheny Company in payment of Betheny’s $3,600 account. 3 Sheridan Company wrote off as...
Balance Sheets for the Years Ending Dec. 31, 2011 and 2012 2011 2012 Cash            300...
Balance Sheets for the Years Ending Dec. 31, 2011 and 2012 2011 2012 Cash            300            400 Accounts receivable        1,000        1,400 Inventories        3,200        3,000 Current assets        4,500        4,800 Net fixed assets        3,800        4,300 Total assets        8,300        9,100 Notes payable            400            300 Accounts payable            700            500 Accruals              50              80 Current portion of long-term debt              70              80 Current liabilities        1,220            960...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $254,100 $139,700 Property, plant, and equipment 499,730 450,850 Intangible assets 93,170 44,450 Current liabilities 177,870 107,950 Long-term liabilities 330,330 266,700 Common stock 67,760 63,500 Retained earnings 271,040 196,850 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $302,470 $187,680 Property, plant, and equipment 594,510 508,300 Intangible assets 146,020 86,020 Current liabilities 239,890 140,760 Long-term liabilities 406,770 320,620 Common stock 93,870 86,020 Retained earnings 302,470 234,600 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end...
Vertical Analysis of Balance Sheet Balance sheet data for Alvarez Company on December 31, the end of two recent fiscal years, follows: Current Year Previous Year Current assets $339,140 $197,040 Property, plant, and equipment 623,580 558,280 Intangible assets 131,280 65,680 Current liabilities 251,620 147,780 Long-term liabilities 404,780 295,560 Common stock 98,460 106,730 Retained earnings 339,140 270,930 Prepare a comparative balance sheet for both years, stating each asset as a percent of total assets and each liability and stockholders' equity item...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT