Question

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,724 $ 43,360 $ 44,273
Accounts receivable, net 106,437 73,604 60,801
Merchandise inventory 132,473 99,268 63,502
Prepaid expenses 12,304 11,610 5,018
Plant assets, net 340,789 314,164 273,606
Total assets $ 628,727 $ 542,006 $ 447,200
Liabilities and Equity
Accounts payable $ 151,856 $ 91,599 $ 58,440
Long-term notes payable secured by
mortgages on plant assets
115,837 124,661 98,831
Common stock, $10 par value 163,500 163,500 163,500
Retained earnings 197,534 162,246 126,429
Total liabilities and equity $ 628,727 $ 542,006 $ 447,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?

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
3. Change in merchandise inventory

Homework Answers

Answer #1

Solution

Simon Company
Common Size Comparative balance Sheet
december 31st , 2015-2017
Current year 1 Year ago 2 Years ago
Assets
Cash 5.8% 8.0% 9.9%
Accounts Receivables , net 16.9% 13.6% 13.6%
Merchandise Inventory 21.1% 18.3% 14.2%
Prepaid Expenses 2.0% 2.1% 1.1%
Plant Assets ,Net 54.2% 58.0% 61.2%
Total Assets 100.0% 100.0% 100.0%
Liabilities and Equity
Accounts Payable 24.2% 16.9% 13.1%
Long Term Notes Payable Secured by mortgage on palnt assets 18.4% 23.0% 22.1%
Common Stock $10 Par 26.0% 30.2% 36.6%
Retained Earnings 31.4% 29.9% 28.3%
Total Liabilities and Equity 100.0% 100.0% 100.0%

.

Change in accounts receivable Favorable
Change in merchandise inventory Favorable

Both Inventory and accounts receivable are improved

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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,331 $ 34,285 $ 33,956 Accounts receivable, net 83,326 58,217 48,075 Merchandise inventory 105,825 76,144 49,207 Prepaid expenses 9,071 9,089 3,890 Plant assets, net 264,658 246,585 218,472 Total assets $ 492,211 $ 424,320 $ 353,600 Liabilities and Equity Accounts payable $ 120,109 $ 69,559 $ 47,142 Long-term notes payable secured by mortgages on plant assets 90,685 98,570 78,927 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 $ 38,250 $ 43,408 $ 43,896 Accounts receivable, net 106,555 76,724 56,789 Merchandise inventory 135,326 101,386 62,961 Prepaid expenses 11,959 11,737 4,926 Plant assets, net 337,331 309,349 270,428 Total assets $ 629,421 $ 542,604 $ 439,000 Liabilities and Equity Accounts payable $ 161,428 $ 91,700 $ 57,369 Long-term notes payable secured by mortgages on plant assets 119,514 123,551 98,959 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 $ 31,253 $ 35,468 $ 35,156 Accounts receivable, net 87,943 60,828 46,401 Merchandise inventory 109,466 80,380 49,407 Prepaid expenses 10,065 9,031 3,867 Plant assets, net 275,562 257,646 223,869 Total assets $ 514,289 $ 443,353 $ 358,700 Liabilities and Equity Accounts payable $ 129,339 $ 74,177 $ 46,875 Long-term notes payable secured by mortgages on plant assets 95,719 105,030 78,480 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 $ 29,888 $ 33,889 $ 37,120 Accounts receivable, net 86,626 61,751 47,553 Merchandise inventory 108,915 83,215 52,721 Prepaid expenses 9,914 8,896 3,963 Plant assets, net 271,239 248,958 226,243 Total assets $ 506,582 $ 436,709 $ 367,600 Liabilities and Equity Accounts payable $ 123,616 $ 73,804 $ 48,523 Long-term notes payable secured by mortgages on plant assets 97,142 97,430 81,240 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,400 $ 36,250 $ 38,200 Accounts receivable, net 86,700 63,000 50,000 Merchandise inventory 110,000 81,800 53,500 Prepaid expenses 10,750 9,300 4,500 Plant assets, net 277,000 248,500 230,000 Total assets $ 514,850 $ 438,850 $ 376,200 Liabilities and Equity Accounts payable $ 129,600 $ 75,750 $ 51,200 Long-term notes payable secured by mortgages on plant assets 97,500 101,250 83,800 Common stock,...
Simon Company's year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,484...
Simon Company's year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,484 $ 36,802 $ 38,366 Accounts receivable, net 87,707 62,528 51,155 Merchandise inventory 113,616 82,626 55,575 Prepaid expenses 9,647 9,379 4,136 Plant assets, net 275,633 255,292 234,468 Total assets $ 518,087 $ 446,627 $ 383,700 Liabilities and Equity Accounts payable $ 126,424 $ 75,480 $ 49,129 Long-term notes payable secured by mortgages on plant assets 98,374 105,806 86,494 Common stock, $10 par value 163,500 163,500...
Simon Company's year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 27,791...
Simon Company's year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 27,791 $ 31,529 $ 33,175 Accounts receivable, net 77,388 55,177 43,349 Merchandise inventory 96,307 72,912 46,633 Prepaid expenses 9,037 8,611 3,612 Plant assets, net 251,272 229,870 208,331 Total assets $ 461,795 $ 398,099 $ 335,100 Liabilities and Equity Accounts payable $ 116,137 $ 66,606 $ 44,676 Long-term notes payable secured by mortgages on plant assets 85,949 93,394 75,538 Common stock, $10 par value 163,500 163,500...
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,049 $ 40,969 $ 41,831 Accounts receivable, net 103,593 70,985 57,464 Merchandise inventory 123,926 93,802 61,818 Prepaid expenses 11,175 10,541 4,648 Plant assets, net 314,421 290,741 261,039 Total assets $ 588,164 $ 507,038 $ 426,800 Liabilities and Equity Accounts payable $ 146,453 $ 86,546 $ 55,211 Long-term notes payable secured by mortgages on plant assets 111,681 116,619 96,209 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 $ 24,733 $ 29,206 $ 31,031 Accounts receivable, net 72,416 52,143 39,752 Merchandise inventory 91,049 68,221 42,764 Prepaid expenses 8,046 7,667 3,346 Plant assets, net 231,518 211,523 190,407 Total assets $ 427,762 $ 368,760 $ 307,300 Liabilities and Equity Accounts payable $ 105,448 $ 62,944 $ 40,564 Long-term notes payable secured by mortgages on plant assets 78,007 86,511 69,272 Common stock,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT