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 $ 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 assets
99,569 108,193 87,508
Common stock, $10 par value 162,500 162,500 162,500
Retained earnings 142,358 111,770 85,925
Total liabilities and equity $ 534,971 $ 461,182 $ 388,200


(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?

Solutions

Expert Solution

Current Yr 1 Yr Ago 2 Yrs Ago
(1-a) Current ratio 1.93 2.52 2.83
(Current Assets/Current Liabilities)
(1-b) improve
(1-c) Quick ratio 0.94 1.30 1.73
[(Current Assets - Inventory - Prepaid Exp)/Current Liabilities)]
(1-d) improve
Working
Current 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
      251,778       198,713       147,885
Current Liabilities
Accounts Payable       130,544         78,719         52,267

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 $ 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...
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
ADVERTISEMENT
ADVERTISEMENT