Question

In: Accounting

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 assets
97,407 103,738 83,972
Common stock, $10 par value 163,500 163,500 163,500
Retained earnings 116,777 98,134 80,559
Total liabilities and equity $ 507,961 $ 437,897 $ 376,200


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?

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

  • Req 1
  • Req 2 and 3

Express the balance sheets in common-size percents. (Do not round intermediate calculations and round your final percentage answers to 1 decimal place.)

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 % % %

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

Show less

2. Change in accounts receivable
3. Change in merchandise inventory

Solutions

Expert Solution

Answer:

1.

Simon Company

Common-Size Comparative Balance Sheets

At December 31

Current Year

1 Year Ago*

2 Years Ago

Assets
Cash...............................................................

5.84%

7.92%

10.10%

Accounts receivable, net..................................

17.10

13.72

13.33

Merchandise inventory.....................................

20.85

18.68

14.34

Prepaid expenses............................................

1.92

2.16

1.13

Plant assets, net .............................................

54.29

57.52

61.10

Total assets ....................................................

100.0%

100.0%

100%

Liabilities and Equity

Accounts payable............................................

25.65%

16.56%

12.80%

Long-term notes payable secured by

mortgages on plant assets ..........................

19.18

23.70

22.33

Common stock, $10 par value..........................

32.18

37.34

43.46

Retained earnings ..........................................

22.99

22.40

21.41

Total liabilities and equity................................

100.0%

100.0%

100.0%

* Column does not equal 100.0 due to rounding.

2. Unfavorable.

The increase in accounts receivable as a percentage of total assets is an unfavorable development. Assuming sales have not increased, a higher balance in accounts receivable simply means more assets are tied up in an unproductive manner. Further, there is additional risk that these receivables may not be collected

3. Unfavorable.

The increase in merchandise inventory as a percentage of total assets is an unfavorable development. More inventory means more assets are tied up in an unproductive manner.


Related Solutions

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...
Exercise 17-6 Common-size percents LO P2 Simon Company's year-end balance sheets At December 31 2017 2016...
Exercise 17-6 Common-size percents LO P2 Simon Company's year-end balance sheets At December 31 2017 2016 2015 Assets Cash $36,867 $42,664 $44,006 Accounts receivable, net 110,059 75,415 57,512 Merchandise inventory 131,660 102,646 63,119 Prepaid expenses 12,229 11,652 4,890 Plant assets, net 334,056 306,305 270,573 Total assets $624,871 $538,682 $440,100 Liabilities and Equity Accounts payable $157,149 $89,217 $59,255 Long-term notes payable secured by mortgages on plant assets 119,825 125,136 100,180 Common stock, $10 par value 163,500 163,500 163,500 Retained earnings 184,397...
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-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...
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 $ 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,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT