Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data Visualization for Insights into Financial Statements The following graphics relate to Thermo Fisher Scientific for 2009 through 2018. Assets Liabilities Equity $60B Net

image text in transcribed

Data Visualization for Insights into Financial Statements The following graphics relate to Thermo Fisher Scientific for 2009 through 2018. Assets Liabilities Equity $60B Net Income Revenue Market Cap Operating Cash Flow Investing Cash Flow Financing Cash Flow $25B $100B 2018 $20B $80B 2016 $40B $15B $60B 2014 $10B $40B 2012 $20B $5B $20B 2010 $OB $OB $OB 2008 2008 2010 2012 2014 2016 2018 2008 2010 2012 2014 2016 2018 $-15B $-10B $-5B SOB $5B $10B Click the following link to access the Power BI dashboard to answer the requirements: Thermo Fisher Scientific Required a. The graphic on the left shows balance sheet data. L. Which year has the largest assets? 2017 + II. What general trend do we observe for Thermo Fisher's assets? Assets Increased over the years. III. Which tracks more closely with total assets: liabilities or equity? Liabilities iv. Over the 10-year period, how often did liabilities exceed equity? Enter the total number of years liabilities exceeded equity during the 10-year period. years b. The middle graphic shows income statement data and Thermo Fisher's market capitalization (the value of all the company's stock) each year. L. From 2009 to 2017, revenue roughly doubled from $10,110 million to $20,918 million. What was the growth in net income over that period? Compute net income growth as a percentage. Round answer to one decimal place (ex: 1.2345 = 123.5%). 48.3 % II. What general pattern do we observe for revenue? Revenue increased each year in the 10-year period. II. Which year had the biggest percentage increase in revenue? 2014 iv. Which year has a better profit margin (PM), 2017 or 2018? 2018 v. What is the company's market cap in 2018? $ 89,990.88 million c. The graphic on the right shows cash flow data. L Which year has the smallest operating cash flow? 2010 + II. In how many years were financing cash flows negative? years III. In all years but one, cumulative positive cash flows were about equal to cumulative negative cash flows. What year had the largest cumulative negative cash flow? 2014 I d. Use data from the left and middle graphics to calculate return on assets (ROA) and return on equity (ROE) for 2018. Round your answers to one decimal place (ex: 0.2345 = 23.5%). ROA ROE 5.5% x 10.7% x

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial and Managerial Accounting

Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura

5th edition

9780133851281, 013385129x, 9780134077321, 133866297, 133851281, 9780133851298, 134077326, 978-0133866292

More Books

Students also viewed these Accounting questions