Question

Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 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, $10 par value 163,500 163,500 163,500 Retained earnings 131,100 104,750 79,250 Total liabilities and equity $ 523,000 $ 445,000 $ 377,500 Express the balance sheets in common-size percents. (Do not round intermediate calculations and round your final percentage answers to 1 decimal place.)

Answer 1

To express a balance sheet in common-size percents, divide each balance sheet item by the total assets for that year and multiply by 100 to get a percentage. This will be done for all items in the asset, liability, and equity sections for each year.

Step-by-step explanation:

The student is asking for help in expressing balance sheets in common-size percents. To do this, you must calculate each line item as a percentage of total assets for a given year. This process involves dividing the individual asset, liability, or equity figure by the total assets for each respective year.

Let's take the first item (Cash) for 2017. To find the common-size percent, you divide the cash balance by the total assets for 2017:

Cash 2017 Common-size Percent =
($31,800 / $523,000) × 100 = 6.08% (rounded to one decimal place)

This calculation is repeated for each line item across each year. We would then follow a similar process for Accounts Receivable, Inventory, Prepaid Expenses, Plant Assets, and for the liabilities and equity sections.

Answer 2

Step-by-step explanation:

Balance Sheet

//2017// % // 2016 // % // 2015 //%//

Cash

//$31,800// 6% // $35,625 // 8% // $37,800 //10%//

Accounts Receivable

//$89,500// 17% // $62,500 // 14% // $50,200 //13%//

Inventory

//$112,500// 22% // $82,500 // 19% // $54,000 //14%//

Prepaid Expenses

//$10,700// 2% // $9,375 // 2% // $5,000 //1%//

TOTAL CURRENT ASSETS

//$244,500// 47% // $190,000 // 43% // $147,000 //39%//

Plant Assets

//$ 278,500// 53% // $ 255,000 // 57% // $ 230,500 //61%//

TOTAL NON CURRENT ASSETS

//$278,500// 53% // $255,000 // 57% // $230,500 //61%//

TOTAL ASSETS

//$523,000// 100%// $445,000 // 100% //$377,500 //100%//

Accounts Payable

//$129,900// 57% // $75,250 // 43% // $51,250 // 38% //

TOTAL CURRENT LIABILITIES

//$129,900// 57% // $75,250 // 43% // $51,250 // 38% //

Long Term Notes Payable

//$98,500// 43% // $101,500 // 57% // $83,500 // 62% //

TOTAL NON CURRENT LIABILITIES

//$98,500// 43% // $101,500 // 57% // $83,500 // 62% //

TOTAL LIABILITIES

//$228,400// 100% // $176,750 // 100% //$134,750//100%//

Common Stock

/$163,500// 55% // $163,500 // 61% // $163,500 //67%//

Retained Earnings

//$131,100// 45% // $104,750 // 39% // $79,250 //33%//

TOTAL EQUITY

//$294,600// 100% //$268,250 //100%// $242,750 //100%//

TOTAL EQUITY + LIABILITIES

//$523,000// 100%// $445,000// 100%// $377,500// 100%//