Question

In: Accounting

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 $ 29,554 $ 34,899 $ 37,080
Accounts receivable, net 87,405 62,306 48,470
Merchandise inventory 113,192 83,964 53,185
Prepaid expenses 9,420 9,439 3,958
Plant assets, net 271,571 250,032 224,507
Total assets $ 511,142 $ 440,640 $ 367,200
Liabilities and Equity
Accounts payable $ 131,093 $ 75,213 $ 49,440
Long-term notes payable secured by
mortgages on plant assets
96,095 104,388 80,340
Common stock, $10 par value 162,500 162,500 162,500
Retained earnings 121,454 98,539 74,920
Total liabilities and equity $ 511,142 $ 440,640 $ 367,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 Ratio
Choose Numerator: / Choose Denominator: = Current Ratio
Current assets / Current liabilities = Current ratio
Current Yr 239571 / 131093 = 1.83 to 1
1 Yr Ago 190608 / 75213 = 2.53 to 1
2 Yrs Ago 142693 / 49440 = 2.89 to 1
1b
Current ratio worsen over the three year period
2a
Acid-Test Ratio
Choose Numerator: / Choose Denominator: = Acid-Test Ratio
Cash + Short-term investments + Current receivables / Current liabilities = Acid-test ratio
Current Yr 29554 + 0 + 87405 / 131093 = 0.89 to 1
1 Yr Ago 34899 + 0 + 62306 / 75213 = 1.29 to 1
2 Yrs Ago 37080 + 0 + 48470 / 49440 = 1.73 to 1
2b
Acid-test ratio worsen over the three year period
Workings:
Current Yr 1 Yr Ago 2 Yrs Ago
Cash 29554 34899 37080
Accounts Receivable 87405 62306 48470
Merchandise Inventory 113192 83964 53185
Prepaid expenses 9420 9439 3958
Current assets 239571 190608 142693

Related Solutions

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,...
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,469 $ 39,122 $ 41,164 Accounts receivable, net 97,984 71,230 54,337 Merchandise inventory 119,500 92,298 60,815 Prepaid expenses 11,214 10,270 4,437 Plant assets, net 310,838 281,050 255,047 Total assets $ 573,005 $ 493,970 $ 415,800 Liabilities and Equity Accounts payable $ 138,398 $ 85,151 $ 56,532 Long-term notes payable secured by mortgages on plant assets 106,648 115,885 89,135 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 $ 35,940 $ 42,011 $ 43,761 Accounts receivable, net 89,000 62,600 51,100 Merchandise inventory 110,000 83,500 57,000 Prepaid expenses 11,574 11,028 4,862 Plant assets, net 368,799 331,303 289,777 Total assets $ 615,313 $ 530,442 $ 446,500 Liabilities and Equity Accounts payable $ 151,681 $ 88,748 $ 58,349 Long-term notes payable secured by mortgages on plant assets 114,522 120,782 97,690 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 $ 35,149 $ 41,501 $ 43,226 Accounts receivable, net 102,901 72,626 57,634 Merchandise inventory 126,791 93,091 60,159 Prepaid expenses 11,548 10,894 4,755 Plant assets, net 325,373 300,648 266,526 Total assets $ 601,762 $ 518,760 $ 432,300 Liabilities and Equity Accounts payable $ 148,340 $ 86,794 $ 55,922 Long-term notes payable secured by mortgages on plant assets 113,131 122,894 97,449 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 $ 35,340 $ 39,304 $ 41,359 Accounts receivable, net 101,431 69,483 53,004 Merchandise inventory 125,030 90,890 56,443 Prepaid expenses 10,828 10,738 4,506 Plant assets, net 308,905 290,907 250,288 Total assets $ 581,534 $ 501,322 $ 405,600 Liabilities and Equity Accounts payable $ 143,354 $ 85,571 $ 53,004 Long-term notes payable secured by mortgages on plant assets 110,422 118,763 87,845 Common stock,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT