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.
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)