2. Analyze the following ratios (Good/Not good, Undervalued/Overvalued, or just OK) based on the given industry averages. Write the answers in the spaces provided. (7 items x 1 point)
- Complete the horizontal analysis below. Use the name of the company you belong to in your iLS Activity. Round off your answers to the nearest hundredths.
Name: Income Statement for the years ending December 31, 201X and December 31, 201Y |
||||
|
2015 |
2016 |
Annual Percentage Growth 2015-2016 |
|
Sales |
475,000 |
500,000 |
1. |
|
Cost of Goods Sold |
265,000 |
269,000 |
2. |
|
Gross Profit |
210,000 |
231,000 |
3. |
|
Wages |
154,000 |
163,000 |
4. |
|
Repairs |
5,800 |
4,150 |
5. |
|
Rent |
13,000 |
12,000 |
6. |
|
Taxes |
16,940 |
17,930 |
7. |
|
Office Expenses |
1,023 |
587 |
8. |
|
Total Expenses |
190,763 |
197,667 |
9. |
|
Net Income |
19,237 |
33,333 |
10. |
2. Analyze the following ratios (Good/Not good, Undervalued/Overvalued, or just OK) based on the given industry averages. Write the answers in the spaces provided. (7 items x 1 point)
Ratios |
Annual Data |
Industry Average |
Interpretation |
Current |
5.7 |
4 |
|
Days Sales Outstanding |
37 days |
42 days |
|
Total Debt to Total Capital |
47.80% |
32.60% |
|
Times-Interest Earned |
2.2 |
6 |
|
Profit Margin |
6.10% |
6.00% |
|
|
10.03% |
10.00% |
|
Enterprise Value to EBITDA |
0.87 |
1.12 |
|
3. Provide a decision for each analysis.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images