Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

FINANCIAL RATIOS YEAR 2020 GROWTH RATIOS CAGR (20XX-20XX) % Growth Rate - previous year % PROFITABILITY RATIOS Gross Profit Margin % Operating Profit Margin %

image text in transcribed

FINANCIAL RATIOS

YEAR 2020

GROWTH RATIOS

CAGR (20XX-20XX)

%

Growth Rate - previous year

%

PROFITABILITY RATIOS

Gross Profit Margin

%

Operating Profit Margin

%

Net Profit Margin

%

ROA

%

ROE

%

SUSTAINABILITY RATIOS

LIQUIDITY RATIOS

Cash Flow from Operations

$

Current Ratio

Quick Ratio

Inventory Turnover Rate

X

Days in Inventory

days

DEBT RATIOS

Debt to Asset

Debt to Equity

Times Interest Earned

x

Please solve for year 2020, then using the previous years to help find growth rates.

Income Statement Values are in Millions 2020 2019 2018 2017 2016 Total Revenue 514,405 500,343 485,873 482,130 485,651 Cost of Revenue, 385,301 373,396 361,256 360,984 365,086 Total Gross Profit 129,104 126,947 124,617 121,146 120,565 Selling/Gen/Admin 106,374 105,884 101,257 96,593 92,956 Expense 773 626 596 448 462 Labor & Related Expense 107,147 106,510 101,853 97,041 93,418 SellGen/Admin Expenses, Total 4,800 3,136 Other Unusual Expense (In) - -- Unusual Expense (Income) 4,800 3,136 -- Total Operating Income 17,157 17,301 22,764 24,105 27,147 (5,697) (2,178) (2,267) (2,467) (2,348) Interest Expense, Net Non- Operating Income Before Tax 11,460 15,123 20,497 21,638 24,799 3,839 4,800 Provision for Income Taxes 6,204 6,558 7,985 7,621 10,323 14,293 Net Income After Taxes 15,080 16,814 Balance Sheet Values are in Millions 2020 2019 2018 2017 2016 Cash 7,722 6,456 6,602 8,343 9,135 Inventory 44,269 43,783 43,046 44,469 45,141 61,897 Total Current Assets 59,664 57,689 60,239 63,278 Total Assets 219,295 204,522 198,825 199,581 203,490 Total Current Liabilities 77,477 78,521 66,928 64,619 65,253 Total Debt 54,170 42,446 42,729 50,034 50,165 Total Liabilities 146,799 126,653 121,027 119,035 122,096 Total Equity 72,496 77,869 77,798 77,798 80,546 81,394 Total Liabilities & 219,295 204,522 198,825 199,581 203,490 Shareholders' Equity

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

Accounting Principles

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

9th Edition

978-0470317549, 9780470387085, 047031754X, 470387084, 978-0470533475

More Books

Students also viewed these Accounting questions