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 $ 35,375 $ 41,772 $ 43,086
Accounts receivable, net 105,666 72,362 55,741
Merchandise inventory 130,224 99,525 59,964
Prepaid expenses 11,624 11,076 4,645
Plant assets, net 328,921 302,687 267,464
Total assets $ 611,810 $ 527,422 $ 430,900
Liabilities and Equity
Accounts payable $ 156,911 $ 90,026 $ 57,448
Long-term notes payable secured by
mortgages on plant assets
115,020 122,520 96,181
Common stock, $10 par value 163,500 163,500 163,500
Retained earnings 176,379 151,376 113,771
Total liabilities and equity $ 611,810 $ 527,422 $ 430,900

REQUIRED:
1. Express the balance sheets in common-size percents. (Do not round intermediate calculations and round your final percentage answers to 1 decimal place.)
2. Assuming annual sales have not changed in the last three years, is the change in accounts receivable as a percentage of total assets favorable or unfavorable?
3. Assuming annual sales have not changed in the last three years, is the change in merchandise inventory as a percentage of total assets favorable or unfavorable?

SIMON COMPANY
Common-Size Comparative Balance Sheets
December 31
Current Year 1 Year Ago 2 Years Ago
Assets
Cash % % %
Accounts receivable, net
Merchandise inventory
Prepaid expenses
Plant assets, net
Total assets % % %
Liabilities and Equity
Accounts payable % % %
Long-term notes payable secured by mortgages on plant assets
Common stock, $10 par
Retained earnings
Total liabilities and equity % % %

2.Change in accounts receivable: favorable development or unfavorable development?
3.Change in merchandise inventory: favorable development or unfavorable development?

Solutions

Expert Solution

Answer-1)-

SIMON COMPANY
BALANCE SHEET DATA IN TREND PERCENTS
FOR YEARS ENDED DECEMBER 31
PARTICULARS Current Yr % 1 Yr Ago % 2 Yrs Ago %
$ $ $
ASSETS
Cash 35375 5.8 41772 7.9 43086 10.0
Accounts receivable, net 105666 17.3 72362 13.7 55741 12.9
Merchandise inventory 130224 21.3 99525 18.9 59964 13.9
Prepaid expenses 11624 1.9 11076 2.1 4645 1.1
Plant assets,net 328921 53.8 302687 57.4 267464 62.1
Total assets 611810 100.0 527422 100.0 430900 100.0
Liabilities & Equity
Accounts payable 156911 25.65 90026 17.07 57448 13.33
Long-term notes payable by mortgages on plant assets 115020 18.80 122520 23.23 96181 22.32
Common stock, $10 par value 163500 26.72 163500 31.00 163500 37.94
Retained earnings 176379 28.83 151376 28.70 113771 26.40
Total liabilities & equity 611810 100.00 527422 100.00 430900 100.00

2)- Change in accounts receivable= Unfavorable development.

3)- Change in merchandise inventory = Unfavorable development.


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 $ 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,...
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 $ 36,630 $ 41,533 $ 43,718 Accounts receivable, net 107,228 74,181 58,874 Merchandise inventory 130,814 100,006 60,826 Prepaid expenses 12,150 11,352 4,712 Plant assets, net 334,032 308,147 273,470 Total assets $ 620,854 $ 535,219 $ 441,600 Liabilities and Equity Accounts payable $ 151,501 $ 90,452 $ 57,125 Long-term notes payable secured by mortgages on plant assets 113,219 120,638 99,545 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 $ 36,631 $ 42,399 $ 43,291 Accounts receivable, net 105,128 72,729 57,138 Merchandise inventory 130,870 98,048 63,976 Prepaid expenses 11,681 11,240 4,810 Plant assets, net 324,388 300,324 272,485 Total assets $ 608,698 $ 524,740 $ 441,700 Liabilities and Equity Accounts payable $ 147,019 $ 91,341 $ 57,138 Long-term notes payable secured by mortgages on plant assets 116,724 124,311 100,544 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 $ 34,326 $ 40,943 $ 42,223 Accounts receivable, net 101,519 72,367 55,160 Merchandise inventory 125,088 96,575 62,397 Prepaid expenses 11,505 10,640 4,644 Plant assets, net 321,238 291,265 266,376 Total assets $ 593,676 $ 511,790 $ 430,800 Liabilities and Equity Accounts payable $ 149,304 $ 85,628 $ 57,434 Long-term notes payable secured by mortgages on plant assets 109,379 115,357 94,255 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 $ 30,940 $ 37,251 $ 36,927 Accounts receivable, net 91,467 62,025 48,251 Merchandise inventory 110,493 85,307 54,555 Prepaid expenses 9,764 9,399 4,103 Plant assets, net 281,744 258,094 229,164 Total assets $ 524,408 $ 452,076 $ 373,000 Liabilities and Equity Accounts payable $ 131,883 $ 76,401 $ 50,221 Long-term notes payable secured by mortgages on plant assets 100,560 106,057 81,609 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,077 $ 36,326 $ 35,635 Accounts receivable, net 88,304 62,324 48,968 Merchandise inventory 109,915 83,180 53,200 Prepaid expenses 10,008 9,629 4,000 Plant assets, net 277,091 253,709 225,497 Total assets $ 516,395 $ 445,168 $ 367,300 Liabilities and Equity Accounts payable $ 128,582 $ 76,738 $ 47,514 Long-term notes payable secured by mortgages on plant assets 96,111 105,460 80,362 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,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,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT