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,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, $10 par value 163,500 163,500 163,500
Retained earnings 176,791 145,572 115,429
Total liabilities and equity $ 601,762 $ 518,760 $ 432,300


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?

Solutions

Expert Solution

Ans. 1 SIMON   COMPANY
Common Size Comparative Balance Sheets
For three years
Current Year 1 Year Ago 2 Years Ago
Assets: Amount % Amount % Amount %
Cash $35,149 5.8% $41,501 8.0% $43,226 10.0%
Accounts receivables $102,901 17.1% $72,626 14.0% $57,634 13.3%
Merchandise inventory $126,791 21.1% $93,091 17.9% $60,159 13.9%
Prepaid expenses $11,548 1.9% $10,894 2.1% $4,755 1.1%
Plant assets, net $325,373 54.1% $300,648 58.0% $266,526 61.7%
Total assets $601,762 100.0% $518,760 100.0% $432,300 100.0%
Liabilities and Equity:
Accounts payable $148,340 24.7% $86,794 16.7% $55,922 12.9%
Long term notes payable secured $113,131 18.8% $122,894 23.7% $97,449 22.5%
by mortgage on plant assets
Common stock $163,500 27.2% $163,500 31.5% $163,500 37.8%
Retained earnings $176,791 29.4% $145,572 28.1% $115,429 26.7%
Total Liabilities and Equity $601,762 100.0% $518,760 100.0% $432,300 100.0%
*Calculations for Common Size Balance Sheet:
Amount is percentage from assets side =   Particular amount from assets side / Total assets * 100
Amount is percentage from liabilities side =   Particular amount from liability side / Total liabilities and owner's equity * 100
Ans. 2 Unfavorable
Increase in accounts receivable means business will get it's money in longer time.
If the money will be back in longer time then it will adversely impact the cash flow of business.
Ans. 3 Favorable
Increase in inventory is good for business.. If inventory increases then the gross profit & net profit also increases.

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