Separate and format them (Income Statement, Balance Sheet, Statement of Cash Flows) onto separate tabs Build a RATIOS tab = Main assignment. Select 10 ratios and then you will calculate and present. Use only 2019 data. Financials Valuation Price/Book 21.28 Price/Cash Flow 30.96 Price/Sales 4.93 Price/Earnings 120.48 As of Sep 21, 2020 Growth (3-Year Annualized) Revenue % 27.30 Operating Income % 51.45 Net Income % 69.70 Diluted EPS % 67.46 As of Dec 30, 2019 Financial Health Quick Ratio 0.97 Current Ratio 1.18 Interest Coverage 10.84 Debt/Equity 1.03 As of Jun 29, 2020 Profitability Return on Assets % 5.86 Return on Equity % 20.79 Return on Invested Capital % 10.65 Net Margin % 4.10 As of Jun 29, 2020 Annual v As Originally Reported v Charts Income Statement > Revenue Net Income 300 $ Bil 150 LL 0 2017 2018 2019 Balance Sheet > Assets Debt-Debt/Assets 30% 300 $ Bil 150 15 LLL 0 0 2017 2018 2019 Cash Flow > Operating Investing 40 $ Bil Financing 0 -40 2017 2018 2019 Fiscal year ends in Dec 31 USD in Bil except per share data y Separate and format them (Income Statement, Balance Sheet, Statement of Cash Flows) onto separate tabs Build a RATIOS tab = Main assignment. Select 10 ratios and then you will calculate and present. Use only 2019 data. Financials Valuation Price/Book 21.28 Price/Cash Flow 30.96 Price/Sales 4.93 Price/Earnings 120.48 As of Sep 21, 2020 Growth (3-Year Annualized) Revenue % 27.30 Operating Income % 51.45 Net Income % 69.70 Diluted EPS % 67.46 As of Dec 30, 2019 Financial Health Quick Ratio 0.97 Current Ratio 1.18 Interest Coverage 10.84 Debt/Equity 1.03 As of Jun 29, 2020 Profitability Return on Assets % 5.86 Return on Equity % 20.79 Return on Invested Capital % 10.65 Net Margin % 4.10 As of Jun 29, 2020 Annual v As Originally Reported v Charts Income Statement > Revenue Net Income 300 $ Bil 150 LL 0 2017 2018 2019 Balance Sheet > Assets Debt-Debt/Assets 30% 300 $ Bil 150 15 LLL 0 0 2017 2018 2019 Cash Flow > Operating Investing 40 $ Bil Financing 0 -40 2017 2018 2019 Fiscal year ends in Dec 31 USD in Bil except per share data y