Question

At December 31 2017 2016 2015 Assets Cash $ 33,338 $ 40,138 $38,236 Accounts receivable, net Merchandise inventory Prepaid ex
(1) Debt and equity ratios. Debt Ratio Choose Numerator: Choose Denominator: Debt Ratio / Debt ratio 2017: % 2016: % Equity R
(2) Debt-to-equity ratio. Debt-To-Equity Ratio Choose Numerator IChoose Denominator: Debt-To-Equity Ratio Debt-to-equity rati
(3) Times interest earned Times Interest Earned Choose Numerator: Choose Denominator: Times Interest Earned Times interest ea
0 0
Add a comment Improve this question Transcribed image text
Answer #1

(1) The formula for Debt ratio is:

Debt Ratio = Total liabilities / Total assets

For 2016:

Total liabilities = Accounts payable + Long term notes payable

Total liabilities = $82321 + $112035 = $194356

Total assets = $487108

Now, putting these values in the above formula, we get,

Debt ratio = $194356 / $487108 = 39.9%

For 2017:

Total liabilities = Accounts payable + Long term notes payable

Total liabilities = $140696 + $109415 = $250111

Total assets = $565045

Now, putting these values in the above formula, we get,

Debt ratio = $250111 / $565045 = 44.26%

The formula for Equity ratio is:

Equity Ratio = Total equity / Total assets

For 2016:

Total equity = Common stock + Retained earnings

Total equity = $162500 + $130252 = $292752

Total assets = $487108

Now, putting these values in the above formula, we get,

Equity ratio = $292752 / $487108 = 60.10%

For 2017:

Total equity = Common stock + Retained earnings

Total equity = $162500 + $152434 = $314934

Total assets = $565045

Now, putting these values in the above formula, we get,

Equity ratio = $314934 / $565045 = 55.74%

2. The formula for Debt to equity ratio is:

Debt to equity ratio = Total liabilities / Shareholder's equity

For 2016:

Total liabilities = Accounts payable + Long term notes payable

Total liabilities = $82321 + $112035 = $194356

Total equity = Common stock + Retained earnings

Total equity = $162500 + $130252 = $292752

Now, putting these values in the above formula, we get,

Debt- equity ratio = $194356 / $292752 = 0.6638

For 2017:

Total liabilities = Accounts payable + Long term notes payable

Total liabilities = $140696 + $109415 = $250111

Total equity = Common stock + Retained earnings

Total equity = $162500 + $152434 = $314934

Now, putting these values in the above formula, we get,

Debt-to equity ratio = $250111 / $314934 = 0.7941

3. Formula for times interest earned ratio is:

Times interest earned ratio = Income before interest and taxes / Interest expense

This can be further analysed as per below:

Times interest earned ratio = Net income + interest expense + income taxes / Interest expense

For 2016:

Net income = $34200, Income taxes = $8695, Interest expense = $13332

Times interest earned ratio = ($34200 + $8695 + $13332) / $13332

Times interest earned ratio = $56227 / $13332 = 4.21 times

For 2017:

Net income = $36728, Income taxes = $9549, Interest expense = $12488

Times interest earned ratio = ($36728 + $9549 + $12488) / $12488

Times interest earned ratio = $58765 / $12488 = 4.70 times

Add a comment
Know the answer?
Add Answer to:
At December 31 2017 2016 2015 Assets Cash $ 33,338 $ 40,138 $38,236 Accounts receivable, net...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 36,335...

    Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 36,335 $ 42,472 $ 42,524 Accounts receivable, net 107,459 73,568 56,120 Merchandise inventory 139,163 102,226 60,994 Prepaid expenses 12,179 11,377 4,773 Plant assets, net 333,281 312,096 273,889 Total assets $ 628,417 $ 541,739 $ 438,300 Liabilities and Equity Accounts payable $ 159,605 $ 89,723 $ 59,013 Long-term notes payable secured by mortgages on plant assets 120,505 123,354 94,927 Common stock, $10 par value 162,500 162,500...

  • Simon Company's year-end balance sheets follow. 2017 2016 2015 At Assets Cash Accounts receivable, net Merchandise...

    Simon Company's year-end balance sheets follow. 2017 2016 2015 At Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets 31,178 $ 36,444 37,211 89,469 65,041 49,128 111,365 85,112 52,327 4,013 281,159 254, 691 225, 821 $523,211 $451,044 $ 368, 500 10,040 9,756 Liabilities and Equity Accounts payable Long-term notes payable secured by $127,674 78,513 $ 50,101 mortgages on plant assets Common stock, $10 par value Retained earnings Total liabilities and equity 95,413 101,665 83,882 162,500...

  • At December 31 2017 2016 2015 Assets Cash 31,200 34,700 63,200 37,000 54,500 88,000 26,956 10,950...

    At December 31 2017 2016 2015 Assets Cash 31,200 34,700 63,200 37,000 54,500 88,000 26,956 10,950 407,894 Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net 83,400 58,200 9,651 4,204 264,049 236,096 Total assets $565,000 $455,000 390,000 Liabilities and Equity Accounts payable Long-term notes payable secured by mortgages Common stock, $10 par value Retained earnings $ 51,995 $137,871 $ 78,433 plant assets 106,220 162,500 103,603 162,500 87,052 162,500 on 158,409 110,464 88,453 Total liabilities and equity $565,000 $455,000 390,000...

  • Simon Company's year-end balance sheets follow. 2017 2016 2015 At December 31 Assets Cash Accounts receivable,...

    Simon Company's year-end balance sheets follow. 2017 2016 2015 At December 31 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 value Retained earnings Total liabilities and equity $ 31,300 $ 34,400 89,400 64,000 77,174 85,000 10,950 10,185 356,176 291,415 $565,000 $485,000 $ 36,600 55,000 51,200 3,308 163,892 $ 310,000 $142,092 $ 81,965 $ 40,511 106,220 189,319...

  • Simon Company's year-end balance sheets follow. 2017 2016 2015 At December 31 Assets Cash Accounts receivable,...

    Simon Company's year-end balance sheets follow. 2017 2016 2015 At December 31 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 value Retained earnings Total liabilities and equity $ 26,1225 30,846 $ 34,119 79,574 53,981 44,167 97,135 70,612 47,513 8,498 8,261 3,791 240,461 225, 274 205,010 $ 451,799 $ 389,474 $ 334,600 $ 114,746 $ 65,821 $...

  • At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total...

    At December 31 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 27,311 31,601 33,587 44,782 101,53376,061 46,744 3,769 171 207,018 467,573 403,080 $335,900 78,356 55, 867 9,062 8,380 251,311231, 115,261 67,43945,226 mortgages on plant assets Conmon stock, $10 par value Retained earnings Total liabilities and equity 89,662 93,635 74,976 162,500 162,500 162,500 100,150 79,506 53,198 467,573 $ 403,080 $ 335,900 1. Compute the current...

  • Simon Company's year-end balance sheets follow. 2017 2016 2015 At December 31 Assets Cash Accounts receivable,...

    Simon Company's year-end balance sheets follow. 2017 2016 2015 At December 31 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 value Retained earnings Total liabilities and equity 28,539 $ 35,423 $ 35,115 86,127 59,584 47.289 106,144 79,53148,856 9,570 9,208 3,941 268, 299 246,150 219,499 $ 498,679 $ 429,896 $ 354,700 $ 125,413 $ 72,652 $ 46,820...

  • Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 27,904 $ 32...

    Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 27,904 $ 32,617 $ 34,676 Accounts receivable, net 89,700 62,600 59,700 Merchandise inventory 113,000 83,000 54,000 Prepaid expenses 8,986 8,562 3,853 Plant assets, net 247,981 233,541 208,871 Total assets $ 487,571 $ 420,320 $ 361,100 Liabilities and Equity Accounts payable $ 117,763 $ 68,903 $ 46,235 Long-term notes payable secured by mortgages on plant assets 88,913 93,773 77,409 Common stock, $10 par value 162,500 162,500...

  • Simon Company's year-end balance sheets follow. 2017 2016 2015 $ At December 31 Assets Cash Accounts...

    Simon Company's year-end balance sheets follow. 2017 2016 2015 $ At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Longtern notes payable secured by mortgages on plant assets Common stock, $10 par value Retained earnings Total liabilities and equity 28,5315 33,684 $ 33,705 81,039 57, 196 46, 315 180,851 78,665 50, 317 8,912 8,579 3,745 264,248 238,756 213,318 $ 483,581 $ 416,880 $ 347,400 $ 119,208 $...

  • Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,800...

    Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 31,800 $ 36,000 $ 37,200 Accounts receivable, net 88,100 62,000 50,500 Merchandise inventory 111,000 83,800 54,500 Prepaid expenses 10,300 9,350 4,600 Plant assets, net 280,000 257,000 235,000 Total assets $ 521,200 $ 448,150 $ 381,800 Liabilities and Equity Accounts payable $ 129,200 $ 75,250 $ 50,400 Long-term notes payable secured by mortgages on plant assets 98,000 100,000 82,600 Common stock, $10 par value 161,500 161,500...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT