Solvency and Profitability Trend Analysis Addai Company has provided the following comparative information: 20Y8 20Y7 20Y6 20Y5 20Y4 Net income $273,406 $367,976 $631,176 $884,000 $800,000 Interest expense 616,047 572,003 528,165 495,000 440,000 Income tax expense 31,749 53,560 106,720 160,000 200,000 Total assets (ending balance) 4,417,178 4,124,350 3,732,443 3,338,500 2,750,000 Total stockholders’ equity (ending balance) 3,706,557 3,433,152 3,065,176 2,434,000 1,550,000 Average total assets 4,270,764 3,928,396 3,535,472 3,044,250 2,475,000 Average total stockholders' equity 3,569,855 3,249,164 2,749,588 1,992,000 1,150,000 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 28% Return on stockholders’ equity 18% Times interest earned 2.7 Ratio of liabilities to stockholders’ equity 0.4 Required: 1. Determine the following for the years 20Y4 through 20Y8 for each of the graphs below. Use the amounts given above in your calculations. Round to one decimal place: a. Return on total assets: 20Y8 fill in the blank 1 % 20Y7 fill in the blank 2 % 20Y6 fill in the blank 3 % 20Y5 fill in the blank 4 % 20Y4 fill in the blank 5 % b. Return on stockholders' equity: 20Y8 fill in the blank 6 % 20Y7 fill in the blank 7 % 20Y6 fill in the blank 8 % 20Y5 fill in the blank 9 % 20Y4 fill in the blank 10 % c. Times interest earned: 20Y8 fill in the blank 11 20Y7 fill in the blank 12 20Y6 fill in the blank 13 20Y5 fill in the blank 14 20Y4 fill in the blank 15 d. Ratio of liabilities to stockholders' equity: 20Y8 fill in the blank 16 20Y7 fill in the blank 17 20Y6 fill in the blank 18 20Y5 fill in the blank 19 20Y4 fill in the blank 20 2. Refer to the selected industry ratios provided above. Both the return on total assets and the return on stockholders' equity have been moving in a negative direction in the last five years. Both measures have moved below the industry average over the last two years. The cause of this decline is driven by a rapid decrease in earnings. The company's level of debt relative to stockholders' equity has gradually improved over the five years. However, the decrease in earnings along with high interest costs has caused the times interest earned ratio to fall below the industry average in recent years.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Solvency and Profitability Trend Analysis

Addai Company has provided the following comparative information:

      20Y8     20Y7     20Y6     20Y5     20Y4
Net income $273,406   $367,976   $631,176   $884,000   $800,000  
Interest expense 616,047   572,003   528,165   495,000   440,000  
Income tax expense 31,749   53,560   106,720   160,000   200,000  
Total assets (ending balance) 4,417,178   4,124,350   3,732,443   3,338,500   2,750,000  
Total stockholders’ equity (ending balance) 3,706,557   3,433,152   3,065,176   2,434,000   1,550,000  
Average total assets 4,270,764   3,928,396   3,535,472   3,044,250   2,475,000  
Average total stockholders' equity 3,569,855   3,249,164   2,749,588   1,992,000   1,150,000  

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 28%  
Return on stockholders’ equity 18%  
Times interest earned 2.7  
Ratio of liabilities to stockholders’ equity 0.4  

Required:

1.  Determine the following for the years 20Y4 through 20Y8 for each of the graphs below. Use the amounts given above in your calculations. Round to one decimal place:

a.  Return on total assets:

 

 

20Y8 fill in the blank 1 %
20Y7 fill in the blank 2 %
20Y6 fill in the blank 3 %
20Y5 fill in the blank 4 %
20Y4 fill in the blank 5 %

b.  Return on stockholders' equity:

 

 

20Y8 fill in the blank 6 %
20Y7 fill in the blank 7 %
20Y6 fill in the blank 8 %
20Y5 fill in the blank 9 %
20Y4 fill in the blank 10 %

c.  Times interest earned:

 

 

20Y8 fill in the blank 11
20Y7 fill in the blank 12
20Y6 fill in the blank 13
20Y5 fill in the blank 14
20Y4 fill in the blank 15

d.  Ratio of liabilities to stockholders' equity:

 

 

20Y8 fill in the blank 16
20Y7 fill in the blank 17
20Y6 fill in the blank 18
20Y5 fill in the blank 19
20Y4 fill in the blank 20

2.  Refer to the selected industry ratios provided above.

Both the return on total assets and the return on stockholders' equity have been moving in a negative  direction in the last five years. Both measures have moved below  the industry average over the last two years. The cause of this decline is driven by a rapid decrease  in earnings. The company's level of debt relative to stockholders' equity has gradually improved  over the five years. However, the decrease  in earnings along with high interest costs has caused the times interest earned ratio to fall below  the industry average in recent years.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
Income Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education