Answered step by step
Verified Expert Solution
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
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 roundStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started