Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please prepare spreadsheet with common size income statements for the 2019 and 2018 fiscal years this is the data that I have. Home Page Layout

image text in transcribed

image text in transcribed

image text in transcribed

please prepare spreadsheet with common size income statements for the 2019 and 2018 fiscal years this is the data that I have.

Home Page Layout Formulas Data Review View Calibri - 14 Custom Autosum Paste Wrap Text it Merge & Center BIU- Fill - ainter A - Insert Delete Format Sort & Find 8. Conditional Format Cell Formatting as Table Styles Styles 2 Clear Font Alignment Number cells Editing f 170 C D E F H Consolidated Balance Sheets - USD ($) $ in Millions B Dec. 31, 2019 Dec. 31, 2018 2 CURRENT ASSETS: 3 Cash and cash equivalents 4 Receivables, net 5 Inventory 6 Other current assets 7 Total Current Assets 8 PROPERTY AND EQUIPMENT, NET 9 OPERATING LEASE ASSETS 10 GOODWILL 11 OTHER INTANGIBLE ASSETS, NET 12 OTHER ASSETS 13 Total Assets 14 CURRENT LIABILITIES: 15 Vehicle floorplan payable 16 Accounts payable 17 Commercial paper 18 Current maturities of long-term debt 19 Other current liabilities Consolidated Balance Sheets Consolidated Statements of Inco $ 42.0 $48.6 $ 916.7 $976.2 $ 3,305.8 $3,650.5 $ 146.6 $ 208.7 $ 4,411.1 $ 4,884.0 $3,174.6 $3,155.3 $ 333.1 $ 0.0 $ 1,501.9 $1,513.2 $ 581.6 $ 595.4 $ 541.0 $ 517.2 $ 3,575.8 $3,997.7 $ 290.3 $ 306.2 $ 170.0 $ 630.0 $ 355.6 $ 44.3 $ 708.5 $ 679.9 Consoldated States of cash VIEW View cut Calibri 14 Copy - Agosu- B U Paste Format Painter Clipboard Wrap Text Custom Merge a Center - -% Conditional Format Cell Formatting as Table Styles Alignment Number Styles Fil- Insert Delete Format Font Clear Sort Find Filter - Seled - Editing B17 170 B D E F G H A 18 Current maturities of long-term debt $ 355.6 $44.3 19 Other current liabilities $ 708.5 $ 679.9 20 Total Current Liabilities $ 5,100.2 $ 5,658.1 21 LONG-TERM DEBT, NET OF CURRENT MATURITIES $1,578.5 $ 1,926.2 22 NONCURRENT OPERATING LEASE LIABILITIES $ 305.0 $ 0.0 23 DEFERRED INCOME TAXES $ 135.1 $89.8 24 OTHER LIABILITIES $262.4 $ 275.0 25 TOTAL LIABILITIES $7,381.2 $ 7,949.1 26 COMMITMENTS AND CONTINGENCIES (Note 19) 27 SHAREHOLDERS' EQUITY: Preferred stock, par value $0.01 per share; 5,000,000 shares $ 0.0 $ 0.0 28 authorized; none issued Common stock, par value $0.01 per share; 1,500,000,000 shares $1.0 $ 1.0 authorized; 102,562,149 shares issued at December 31, 2019, and 29 December 31, 2018, including shares held in treasury 30 Additional paid-in capital $ 35.9 $ 20.8 31 Retained earnings $ 3,688.3 $3,238.3 $ (563.1) Treasury stock, at cost; 13,212,974 and 12,540,065 shares held, $(544.1) 32 33 Total Shareholders' Equity $ 3,162.1 $ 2,716.0 34 Total Liabilities and Shareholders' Equity Consolidated Balance Sheets Consoldated Statements of inco Consoldated Statements of Cash 14 Ready e Common Size Income Statement urse Prepare a spreadsheet with common size income statements for the 2019 and 2018 fiscal years. You do not need to do 2017. In this case, your denominator will be Revenues. Again, remember to round

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_2

Step: 3

blur-text-image_3

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

Creative And Innovative Auditing

Authors: Jeffrey Ridley

1st Edition

1472474627, 9781472474629

More Books

Students also viewed these Accounting questions

Question

Explain in detail the purpose of a measure of center.

Answered: 1 week ago

Question

FNS40821 Certificate IV in Finance and Mortgage Broking

Answered: 1 week ago

Question

Explain the place of planning in human resource management

Answered: 1 week ago