Question

In: Accounting

Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6...

  1. Solvency and Profitability Trend Analysis

    Addai Company has provided the following comparative information:

        20Y8     20Y7     20Y6     20Y5     20Y4
    Net income $1,309,100 $1,128,500 $948,300 $810,500 $686,900
    Interest expense 445,100 406,300 350,900 267,500 212,900
    Income tax expense 418,912 315,980 265,524 210,730 164,856
    Total assets (ending balance) 8,780,394 9,304,142 6,683,358 6,992,432 5,302,595
    Total stockholders' equity (ending balance) 2,750,166 3,352,864 2,138,620 2,687,334 1,612,400
    Average total assets 9,042,268 7,993,750 6,837,895 5,827,027 4,971,271
    Average stockholders' equity 3,051,515 2,745,742 2,412,977 2,149,867 1,892,287

    You have been asked to evaluate the historical performance of the company over the last five years.

    Selected industry ratios have remained relatively steady at the following levels for the last five years:

      20Y4―20Y8
    Return on total assets 19.1%
    Return on stockholders’ equity 39.7%
    Times interest earned 4.6
    Ratio of liabilities to stockholders' equity 2.1

    Required:

    1. Determine the following for the years 20Y4 through 20Y8. Round to one decimal place:

    a. Return on total assets:

    20Y8 %
    20Y7 %
    20Y6 %
    20Y5 %
    20Y4 %

    b. Return on stockholders’ equity:

    20Y8 %
    20Y7 %
    20Y6 %
    20Y5 %
    20Y4 %

    c. Times interest earned:

    20Y8
    20Y7
    20Y6
    20Y5
    20Y4

    d. Ratio of liabilities to stockholders' equity:

    20Y8
    20Y7
    20Y6
    20Y5
    20Y4

    2. Refer to the selected industry ratios provided above.

    Both the rate earned on total assets and the rate earned on stockholders' equity have been moving in a   direction in the last five years. Both measures have moved   the industry average over the last two years. The cause of this change is driven by a rapid   in earnings.

Solutions

Expert Solution

1.

    20Y8     20Y7     20Y6     20Y5     20Y4
Net income $           1,309,100 $           1,128,500 $               948,300 $               810,500 $               686,900
Interest expense $               445,100 $               406,300 $               350,900 $               267,500 $               212,900
Income tax expense $               418,912 $               315,980 $               265,524 $               210,730 $               164,856
Total assets (ending balance) $           8,780,394 $           9,304,142 $           6,683,358 $           6,992,432 $           5,302,595
Total stockholders' equity (ending balance) $           2,750,166 $           3,352,864 $           2,138,620 $           2,687,334 $           1,612,400
Average total assets $           9,042,268 $           7,993,750 $           6,837,895 $           5,827,027 $           4,971,271
Average stockholders' equity $           3,051,515 $           2,745,742 $           2,412,977 $           2,149,867 $           1,892,287
Income from Operations $           2,173,112 $           1,850,780 $           1,564,724 $           1,288,730 $           1,064,656
Total Liabilities $           6,030,228 $           5,951,278 $           4,544,738 $           4,305,098 $           3,690,195
a Return on Total Assets 14.5% 14.1% 13.9% 13.9% 13.8%
b Return on Stockholder's Equity 42.9% 41.1% 39.3% 37.7% 36.3%
c Times interest earned 4.9 4.6 4.5 4.8 5.0
d Ratio of liabilities to stockholders' equity 2.2 1.8 2.1 1.6 2.3

Return on Total Assets = Net Income / Average total assets
Return on Stockholder's Equity = Net Income / Average Stockholder's Equity
Times Interest Earned = Income from Operations / Interest Expense
Ratio of liabilities to stockholder's equity = Total Liabilities / Total Stockholder's Equity

2.
Both the rate earned on total assets and the rate earned on stockholders' equity have been moving in a upward direction in the last five years. Both measures have moved above / more than the industry average over the last two years. The cause of this change is driven by a rapid grwoth / increase in earnings.

If you have any query, kindly comment with your query and please mark thumbs up


Related Solutions

Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6...
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6     20Y5     20Y4 Net income $1,014,300 $874,400 $734,800 $628,000 $532,200 Interest expense 344,900 314,800 271,900 207,200 165,000 Income tax expense 324,576 244,832 205,744 163,280 127,728 Total assets (ending balance) 7,358,917 7,827,675 5,609,613 5,895,529 4,470,776 Total stockholders' equity (ending balance) 2,291,128 2,818,696 1,795,552 2,275,362 1,365,218 Average total assets 7,593,296 6,718,644 5,752,571 4,912,941 4,200,000 Average stockholders' equity 2,554,912 2,307,124 2,035,457 1,820,290 1,607,855 You have been asked to...
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6...
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6     20Y5     20Y4 Net income $1,014,300 $874,400 $734,800 $628,000 $532,200 Interest expense 344,900 314,800 271,900 207,200 165,000 Income tax expense 324,576 244,832 205,744 163,280 127,728 Total assets (ending balance) 7,358,917 7,827,675 5,609,613 5,895,529 4,470,776 Total stockholders' equity (ending balance) 2,291,128 2,818,696 1,795,552 2,275,362 1,365,218 Average total assets 7,593,296 6,718,644 5,752,571 4,912,941 4,200,000 Average stockholders' equity 2,554,912 2,307,124 2,035,457 1,820,290 1,607,855 You have been asked to...
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6...
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6     20Y5     20Y4 Net income $1,014,300 $874,400 $734,800 $628,000 $532,200 Interest expense 344,900 314,800 271,900 207,200 165,000 Income tax expense 324,576 244,832 205,744 163,280 127,728 Total assets (ending balance) 7,358,917 7,827,675 5,609,613 5,895,529 4,470,776 Total stockholders' equity (ending balance) 2,291,128 2,818,696 1,795,552 2,275,362 1,365,218 Average total assets 7,593,296 6,718,644 5,752,571 4,912,941 4,200,000 Average stockholders' equity 2,554,912 2,307,124 2,035,457 1,820,290 1,607,855 You have been asked to...
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6...
Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6     20Y5     20Y4 Net income $1,359,400 $1,171,900 $984,800 $841,700 $713,300 Interest expense 462,200 421,900 364,400 277,800 221,100 Income tax expense 435,008 328,132 275,744 218,842 171,192 Total assets (ending balance) 8,599,073 9,086,363 6,539,127 6,819,289 5,171,294 Total stockholders' equity (ending balance) 2,724,567 3,303,815 2,109,119 2,636,905 1,582,143 Average total assets 8,842,718 7,812,745 6,679,208 5,682,741 4,841,451 Average stockholders' equity 3,014,191 2,706,467 2,373,012 2,109,524 1,852,727 You have been asked to...
Solvency and Profitability Trend Analysis Crosby Company has provided the following comparative information:     20Y8     20Y7     20Y6...
Solvency and Profitability Trend Analysis Crosby Company has provided the following comparative information:     20Y8     20Y7     20Y6     20Y5     20Y4 Net income $5,571,720 $3,714,480 $2,772,000 $1,848,000 $1,400,000 Interest expense 1,052,060 891,576 768,600 610,000 500,000 Income tax expense 1,225,572 845,222 640,320 441,600 320,000 Total assets (ending balance) 29,378,491 22,598,839 17,120,333 12,588,480 10,152,000 Total stockholders’ equity (ending balance) 18,706,200 13,134,480 9,420,000 6,648,000 4,800,000 Average total assets 25,988,665 19,859,586 14,854,406 11,370,240 8,676,000 Average total stockholders' equity 15,920,340 11,277,240 8,034,000 5,724,000 4,100,000 You have been asked...
Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6     20Y5     20Y4 Net income $1,221,100...
Addai Company has provided the following comparative information:     20Y8     20Y7     20Y6     20Y5     20Y4 Net income $1,221,100 $1,052,700 $884,600 $756,100 $640,800 Interest expense 415,200 379,000 327,300 249,500 198,600 Income tax expense 390,752 294,756 247,688 196,586 153,792 Total assets (ending balance) 7,835,104 8,286,078 5,959,694 6,220,206 4,716,990 Total stockholders' equity (ending balance) 2,472,953 3,002,831 1,916,327 2,398,795 1,439,277 Average total assets 8,060,591 7,122,886 6,089,950 5,183,505 4,417,895 Average stockholders' equity 2,737,892 2,459,579 2,157,561 1,919,036 1,686,316 You have been asked to evaluate the historical performance of...
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3...
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3     Year 2     Year 1 Net income $1,283,300 $1,106,300 $929,700 $794,600 $673,400 Interest expense 436,300 398,300 344,000 262,200 208,800 Income tax expense 410,656 309,764 260,316 206,596 161,616 Average total assets 7,676,786 6,777,477 5,789,545 4,915,349 4,181,043 Average stockholders' equity 2,629,713 2,353,830 2,056,858 1,822,477 1,595,735 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained...
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3...
Trend Analysis Critelli Company has provided the following comparative information:     Year 5     Year 4     Year 3     Year 2     Year 1 Net income $1,052,000 $906,900 $762,100 $651,400 $552,000 Interest expense 357,700 326,500 282,000 215,000 171,100 Income tax expense 336,640 253,932 213,388 169,364 132,480 Average total assets 6,350,000 5,606,364 4,789,450 4,067,606 3,459,809 Average stockholders' equity 2,169,072 1,941,970 1,697,327 1,504,388 1,317,422 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained...
Solvency Analysis The following information is available from the balance sheets at the ends of the...
Solvency Analysis The following information is available from the balance sheets at the ends of the two most recent years and the income statement for the most recent year of Impact Company: December 31 2017 2016 Accounts payable    $ 65,000    $ 50,000 Accrued liabilities    25,000    35,000 Taxes payable    60,000    45,000 Short-term notes payable    0    75,000 Bonds payable due within next year    200,000    200,000 Total current liabilities    $ 350,000   ...
Aritelli Company has provided the following comparative information:     Year 5     Year 4     Year 3     Year 2...
Aritelli Company has provided the following comparative information:     Year 5     Year 4     Year 3     Year 2     Year 1 Net income $1,035,300 $892,500 $750,000 $641,000 $543,200 Interest expense 352,000 321,300 277,500 211,500 168,400 Income tax expense 331,296 249,900 210,000 166,660 130,368 Average total assets 6,901,990 6,099,497 5,215,736 4,440,104 3,785,106 Average stockholders' equity 2,347,619 2,109,929 1,851,852 1,647,815 1,448,533 You have been asked to evaluate the historical performance of the company over the last five years. Selected industry ratios have remained relatively steady...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT