(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
At December 31 2017 2016 2015 Assets Cash $ 33,338 $ 40,138 $38,236 Accounts receivable, net...
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 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 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, 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, 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 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, 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,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 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
$
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...