1. Using the financial statements above, prepare a common size income statement and balance sheet. 2. Using the financial statements above, prepare a trend analysis of the the income statement and balance sheet. 3. Using the financial statement above, find the following ratios for both 2017 and 2018. Current Ratio Quick Ratio Inventory Turnover Ratio Times Interest Earned Debt Ratio Equity Ratio Net Profit Margin Gross Profit Margin Fixed Asset Turnover Total Asset Turnover
1. Using the financial statements above, prepare a common size income statement and balance sheet. 2. Using the financial statements above, prepare a trend analysis of the the income statement and balance sheet. 3. Using the financial statement above, find the following ratios for both 2017 and 2018. Current Ratio Quick Ratio Inventory Turnover Ratio Times Interest Earned Debt Ratio Equity Ratio Net Profit Margin Gross Profit Margin Fixed Asset Turnover Total Asset Turnover
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
1. Using the financial statements above, prepare a common size income statement and
2. Using the financial statements above, prepare a trend analysis of the the income statement and balance sheet.
3. Using the financial statement above, find the following ratios for both 2017 and 2018.
Current Ratio - Quick Ratio
Inventory Turnover Ratio - Times Interest Earned
- Debt Ratio
- Equity Ratio
- Net Profit Margin
- Gross Profit Margin
- Fixed Asset Turnover
Total Asset Turnover
![Income Statement
2016
2017
Sales
15,000,000 20,000,000
6,000,000 11,000,000
3,000,000 3,500,000
| 2,000,000 2,500,000
COGS
S&A Expenses
Depreciation
EBIT (Operating Income) 4,000,000 3,000,000
Taxes (30%)
900,000
450,000
Net Income
| 2,100,000 1,050,000
| 2,000,000 2,000,000
Number of Shares
EPS
$1.05
$0.525
Dividends per Share
$0.50
$0.50
Stock Price
$25.00
$17.50](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbe7e0f78-0008-4035-874d-a5e5f8f262e1%2F7a58b09e-9d0d-471f-95dd-1a73c3720213%2F6hd0f4_processed.png&w=3840&q=75)
Transcribed Image Text:Income Statement
2016
2017
Sales
15,000,000 20,000,000
6,000,000 11,000,000
3,000,000 3,500,000
| 2,000,000 2,500,000
COGS
S&A Expenses
Depreciation
EBIT (Operating Income) 4,000,000 3,000,000
Taxes (30%)
900,000
450,000
Net Income
| 2,100,000 1,050,000
| 2,000,000 2,000,000
Number of Shares
EPS
$1.05
$0.525
Dividends per Share
$0.50
$0.50
Stock Price
$25.00
$17.50
![Balance Sheet
2016
2017
Cash
3,000,000
3.,050,000
A/R
2,000,000
4,000,000
Iv.
2,000,000
4,000,000
11,050,000
Cur. Assets
7,000,000
Net Prop, Plant & Equip
10,000,000
11,000,000
Total Assets
17,000,000
22,050,000
3,500,000
2,000,000
| 1,500,000
A/P
2,500,000
Accruals
1,500,000
Notes Payable
500,000
Cur. Liabilities
4,500,000
7,000,000
Long-Term Debt
5,500,000
8,000,000
Total Liabilities
10,000,000
15,000,000
Common Stock
1,000,000
1,000,000
Retained Earnings
6,000,000
6,050,000
Owners Equity
7,000,000
7,050,000
Tot. Liab. & O.E.
17,000,000
22,050,000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fbe7e0f78-0008-4035-874d-a5e5f8f262e1%2F7a58b09e-9d0d-471f-95dd-1a73c3720213%2F48zxed_processed.png&w=3840&q=75)
Transcribed Image Text:Balance Sheet
2016
2017
Cash
3,000,000
3.,050,000
A/R
2,000,000
4,000,000
Iv.
2,000,000
4,000,000
11,050,000
Cur. Assets
7,000,000
Net Prop, Plant & Equip
10,000,000
11,000,000
Total Assets
17,000,000
22,050,000
3,500,000
2,000,000
| 1,500,000
A/P
2,500,000
Accruals
1,500,000
Notes Payable
500,000
Cur. Liabilities
4,500,000
7,000,000
Long-Term Debt
5,500,000
8,000,000
Total Liabilities
10,000,000
15,000,000
Common Stock
1,000,000
1,000,000
Retained Earnings
6,000,000
6,050,000
Owners Equity
7,000,000
7,050,000
Tot. Liab. & O.E.
17,000,000
22,050,000
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 10 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![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
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![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
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education