Common Size Income Statement 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. Auto Nation simplified financial statements (2) - Microsoft Excel Page Layout Formulas Data Review View Calibri 11 A Home Insert X Cut La Copy Paste Format Painter Clipboard B17 Wrap Text Custom BIU Merge & Center - Insert Delete Format Font Alignment as Table - Styles - Styles e Clear Number Sort & Find a Filter - Select Editing 170 Call D F G H . B c Consolidated Balance Sheets - USD ($) $ in Millions 1 Dec. 31, Dec. 31, 2 CURRENT ASSETS: 2019 2018 3 Cash and cash equivalents 4 Receivables, net $ 42.0 $48.6 5 Inventory $916.7 $976.2 $ 3,305.8 $3,650.5 6 Other current assets 7 Total Current Assets $ 146.6 $ 208.7 $ 4,411.1 $4,884.0 8 PROPERTY AND EQUIPMENT, NET $ 3,174.6 $3,155.3 9 OPERATING LEASE ASSETS $ 333.1 $ 0.0 10 GOODWILL $ 1,501.9 $1,513.2 11 OTHER INTANGIBLE ASSETS, NET $ 581.6 $ 595.4 12 OTHER ASSETS $ 541.0 $ 517.2 13 Total Assets ######### 14 CURRENT LIABILITIES: 15 Vehicle floorplan payable $3,575.8 $3,997.7 $ 290.3 $ 306.2 16 Accounts payable $ 170.0 $ 630.0 17 Commercial paper $ 355.6 $ 44.3 18 Current maturities of long-term debt $ 708.5 $ 679.9 19 Other current liabilities Consoldated Statements of Cash Consolidated Statements of Inco K Consolidated Balance Sheets Ready + - Samatti Format Call Page Layout Auto Nation simplified financial statements (2) - Microsoft Excel Formulas Data Review View Calibri 114 Home Insert X cut Fa Copy Paste Format Painter Clipboard R17 A BIU-- Custom 9 Wrap Ted ESTER E Merge & Center Alignment 3 - Font f 170 Conditional Format Cen Formatting as Table Styles Styles Insert Delete Format - Autosum Fill Sort & tida Clear Fiter Select- Editing Number D E F G H A 19 Other current liabilities C 20 Total Current Liabilities $ 708.5 $ 679.9 21 LONG-TERM DEBT, NET OF CURRENT MATURITIES $ 5,100.2 $ 5,658.1 22 NONCURRENT OPERATING LEASE LIABILITIES $ 1,578.5 $ 1,926.2 23 DEFERRED INCOME TAXES $ 305.0 $ 0.0 $ 89.8 $ 135.1 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 Treasury stock, at cost; 13,212,974 and 12,540,065 shares held, $ (563.1) $ 7544.1) 32 $ 2.716.0 $ 3,162.1 33 Total Shareholders' Equity ######## ######## 34 Total Liabilities and Shareholders' Equity 35 NME Consolidated Balance Sheets Consoldated Statements of Inco Consolidated Statements of Cash Ready 1001 18:55 23/09/2020 Common Size Income Statement 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. Auto Nation simplified financial statements (2) - Microsoft Excel Page Layout Formulas Data Review View Calibri 11 A Home Insert X Cut La Copy Paste Format Painter Clipboard B17 Wrap Text Custom BIU Merge & Center - Insert Delete Format Font Alignment as Table - Styles - Styles e Clear Number Sort & Find a Filter - Select Editing 170 Call D F G H . B c Consolidated Balance Sheets - USD ($) $ in Millions 1 Dec. 31, Dec. 31, 2 CURRENT ASSETS: 2019 2018 3 Cash and cash equivalents 4 Receivables, net $ 42.0 $48.6 5 Inventory $916.7 $976.2 $ 3,305.8 $3,650.5 6 Other current assets 7 Total Current Assets $ 146.6 $ 208.7 $ 4,411.1 $4,884.0 8 PROPERTY AND EQUIPMENT, NET $ 3,174.6 $3,155.3 9 OPERATING LEASE ASSETS $ 333.1 $ 0.0 10 GOODWILL $ 1,501.9 $1,513.2 11 OTHER INTANGIBLE ASSETS, NET $ 581.6 $ 595.4 12 OTHER ASSETS $ 541.0 $ 517.2 13 Total Assets ######### 14 CURRENT LIABILITIES: 15 Vehicle floorplan payable $3,575.8 $3,997.7 $ 290.3 $ 306.2 16 Accounts payable $ 170.0 $ 630.0 17 Commercial paper $ 355.6 $ 44.3 18 Current maturities of long-term debt $ 708.5 $ 679.9 19 Other current liabilities Consoldated Statements of Cash Consolidated Statements of Inco K Consolidated Balance Sheets Ready + - Samatti Format Call Page Layout Auto Nation simplified financial statements (2) - Microsoft Excel Formulas Data Review View Calibri 114 Home Insert X cut Fa Copy Paste Format Painter Clipboard R17 A BIU-- Custom 9 Wrap Ted ESTER E Merge & Center Alignment 3 - Font f 170 Conditional Format Cen Formatting as Table Styles Styles Insert Delete Format - Autosum Fill Sort & tida Clear Fiter Select- Editing Number D E F G H A 19 Other current liabilities C 20 Total Current Liabilities $ 708.5 $ 679.9 21 LONG-TERM DEBT, NET OF CURRENT MATURITIES $ 5,100.2 $ 5,658.1 22 NONCURRENT OPERATING LEASE LIABILITIES $ 1,578.5 $ 1,926.2 23 DEFERRED INCOME TAXES $ 305.0 $ 0.0 $ 89.8 $ 135.1 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 Treasury stock, at cost; 13,212,974 and 12,540,065 shares held, $ (563.1) $ 7544.1) 32 $ 2.716.0 $ 3,162.1 33 Total Shareholders' Equity ######## ######## 34 Total Liabilities and Shareholders' Equity 35 NME Consolidated Balance Sheets Consoldated Statements of Inco Consolidated Statements of Cash Ready 1001 18:55 23/09/2020