Question

In: Accounting

Exercise 13-7 Analyzing liquidity LO P3 Simon Company’s year-end balance sheets follow. At December 31 Current...

Exercise 13-7 Analyzing liquidity LO P3

Simon Company’s year-end balance sheets follow.

At December 31 Current Yr 1 Yr Ago 2 Yrs Ago
Assets
Cash $ 36,582 $ 41,922 $ 44,106
Accounts receivable, net 103,946 74,831 59,390
Merchandise inventory 134,613 97,914 63,889
Prepaid expenses 11,781 11,115 4,755
Plant assets, net 320,949 298,245 268,960
Total assets $ 607,871 $ 524,027 $ 441,100
Liabilities and Equity
Accounts payable $ 149,846 $ 90,332 $ 58,225
Long-term notes payable secured by
mortgages on plant assets		 115,423 120,526 96,508
Common stock, $10 par value 162,500 162,500 162,500
Retained earnings 180,102 150,669 123,867
Total liabilities and equity $ 607,871 $ 524,027 $ 441,100


(1-a) Compute the current ratio for each of the three years.
(1-b) Did the current ratio improve or worsen over the three year period?
(2-a) Compute the acid-test ratio for each of the three years.
(2-b) Did the acid-test ratio improve or worsen over the three year period?

Complete this question by entering your answers in the tabs below.

  • Required 1A
  • Required 1B
  • Required 2A
  • Required 2B

Compute the current ratio for each of the three years.
Current Ratio
Choose Numerator: / Choose Denominator: = Current Ratio
/ = Current ratio
Current Yr: / = to 1
1 Yr Ago: / = to 1
2 Yrs Ago: / = to 1
  • Required 1A
  • Required 1B
  • Required 2A
  • Required 2B

  • Did the current ratio improve or worsen over the three year period?
    Current ratio

  • Compute the acid-test ratio for each of the three years.
    Acid-test ratio
    Choose Numerator: / Choose Denominator: = Acid-Test Ratio
    + + / = Acid-test ratio
    Current Yr: + + / = to 1
    1 Yr Ago: + + / = to 1
    2 Yrs Ago: + + / = to 1

Solutions

Expert Solution

Answer :

1 a. Current ratio :

Current asset = Cash + Accounts receivable + Merchandise inventory + Prepaid expenses

Current liability = Accounts payable

Numerator / Denominator = Current Ratio
Current assets / Current liabilty
Current Yr 286,922 / 149,846 = 1.91 to 1
1 Yr Ago 225,782 / 90,332 = 2.50 to 1
2 Yrs Ago 172,140 / 58,225 = 2.96 to 1

1.b Over the three years the current ratio has worsen, starting from 2 Yrs Ago it was 2.96 to 1 and at 1 Yr Ago it was to 2.50 to 1 and finally in current year it reached to 1.91 to 1.

2 a. Acid-Test Ratio :

Acid-Test Ratio = (Cash + Accounts receivable) / Current liability

Numerator / Denominator = Current Ratio
Cash + Accounts receivable / Current liabilty
Current Yr 140,528 / 149,846 = 0.94 to 1
1 Yr Ago 116,753 / 90,332 = 1.29 to 1
2 Yrs Ago 103,496 / 58,225 = 1.78 to 1

2.b Over the three years the Acid-Test Ratio has worsen this means that company has started losing its liquidity over the years.,starting from 2 Yrs Ago it was 1.78 to 1and at 1 Yr Ago it was to 1.29 to 1 and finally in current year it reached to 0.94 to 1.

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

Exercise 13-7 Analyzing liquidity LO P3 Simon Company’s year-end balance sheets follow. At December 31 Current...
Exercise 13-7 Analyzing liquidity LO P3 Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 31,563 $ 37,632 $ 38,432 Accounts receivable, net 91,480 64,565 51,755 Merchandise inventory 118,469 87,025 53,471 Prepaid expenses 10,266 9,491 4,227 Plant assets, net 283,193 262,469 240,315 Total assets $ 534,971 $ 461,182 $ 388,200 Liabilities and Equity Accounts payable $ 130,544 $ 78,719 $ 52,267 Long-term notes payable secured by mortgages on plant...
Exercise 13-11 Profitability analysis LO P3 Simon Company’s year-end balance sheets follow. At December 31 2017...
Exercise 13-11 Profitability analysis LO P3 Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,000 $ 34,200 $ 37,500 Accounts receivable, net 89,100 62,700 51,600 Merchandise inventory 42,392 83,300 59,500 Prepaid expenses 11,004 9,960 4,192 Plant assets, net 411,504 274,840 217,208 Total assets $ 585,000 $ 465,000 $ 370,000 Liabilities and Equity Accounts payable $ 148,578 $ 76,227 $ 48,352 Long-term notes payable secured by mortgages on plant assets 108,880 105,880 83,405 Common...
Exercise 13-6 Common-size percents LO P2 Simon Company's year-end balance sheets follow. At December 31 Current...
Exercise 13-6 Common-size percents LO P2 Simon Company's year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 29,670 $ 34,681 $ 37,989 Accounts receivable, net 86,861 60,079 50,155 Merchandise inventory 105,935 81,821 53,955 Prepaid expenses 9,748 9,472 4,262 Plant assets, net 275,747 251,844 229,839 Total assets $ 507,961 $ 437,897 $ 376,200 Liabilities and Equity Accounts payable $ 130,277 $ 72,525 $ 48,169 Long-term notes payable secured by mortgages on plant...
Exercise 17-6 Common-size percents LO P2 Simon Company's year-end balance sheets follow. At December 31 Current...
Exercise 17-6 Common-size percents LO P2 Simon Company's year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 35,402 $ 40,967 $ 41,017 Accounts receivable, net 102,605 73,866 55,794 Merchandise inventory 127,716 97,608 60,616 Prepaid expenses 11,287 11,080 4,511 Plant assets, net 323,019 293,745 256,562 Total assets $ 600,029 $ 517,266 $ 418,500 Liabilities and Equity Accounts payable $ 153,889 $ 89,166 $ 55,242 Long-term notes payable secured by mortgages on plant...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 31,800 $ 35,625 $ 37,800 Accounts receivable, net 89,500 62,500 50,200 Merchandise inventory 112,500 82,500 54,000 Prepaid expenses 10,700 9,375 5,000 Plant assets, net 278,500 255,000 230,500 Total assets $ 523,000 $ 445,000 $ 377,500 Liabilities and Equity Accounts payable $ 129,900 $ 75,250 $ 51,250 Long-term notes payable secured by mortgages on plant assets 98,500 101,500 83,500 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 26,088 $ 30,494 $ 31,765 Accounts receivable, net 89,100 62,800 50,100 Merchandise inventory 112,500 84,500 53,000 Prepaid expenses 8,401 8,005 3,529 Plant assets, net 210,547 199,232 185,706 Total assets $ 446,636 $ 385,031 $ 324,100 Liabilities and Equity Accounts payable $ 110,100 $ 64,420 $ 42,353 Long-term notes payable secured by mortgages on plant assets 83,128 87,672 70,910 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 28,075 $ 31,842 $ 32,206 Accounts receivable, net 79,758 57,430 42,941 Merchandise inventory 98,255 75,138 46,195 Prepaid expenses 9,131 8,273 3,687 Plant assets, net 255,915 233,467 203,571 Total assets $ 471,134 $ 406,150 $ 328,600 Liabilities and Equity Accounts payable $ 114,966 $ 67,953 $ 44,243 Long-term notes payable secured by mortgages on plant assets 88,573 93,415 71,168 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 31,900 $ 34,900 $ 37,100 Accounts receivable, net 88,300 62,800 55,300 Merchandise inventory 75,102 84,700 54,400 Prepaid expenses 11,546 9,148 4,222 Plant assets, net 383,152 248,452 228,978 Total assets $ 590,000 $ 440,000 $ 380,000 Liabilities and Equity Accounts payable $ 142,503 $ 72,129 $ 49,157 Long-term notes payable secured by mortgages on plant assets 108,702 100,188 86,499 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 33,501 $ 39,160 $ 40,792 Accounts receivable, net 89,100 62,600 50,000 Merchandise inventory 113,500 83,500 59,000 Prepaid expenses 10,789 10,280 4,532 Plant assets, net 326,667 298,906 261,876 Total assets $ 573,557 $ 494,446 $ 416,200 Liabilities and Equity Accounts payable $ 141,388 $ 82,726 $ 54,389 Long-term notes payable secured by mortgages on plant assets 106,750 112,585 91,060 Common stock,...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs...
Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 33,341 $ 37,062 $ 40,584 Accounts receivable, net 93,789 68,870 53,587 Merchandise inventory 119,113 90,123 55,951 Prepaid expenses 10,737 9,929 4,466 Plant assets, net 297,036 271,616 243,412 Total assets $ 554,016 $ 477,600 $ 398,000 Liabilities and Equity Accounts payable $ 137,950 $ 83,136 $ 51,485 Long-term notes payable secured by mortgages on plant assets 104,155 107,651 87,078 Common stock,...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT