Calculate following ratios If you are not able to calculate with the given the information shown, indicate what is missing. After calculating each ratio indicate whether the trend from 2017 to 2018 is good or bad and why. Year 2018 Year 2017 Net Profit Margin Total Asset turnover Debt to Tangible Net Worth Ratio Operating Cash Flow / Total Debt
Calculate following ratios If you are not able to calculate with the given the information shown, indicate what is missing. After calculating each ratio indicate whether the trend from 2017 to 2018 is good or bad and why. Year 2018 Year 2017 Net Profit Margin Total Asset turnover Debt to Tangible Net Worth Ratio Operating Cash Flow / Total Debt
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Calculate following ratios
If you are not able to calculate with the given the information shown, indicate what is missing. After calculating each ratio indicate whether the trend from 2017 to 2018 is good or bad and why.
|
Year 2018 |
Year 2017 |
Net Profit Margin |
|
|
Total Asset turnover |
|
|
Debt to Tangible Net Worth Ratio |
|
|
Operating |
|
|
![FACEBOOK INC. Balance Sheet 12/31
$ millions
Current Assets Cash and cash equivalent
Marketable securities
Account Rec., Net
Prepaid Exp. And other CA
Total current assets
Prop. And Equi., Net
Intangible assets, Net
Goodwill
Other Assets
Total assets
Current Liabilities
Account payable
Partners payable
Acc. Exp. & Other C.I.
Deferred Rev. and Deposit
Total current liabilities
Other liabilities
Total Liabilities Stockholder Equity
Comm. St. and Add. Capital
Acc. Other Com. Loss
Retained Earnings
Total Stockholder Equity
2018 (A)
10,019.00
2017 (B) Difference Percentage
(C*100/b)
(C=A-B)
1,940.00
820
8,079.00
31,095.00
33,632.00 -2,537.00
7,587.00 5,832.00
1.755.00
1,779.00 1,020.00
759
50,480.00 48,563.00 1,917.00
24,683.00 13,721.00 10,962.00
1,294.00 1,884.00
-590
80
441
18,301.00 18,221.00
2,576.00 2,135.00
97.334.00 84,524.00 12,810.00
380
541
5,509.00
390
2,892.00
98
7,017.00 3,760.00
6,190.00 6,417.00
147
13,207.00 10,177.00
440
151
2,617.00
49
3,257.00
-227
3,030.00
42,906.00 40,584.00 2,322.00
-760
-227
41,981.00 33,990.00
84,127.00 74,347.00
-533
7,991.00
9,780.00
24.01
-7.54
30.09
74.41
3.95
79.89
-31.32
0.44
20.66
15.16
115.79
38.72
90.49
50
86.62
-0.35
29.77
5.72
234.8
23.51
13.15
statement of Income (million)
Net Sales (A)
Operating Expense
Cost of Sales
Selling, General and Administrative Expenses
Research, development and related expenses
Gain on Sale of Business
Total Operating Expense (B)
Operating Income C = (A-B)
Other Expense (Interest Gross) (D)
Other Interest Income (Interest Gross) (E)
Income Before Income Tax F = (C+D+E)
less: Provision for Income Tax
Net Income including non-controlling Interest
less: Net Income Attributable to non-controlling Interest
Net Income Attributable to 3M
2017 (A)
31657
16055
6626
1870
-586
23965
7692
-322
178
7548
2679
4869
11
4858
2018 (B)
32765
16682
7602
1821
-547
25558
7207
-350
143
7000
1637
5363
14
5349
Absolute Percentage
Change C= Change
(B-A)
1108
627
976
-49
39
1593
-485
-28
-35
-548
-1042
494
3
491
(C/A) 100
3.50%
3.91%
14.73%
-2.62%
-6.66%
6.65%
-6.31%
8.70%
-19.66%
-7.26%
-38.90%
10.15%
27.27%
10.11%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F13920004-ffdd-4d52-b98e-646c1ab9f475%2F5fc1ddff-a392-4b43-af48-a61872d02fe0%2F2rh9on_processed.png&w=3840&q=75)
Transcribed Image Text:FACEBOOK INC. Balance Sheet 12/31
$ millions
Current Assets Cash and cash equivalent
Marketable securities
Account Rec., Net
Prepaid Exp. And other CA
Total current assets
Prop. And Equi., Net
Intangible assets, Net
Goodwill
Other Assets
Total assets
Current Liabilities
Account payable
Partners payable
Acc. Exp. & Other C.I.
Deferred Rev. and Deposit
Total current liabilities
Other liabilities
Total Liabilities Stockholder Equity
Comm. St. and Add. Capital
Acc. Other Com. Loss
Retained Earnings
Total Stockholder Equity
2018 (A)
10,019.00
2017 (B) Difference Percentage
(C*100/b)
(C=A-B)
1,940.00
820
8,079.00
31,095.00
33,632.00 -2,537.00
7,587.00 5,832.00
1.755.00
1,779.00 1,020.00
759
50,480.00 48,563.00 1,917.00
24,683.00 13,721.00 10,962.00
1,294.00 1,884.00
-590
80
441
18,301.00 18,221.00
2,576.00 2,135.00
97.334.00 84,524.00 12,810.00
380
541
5,509.00
390
2,892.00
98
7,017.00 3,760.00
6,190.00 6,417.00
147
13,207.00 10,177.00
440
151
2,617.00
49
3,257.00
-227
3,030.00
42,906.00 40,584.00 2,322.00
-760
-227
41,981.00 33,990.00
84,127.00 74,347.00
-533
7,991.00
9,780.00
24.01
-7.54
30.09
74.41
3.95
79.89
-31.32
0.44
20.66
15.16
115.79
38.72
90.49
50
86.62
-0.35
29.77
5.72
234.8
23.51
13.15
statement of Income (million)
Net Sales (A)
Operating Expense
Cost of Sales
Selling, General and Administrative Expenses
Research, development and related expenses
Gain on Sale of Business
Total Operating Expense (B)
Operating Income C = (A-B)
Other Expense (Interest Gross) (D)
Other Interest Income (Interest Gross) (E)
Income Before Income Tax F = (C+D+E)
less: Provision for Income Tax
Net Income including non-controlling Interest
less: Net Income Attributable to non-controlling Interest
Net Income Attributable to 3M
2017 (A)
31657
16055
6626
1870
-586
23965
7692
-322
178
7548
2679
4869
11
4858
2018 (B)
32765
16682
7602
1821
-547
25558
7207
-350
143
7000
1637
5363
14
5349
Absolute Percentage
Change C= Change
(B-A)
1108
627
976
-49
39
1593
-485
-28
-35
-548
-1042
494
3
491
(C/A) 100
3.50%
3.91%
14.73%
-2.62%
-6.66%
6.65%
-6.31%
8.70%
-19.66%
-7.26%
-38.90%
10.15%
27.27%
10.11%
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.
Step by step
Solved in 4 steps
![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