Question

Exercise 13-9 Risk and capital structure analysis LO P3 [The following information applies to the questions...

Exercise 13-9 Risk and capital structure analysis LO P3

[The following information applies to the questions displayed below.]

Simon Company’s year-end balance sheets follow.

At December 31 2017 2016 2015
Assets
Cash $ 31,883 $ 36,172 $ 38,810
Accounts receivable, net 89,689 64,580 50,239
Merchandise inventory 116,184 85,338 52,964
Prepaid expenses 9,965 9,495 4,187
Plant assets, net

282,074

261,135 234,400
Total assets $ 529,795 $ 456,720 $ 380,600
Liabilities and Equity
Accounts payable $ 134,557 $ 77,958 $ 51,244
Long-term notes payable secured by
mortgages on plant assets
99,601 103,995 82,430
Common stock, $10 par value 162,500 162,500 162,500
Retained earnings 133,137 112,267 84,426
Total liabilities and equity $ 529,795 $ 456,720 $ 380,600


The company’s income statements for the years ended December 31, 2017 and 2016, follow.

For Year Ended December 31 2017 2016
Sales $ 688,734 $ 543,497
Cost of goods sold $ 420,128 $ 353,273
Other operating expenses 213,508 137,505
Interest expense 11,708 12,500
Income taxes 8,954 8,152
Total costs and expenses 654,298 511,430
Net income $ 34,436 $ 32,067
Earnings per share $ 2.12 $ 1.97


Calculate the company’s long-term risk and capital structure positions at the end of 2017 and 2016 by computing the following ratios.

(1) Debt and equity ratios.

Debt Ratio
Choose Numerator: / Choose Denominator: = Debt Ratio
/ = Debt ratio
2017: / = %
2016: / = %
Equity Ratio
Choose Numerator: / Choose Denominator: = Equity Ratio
/ = Equity ratio
2017: / = %
2016: / = %

(2) Debt-to-equity ratio.

Debt-To-Equity Ratio
Choose Numerator: / Choose Denominator: = Debt-To-Equity Ratio
/ = Debt-to-equity ratio
2017: / = 0 to 1
2016: / = 0 to 1

(3) Times interest earned.

Times Interest Earned
Choose Numerator: / Choose Denominator: = Times Interest Earned
/ = Times interest earned
2017: / = times
2016: / = times

Homework Answers

Answer #1

1)2017 Debt Ratio = Total Debt/Total Assets = (134557+99601)/529795=234158//529795 = 44.20%
2016 Debt Ratio = Total Debt/Total Assets = (77958+103955)/456720= 181913/456720 = 39.83%

2017 Equity Ratio = (Total assets - Total Debt)/Total assets = (529795 - 234158)/529795 =295637/529795 = 55.80%
2016 Equity Ratio = (Total assets - Total Debt)/Total assets = (456720 - 181913)/456720 =274807/456720 =60.17%

2) 2017 Debt Equity Ratio = 234158/295637 = 79.20%
2016 Debt Equity Ratio = 181913/274807 = 66.20%

3) Time Interest earned 2017 = EBIT/ Interest = (Sales - COGS - Operating expenses)/Interest =(688734-420128-213508)/11708 =55098/11708 = 4.71

Time Interest earned 2016 = EBIT/ Interest = (Sales - COGS - Operating expenses)/Interest =(543497-353273-137505)/12500 = 52719/12500 = 4.22


Please Discuss in case of Doubt

Best of Luck. God Bless
Please Rate Well



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
Required information Exercise 13-10 Efficiency and profitability analysis LO P3 [The following information applies to the...
Required information Exercise 13-10 Efficiency and profitability analysis LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 32,200 $ 35,000 $ 37,400 Accounts receivable, net 86,100 63,500 50,500 Merchandise inventory 112,000 82,400 53,500 Prepaid expenses 10,550 9,400 4,800 Plant assets, net 278,000 249,500 229,000 Total assets $ 518,850 $ 439,800 $ 375,200 Liabilities and Equity Accounts payable $ 128,400 $ 74,250 $ 50,400...
Exercise 17-10 Efficiency and profitability analysis LO P3 [The following information applies to the questions displayed...
Exercise 17-10 Efficiency and profitability analysis LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 32,000 $ 36,250 $ 37,600 Accounts receivable, net 89,400 61,500 51,000 Merchandise inventory 111,000 82,400 53,500 Prepaid expenses 10,700 9,200 5,300 Plant assets, net 280,000 250,500 228,000 Total assets $ 523,100 $ 439,850 $ 375,400 Liabilities and Equity Accounts payable $ 128,000 $ 73,500 $ 51,600 Long-term notes...
Exercise 13-9 Analyzing risk and capital structure LO P3 [The following information applies to the questions...
Exercise 13-9 Analyzing risk and capital structure LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 25,531 $ 29,548 $ 30,164 Accounts receivable, net 73,997 53,260 41,449 Merchandise inventory 93,037 68,330 43,265 Prepaid expenses 8,385 7,911 3,420 Plant assets, net 227,495 210,300 192,602 Total assets $ 428,445 $ 369,349 $ 310,900 Liabilities and Equity Accounts payable $ 103,482...
Required information Exercise 13-9 Analyzing risk and capital structure LO P3 [The following information applies to...
Required information Exercise 13-9 Analyzing risk and capital structure LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash 36,194 43,603 43,630 Accounts receivable, net 103,832 76,305 58,767 Merchandise inventory 137,278 100,832 65,135 Prepaid expenses 11,656 11,332 4,897 Plant assets, net 337,022 307,568 277,271 Total assets 625,982 539,640 449,700 Liabilities and Equity Accounts payable 158,987 89,375 57,580 Long-term notes payable...
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,200 $ 34,000 $ 36,300 Accounts receivable, net 89,800 62,100 58,800 Merchandise inventory 88,271 84,200 51,400 Prepaid expenses 10,746 10,491 4,247 Plant assets, net 339,983 294,209 239,253 Total assets $ 560,000 $ 485,000 $ 390,000 Liabilities and Equity Accounts payable $ 136,651 $ 80,326 $ 50,450 Long-term notes payable secured by mortgages on plant assets 102,122 110,434 83,604 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 $ 29,388 $ 34,706 $ 37,252 Accounts receivable, net 89,566 61,975 47,721 Merchandise inventory 109,300 80,258 52,908 Prepaid expenses 9,952 9,389 4,058 Plant assets, net 275,303 256,352 226,961 Total assets $ 513,509 $ 442,680 $ 368,900 Liabilities and Equity Accounts payable $ 126,585 $ 77,057 $ 47,234 Long-term notes payable secured by mortgages on plant assets 94,609 104,871 79,896 Common stock,...
Problem 17-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation...
Problem 17-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $56,900; total assets, $249,400; common stock, $81,000; and retained earnings, $51,308.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 453,600 Cost of goods sold 298,350 Gross profit 155,250 Operating expenses 99,000 Interest expense 4,100 Income before taxes 52,150 Income taxes 21,008 Net income $...
Required information Exercise 13-8 Analyzing and interpreting liquidity LO P3 [The following information applies to the...
Required information Exercise 13-8 Analyzing and interpreting liquidity LO P3 [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash 29,829 34,868 35,252 Accounts receivable, net 89,500 62,300 51,100 Merchandise inventory 113,000 84,000 56,000 Prepaid expenses 9,606 9,153 3,917 Plant assets, net 253,731 236,977 202,831 Total assets 495,666 427,298 349,100 Liabilities and Equity Accounts payable 125,889 73,658 47,003 Long-term notes payable secured...
Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 32,096...
Simon Company’s year-end balance sheets follow. At December 31 2017 2016 2015 Assets Cash $ 32,096 $ 37,517 $ 38,306 Accounts receivable, net 89,700 62,100 54,700 Merchandise inventory 115,000 83,500 54,000 Prepaid expenses 10,336 9,848 4,256 Plant assets, net 291,476 271,352 231,838 Total assets $ 538,608 $ 464,317 $ 383,100 Liabilities and Equity Accounts payable $ 135,455 $ 79,254 $ 51,075 Long-term notes payable secured by mortgages on plant assets 102,271 107,861 85,512 Common stock, $10 par value 162,500 162,500...
[The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At...
[The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 29,123 $ 34,042 $ 35,105 Accounts receivable, net 89,200 62,300 50,700 Merchandise inventory 110,500 83,500 59,000 Prepaid expenses 9,378 8,936 3,901 Plant assets, net 255,402 236,742 205,894 Total assets $ 493,603 $ 425,520 $ 354,600 Liabilities and Equity Accounts payable $ 122,907 $ 71,913 $ 46,807 Long-term notes payable secured by...