Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this page shows what is required and the instructions wanted from the auto nation financial statement I provided thanks the image is very clear I

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

this page shows what is required and the instructions wanted from the auto nation financial statement I provided thanks

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

the image is very clear I took photos several times , my phone is very old and I am trying my best with the question. thank

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

income statement provided

EXHIBIT 14-26 Summary of Analytical Measures Ratios or Other Measurements Method of Computation Significance Measures of short-term liquidity Current ratio Quick ratio Current Assets Current Liabilities Quick Assets Current Liabilities Current Assets - Current Liabilities Working capital Net cash provided by operating activities Appears in the statement of cash flows Cash flow from operations to Cash Flows from Operating Activities Current Liabilities current liabilities Accounts receivable turnover rate A measure of short-term debt-paying ability A measure of short-term debt paying ability A measure of short-term debt-paying ability Indicates the cash generated by operations after allowing for cash payment of expenses and operat- ing liabilities Indicates ability to cover currently maturing obligations from recurring operations Indicates how quickly receivables are collected Indicates in days how quickly receivebles are collected Indicates how quickly Inventory sells Indicates in days how quickly inventory sells Indicates in days how quickly cash invested in inventory converts back into cash Excess of operating cash flow over basic needs Net Sales Average Accounts Receivable 365 Days Accounts Receivable Turnover Rate Cost of Goods Sold Average Inventory 365 Days Inventory Turnover Rate Days to Sell Inventory+ Days to Collect Receivables Days to collect average accounts receivable Inventory turnover rate Days to sell the average inventory Operating cycle Free cash flow Net Cash from Operating Activities -Cash Used for investing Activities and Dividends 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 Days to sell the average inventory 365 Days Operating cycle Inventory Turnover Rate Days to Sell Inventory+ Days to Collect Receivables Indicates in days how quickdy Inventory sells Indicates in days how quickly cash invested in Inventory converts back into cash Excess of operating cash flow over basic needs Free cash flow Net Cash from Operating Activities - Cash Used for Investing Activities and Dividends Measures of long-term credit risk Debt ratio Total Liabilities Total Assets Trend in net cash provided by operating activities Appears in comparative statements of cash flows Percentage of assets financed by creditors, indicates relative size of the equity position Indicator of a company's ability to generate the cash necessary to meet its obligations Indicator of a company's ability to meet its interest payment obligations Interest coverage ratio Income before Interest and Taxes Annual Inteest Expense Measures of profitability Percentage changes; that is, in net sales and net income Dollar Amount of Change Financial Statement Amount in the Earlier Year The rate at which a key measure is increasing or decreasing: the "growth rate A measure of the profitability of the company's products A measure of management's ability to control expenses Gross Profit Net Sales Gross profit rate Operating expense ratio Operating Expenses Net Sales 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 Uue Aug SUUY 11.Jul POTU Submitting a nie upload File Types xls xlsx, doc, and docx ements This assignment requires two files to be uploaded. Do not hit submit until you have selected both files. Chapter 14 of your textbook describes several ratios as well as vertical analysis and horizontal analysis of financial statements. Using the annual report and excelfile of financial statements for AutoNation, prepare the following items. Use the spreadsheet provided and modify it with your calculations. Just be sure to change the file name to something with your name in it. You must use spreadsheets (and formulas) for this assignment. Common Size Balance Sheet Prepare a spreadsheet with common size balance sheets for the years ended December 31, 2019 and 2018. For 2019, each line item should be shown as a percentage of total assets on December 31, 2019. Likewise, for 2018, each item should be shown as a percentage of total assets on December 31, 2018 in your calculations, round each percentage to three digits. For example if cash as a percentage of total assets is.054029834. your answer should be shown as 5.4%. These numbers on the financial statements are rounded to the nearest million, so it is a bit silly to show calculations with more precision than the underlying data. ents ons Common Size Income Statement e Course 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. Horizontal Analysis of both financial statements Prepare a horizontal analysis of the balance sheet and income statement showing the percentage change from 2018 to 2019 (the dollar amounts, not the percentages you calculated in the common size statements). This is calculated as follows: (2019 amount - 2018 amount)/2018 amount Thus, each line item on the balance sheet and income statement should show a percentage increase or decrease. A negative number, or decrease, can be formatted to show in parentheses, which is the preferable notation in accounting circles. Ratios Calculate all of the ratios listed in exhibit 14-26 (page 662). "Summary of Analytical Measures" for AutoNation in 2019 (you do not need to do ratios for 2018. Also calculate the Debt/Equity ratio, which is Total Liabilities/Total Owners Equity (this is not in the book but will be discussed in class). "You also do not need to calculate EPS. It is shown on the income statement In any place where the formula calls for an average, use the 2019 number plus the 2018 number divided by 2 Common Size Balance Sheet Prepare a spreadsheet with common size balance sheets for the years ended December 31, 2019 and 2018. For 2019, each line item should be shown as a percentage of total assets on December 31, 2019. Likewise, for 2018, each item should be shown as a percentage of total assets on December 31, 2018. In your calculations, round each percentage to three digits. For example if cash as a percentage of total assets is .054029834. your answer should be shown as 5.4%. These numbers on the financial statements are rounded to the nearest million, so it is a bit silly to show calculations with more precision than the underlying data. 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. Horizontal Analysis of both financial statements Prepare a horizontal analysis of the balance sheet and income statement, showing the percentage change from 2018 to 2019 (the dollar amounts, not the percentages you calculated in the common size statements). This is calculated as follows: (2019 amount - 2018 amount)/2018 amount Thus, each line item on the balance sheet and income statement should show a percentage increase or decrease. A negative number, or decrease, can be formatted to show in parentheses, which is the preferable notation in accounting circles. Ratios Calculate all of the ratios listed in exhibit 14-26 (page 662). "Summary of Analytical Measures." for AutoNation in 2019 (you do not need to do ratios for 2018). Also calculate the Debt/Equity ratio, which is Total Liabilities/Total Owners Equity (this is not in the book but will be discussed in class); *You also do not need to calculate EPS. It is shown on the income statement In any place where the formula calls for an average use the 2019 number plus the 2018 number divided by 2 The listed items should be submitted in an Excel file. Be sure to change the name of the Excel file to include our last name Cut Calibri 14 Custom Copy Paste Format Painter Clipboard B / Wrap Text Merge & Center % Conditional Format Cell Formatting as Table Styles Number Styles Insert Delete Format Alignment Font & 170 B17 Cells A B D E G H Consolidated Balance Sheets - USD ($) $ in Millions Dec. 31, 2018 Dec. 31, 2019 1 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 $ 290.3 $ 170.0 $ 355.6 $ 708.5 Consolidated Statements of Cash $ 3,997.7 $ 306.2 $ 630.0 $ 44.3 $ 679.9 Ready -- = Auto Nation simplified financial statements (2) - Microsoft Excel Home Insert Page Layout Formulas Data Review View Calibri - 14 A Wrap Text Custom AutoSum Paste Cut Copy Format Painter Clipboard U . Full Merge & Center 09 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Alignment Font fi 170 Number Cells Edit B17 B D E TI G 1 16 Accounts payable $ 290.3 $ 306.2 17 Commercial paper $ 170.0 $ 630.0 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) 82 Treasury stock, at cost; 13,212,974 and 12,540,065 shares held, $ (544.1) Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash Ready g EXHIBIT 14-26 Summary of Analytical Measures Ratios or Other Measurements Method of Computation Significance Measures of short-term liquidity Current ratio Current Assets Current Liabilities Quick ratio Quick Assets Current Liabilities Current Assets - Current Liabilities Working capital Net cash provided by operating activities Appears in the statement of cash flows A measure of short-term debt-paying ability A measure of short-term debt-paying ability A measure of short-term debt-paying ability Indicates the cash generated by operations after allowing for cash payment of expenses and operat- ing liabilities Indicates ability to cover currently maturing obligations from recurring operations Indicates how quickly receivables are collected Indicates in days how quickly receivables are collected Indicates how quickly inventory sells Indicates in days how quickly Cash flow from operations to current liabilities Cash Flows from Operating Activities Current Liabilities Accounts receivable turnover rate Days to collect average accounts receivable Inventory turnover rate Net Sales Average Accounts Receivable 365 Days Accounts Receivable Turnover Rate Cost of Goods Sold Average Inventory 365 Days Days to sell the average inventory 15 Vehicle floorplan Payable 16 Accounts Payable 17 Commercial paper 18 Current Maturities of Long Term Debt 19 Other Current Liabilities 20 Total Current Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities $ 3,575.80 33.92% $ 3,997 70 $ 290.30 2.75% $ 306.20 $ 170.00 1.61% $ 630.00 $ 355.60 3.37% $ 44.30 $ 708.50 6.72% $ 679.90 $ 5,100.20 48.37% $ 5,658.10 $ 1,578.50 14.97% $ 1926.20 $ 305.00 2.89% $ 37.48% 2.87% 5.91% 0.42% 6.37% 53.05% 18.06% 0.00% B $ 708.50 $ 5,100.20 $ 1,578.50 $ 305.00 $ 135.10 $ 262.40 $ 7,381.20 C D 6.72% $ 679.90 48.37% $ 5,668.10 14.97% $ 1,926.20 2.89% $ 1.28% $ 89.80 2.49% $ 275.00 70.01% $ 7,949.10 E 6.37% 53.05% 18.06% 0.00% 0.84% 258% 74.53% A 19 Other Current Liabilities 20 Total Current Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities 23 Deferred income taxes 24 Other Liabilities 25 Total Liabilities 26 Commitment and Contingencies 27 Shareholders; Equity 28 Preferred Stock 29 Common Stock 30 Additional paid in Capital 31 Retained Earnings 32 Treasury Stock 33 Total Shareholders' Equity 34 Total Liabilities and shareholders' equity 35 $ 0.00% $ $ 1.00 0.01% $ 1.00 $ 35.90 0.34% $ 20.80 $ 3,688.30 34.98% $ 3.238.30 $ (563.10) 5.34% $ (544.10) $ 3.162.10 29.99% $ 2,716.00 $ 10,543.30 100.00% $10,665.10 0.00% 0.01% 0.20% 30.36% -5.10% 25.47% 100.00% 3R C E B Dec 31, 2019 D Dec 31, 2018 42 916.7 33058 146.6 =SUM B3:36 3174.6 333.1 1501.9 5816 541 SUM B8:B12.17) =B3/$B$13 486 =B4/$B$13 976 2 =B5/$B$13 3850,5 =B8/S8$13 208.7 =B7/$B$13 SUM(D3:D6) =B8/$B$13 3155 3 =B9/$B$13 0 =B10/$B$13 1513.2 =B11/$B$13 595.4 =B12/$B$13 517.2 =B13/$B$13 =SUM/D8:012.07) =D3/$D$13 =D4/$D$13 =D5/$D$13 =D6/$D$13 =D7/SD$13 =D8/SD$13 =D9/$D$13 =D10/SD$13 =D11/$D$13 =D12/$D$13 =D13/$D$13 170 1 Consolidated Balance sheet - USD($) in Million 2 Current Assets 3 Cash and Cash Equivalents 4 Receivables, Net 5 Inventory 6 Other Current Assets 7 Total Current Assets 8 Propertyand 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 20 Total Current Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities 23 Deferred income taxes 24 Other Liabilities 25 Total Liabilities 26 Commitment and Contingencies 27 Shareholders; Equity 28 Preferred Stock 29 Common Stock 30 Additional paid in Capital 31 Retained Earnings 32 Treasury Stock 33 Total Shareholders' Equity 34 Total Liabilities and shareholders' equity 35 3575.8 =B15/$B$13 3997.7 =D15/$D$13 290.3 =B16/$B$13 306.2 =D16/$D$13 =B17/$B$13 630 =D17/$D$13 355 6 =B18/$B$13 443 =D18/$D$13 7085 =B19/$B$13 679.9 =D19/$D$13 -SUM(B15:B19) =B20/$B$13 SUM(D15:D19) =D20/$D$13 1578.5 =B21/$B$13 19262 =D21/SD$13 305 =B22/SB$13 0 =D22/$D$13 15785 =B21/$B$13 19262 =D21/$D$13 305 =B22/$B$13 0 =D22 $D$13 135.1 =B23/$B$13 89.8 =D23/$D$13 262.4 =B24/$B$13 275 =D24/SD$13 =SUM(B21:B24.B20) B25/$B$13 =SUM/D21:D24.D20) =D25/$D$13 0 35 9 36883 -5631 =SUM(B28.B32) =B33+B25 =B28/$B$13 0 =B29/58$13 1 =B30/$B$13 20.8 =B31/$B$13 3238 3 =B32/$B$13 -5441 =B33/$B$13 =SUMD28 D32) B34/58$13 D33+D25 =D28/$D$13 =D29/$D$13 =D30/$D$13 =D31/$D$13 =D32/$D$13 =D33/$D$13 =D34/$D$13 B Dec 31, 2019 D E Dec 31, 2018 1 Consolidated Balance sheet - USD($) in Million 2 Current Assets 3 Cash and Cash Equivalents 4 Receivables, Net 5 Inventory 6 Other Current Assets 7 Total Current Assets 8 Propertyand 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 20 Total Current Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities $ $ 42.00 0.40% $ 48.60 0.46% $ 916.70 8.69% $ 976.20 9.15% $ 3,305.80 31.35% $ 3,650.50 34.23% $ 146.60 1.39% $ 208.70 1.96% $ 4,411.10 ' 41.84% $4,884.00 45.79% $ 3,174.60 30.11% $ 3,155 30 29.59% $ 333.10 3.16% $ 0.00% $ 1,501.90 14.25% $ 1,513.20 14.19% $ 581.60 5.52% $ 595.40 5.58% $ 541.00 5.13% $ 517.20 4.85% $ 10,543.30 100.00% $10,665.10 100.00% $ 3,575.80 33.92% $ 3,997 70 $ 290.30 2.75% $ 306.20 $ 170.00 1.61% $ 630.00 $ 355.60 3.37% $ 44.30 $ 708.50 6.72% $ 679.90 $ 5,100.20 48.37% $ 5,658.10 $ 1,578.50 14.97% $ 1,926.20 $ 305.00 2.89% $ 37.48% 2.87% 5.91% 0.42% 6.37% 53.05% 18.06% 0.00% E 6.37% 53.05% B D $ 708,50 6.72% $ 679.90 $ 5,100.20 48.37% $ 5,658.10 $ 1,578.50 14.97% $ 1,926.20 $ 305.00 2.89% $ $ 135.10 1.28% $ 89.80 $ 262.40 2.49% $ 275.00 $ 7,381.20 70.01% $ 7,949.10 18.06% 0.00% 0.84% 2.58% 74.53% A 19 Other Current Liabilities 20 Total Current Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities 23 Deferred income taxes 24 Other Liabilities 25 Total Liabilities 26 Commitment and Contingencies 27 Shareholders; Equity 28 Preferred Stock 29 Common Stock 30 Additional paid in Capital 31 Retained Earnings 32 Treasury Stock 33 Total Shareholders' Equity 34 Total Liabilities and shareholders' equity 35 3R $ 0.00% $ $ 1.00 0.01% $ 1.00 $ 35.90 0.34% $ 20.80 $ 3,688.30 34.98% $ 3,238.30 $ (563.10) -5,34% $ (544.10) $ 3,162.10 29.99% $ 2,716.00 $10,543.30 100.00% $10,665.10 0.00% 0.01% 0.20% 30.36% -5.10% 25.47% 100.00% E B Dec 31, 2019 D Dec 31, 2018 1 Consolidated Balance sheet - USD(S) in Million 2 Current Assets 3 Cash and Cash Equivalents 4 Receivables, Net 5 Inventory 6 Other Current Assets 7 Total Current Assets 8 Propertyand Equipment, Net 9 Operating lease Assets 10 Goodwil 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 20 Total Current Liabilities 21 Long Term debt 42 916 7 33058 146.6 =SUMB3:36) 3174.6 333.1 1501.9 581.6 541 - SUMB8:B12,87) =B3/$B$13486 =D3/$0$13 =B4/$B$13 9762 =D4/$0$13 =B5/$B$13 36505 =D5/$0$13 =B6/SB$13 208.7 =D8/$D$13 =B7/$B$13 SUMD3:D6) =D7/SD$13 =B8/SB$13 3155.3 =D8/$D$13 =B9/SB$13 0 =D9/$D$13 =B10/SB$13 1513.2 =D10/$D$13 =B11/$B$13 595.4 =D11/$D$13 =B12/$B$13 5172 =D12 $D$13 =B13/58813 -SUMDB:D12.07)_=D13/$D$13 3575.8 290.3 170 3556 708.5 = SUM(B15-B19) 15785 =B15/$B$13 39977 =B16/$B$13 306 2 =B17/$B$13 630 =B1B/$B$13 443 =B19/$B$13 6799 -B20758$13 SUM/D15:19) =R21/SAS13 19262 =D15/$D$13 =D16/$D$13 =D17/$D$13 =D18/$D$13 =D19/$D$13 =D20/$D$13 =121/SDS13 Common Size Income Statement se 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. Wrap Text Custom Copy Paste Format Painter Clipboard B22 Merge & Center - Font Alignment di Conditional Format Cell Formatting as Table Styles Styles Insert Delete -0.8 Number Cells 1 D F B Consolidated Statements of Income - USD ($) shares in Millions, $ in 12 Months Ended Millions Dec. 31, Dec. 31, Dec. 31, 2 2019 2018 2017 3 Revenue: 4 TOTAL REVENUE $ 21,335.7 ### 5 Cost of Sales: 6 TOTAL COST OF SALES (excluding depreciation shown below) $ 17,812.7 7 Gross Profit: 8 TOTAL GROSS PROFIT $ 3,523.0 $3,397.3 $3,359.0 9 Selling, general, and administrative expenses $ 2,558.6 $ 2,509.8 $2,436.2 10 Depreciation and amortization $ 180.5 $ 166.2 $ 158.6 11 Franchise rights impairment $9.6 $ 8.1 $ 0.0 12 Other income, net $ (49.3) $ (64.7) $ (79.2) 13 OPERATING INCOME $ 823.6 $ 777.9 $ 843.4 14 Non-operating income (expense) items: 15 Floorplan interest expense $(138.4) $(130.4) $ (97.0) 26 Other interest expense $ (106.7) $ (119.4) $ (120.2) $ 0.5 $ 1.1 7 Interest income $ 1.0 $ 33.6 $ 0.2 3 Other income, net $ 9.3 $ 612.6 $ 529.4 $ 636.5 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash ady PI Average: 5 (0.4) 15 Floorplan interest expense 16 Other interest expense 17 Interest income 18 Other income, net 19 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES 20 Income tax provision 21 NET INCOME FROM CONTINUING OPERATIONS 22 Income (loss) from discontinued operations, net of income taxes 23 NET INCOME 24 BASIC EARNINGS (LOSS) PER SHARE: 25 Continuing operations (in dollars per share) 26 Discontinued operations (in dollars per share) 27 Net income (in dollars per share) 28 Weighted average common shares outstanding (in shares) 29 DILUTED EARNINGS (LOSS) PER SHARE: 30 Continuing operations (in dollars per share) 31 Discontinued operations (in dollars per share) 32 Net income (in dollars per share) S (138.4) $ (106.7) $ 0.5 $ 33.6 $ 612.6 $ 161.8 $ 450.8 $ (0.8) $ 450.0 $(130.4) $197.0) $(119.4) S(120.2) $ 1.1 $ 1.0 $ 0.2 $9.3 $ 529.4 $ 636.5 $ 133.5 $201.5 $ 395.9 $ 435.0 $0.1 $ (0.4) $ 396.0 $ 434.6 $ 5 -0.01 $4.99 90.1 $ 4.36 0 $4.36 90.9 $ 4.45 0 $4.44 97.8 $ 4.34 $ 4.98 -0.01 $ 4.97 $ 4.43 0 $ 4.43 $ 4.34 33 EXHIBIT 14-26 Summary of Analytical Measures Ratios or Other Measurements Method of Computation Significance Measures of short-term liquidity Current ratio Quick ratio Current Assets Current Liabilities Quick Assets Current Liabilities Current Assets - Current Liabilities Working capital Net cash provided by operating activities Appears in the statement of cash flows Cash flow from operations to Cash Flows from Operating Activities Current Liabilities current liabilities Accounts receivable turnover rate A measure of short-term debt-paying ability A measure of short-term debt paying ability A measure of short-term debt-paying ability Indicates the cash generated by operations after allowing for cash payment of expenses and operat- ing liabilities Indicates ability to cover currently maturing obligations from recurring operations Indicates how quickly receivables are collected Indicates in days how quickly receivebles are collected Indicates how quickly Inventory sells Indicates in days how quickly inventory sells Indicates in days how quickly cash invested in inventory converts back into cash Excess of operating cash flow over basic needs Net Sales Average Accounts Receivable 365 Days Accounts Receivable Turnover Rate Cost of Goods Sold Average Inventory 365 Days Inventory Turnover Rate Days to Sell Inventory+ Days to Collect Receivables Days to collect average accounts receivable Inventory turnover rate Days to sell the average inventory Operating cycle Free cash flow Net Cash from Operating Activities -Cash Used for investing Activities and Dividends 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 Days to sell the average inventory 365 Days Operating cycle Inventory Turnover Rate Days to Sell Inventory+ Days to Collect Receivables Indicates in days how quickdy Inventory sells Indicates in days how quickly cash invested in Inventory converts back into cash Excess of operating cash flow over basic needs Free cash flow Net Cash from Operating Activities - Cash Used for Investing Activities and Dividends Measures of long-term credit risk Debt ratio Total Liabilities Total Assets Trend in net cash provided by operating activities Appears in comparative statements of cash flows Percentage of assets financed by creditors, indicates relative size of the equity position Indicator of a company's ability to generate the cash necessary to meet its obligations Indicator of a company's ability to meet its interest payment obligations Interest coverage ratio Income before Interest and Taxes Annual Inteest Expense Measures of profitability Percentage changes; that is, in net sales and net income Dollar Amount of Change Financial Statement Amount in the Earlier Year The rate at which a key measure is increasing or decreasing: the "growth rate A measure of the profitability of the company's products A measure of management's ability to control expenses Gross Profit Net Sales Gross profit rate Operating expense ratio Operating Expenses Net Sales 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 Uue Aug SUUY 11.Jul POTU Submitting a nie upload File Types xls xlsx, doc, and docx ements This assignment requires two files to be uploaded. Do not hit submit until you have selected both files. Chapter 14 of your textbook describes several ratios as well as vertical analysis and horizontal analysis of financial statements. Using the annual report and excelfile of financial statements for AutoNation, prepare the following items. Use the spreadsheet provided and modify it with your calculations. Just be sure to change the file name to something with your name in it. You must use spreadsheets (and formulas) for this assignment. Common Size Balance Sheet Prepare a spreadsheet with common size balance sheets for the years ended December 31, 2019 and 2018. For 2019, each line item should be shown as a percentage of total assets on December 31, 2019. Likewise, for 2018, each item should be shown as a percentage of total assets on December 31, 2018 in your calculations, round each percentage to three digits. For example if cash as a percentage of total assets is.054029834. your answer should be shown as 5.4%. These numbers on the financial statements are rounded to the nearest million, so it is a bit silly to show calculations with more precision than the underlying data. ents ons Common Size Income Statement e Course 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. Horizontal Analysis of both financial statements Prepare a horizontal analysis of the balance sheet and income statement showing the percentage change from 2018 to 2019 (the dollar amounts, not the percentages you calculated in the common size statements). This is calculated as follows: (2019 amount - 2018 amount)/2018 amount Thus, each line item on the balance sheet and income statement should show a percentage increase or decrease. A negative number, or decrease, can be formatted to show in parentheses, which is the preferable notation in accounting circles. Ratios Calculate all of the ratios listed in exhibit 14-26 (page 662). "Summary of Analytical Measures" for AutoNation in 2019 (you do not need to do ratios for 2018. Also calculate the Debt/Equity ratio, which is Total Liabilities/Total Owners Equity (this is not in the book but will be discussed in class). "You also do not need to calculate EPS. It is shown on the income statement In any place where the formula calls for an average, use the 2019 number plus the 2018 number divided by 2 Common Size Balance Sheet Prepare a spreadsheet with common size balance sheets for the years ended December 31, 2019 and 2018. For 2019, each line item should be shown as a percentage of total assets on December 31, 2019. Likewise, for 2018, each item should be shown as a percentage of total assets on December 31, 2018. In your calculations, round each percentage to three digits. For example if cash as a percentage of total assets is .054029834. your answer should be shown as 5.4%. These numbers on the financial statements are rounded to the nearest million, so it is a bit silly to show calculations with more precision than the underlying data. 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. Horizontal Analysis of both financial statements Prepare a horizontal analysis of the balance sheet and income statement, showing the percentage change from 2018 to 2019 (the dollar amounts, not the percentages you calculated in the common size statements). This is calculated as follows: (2019 amount - 2018 amount)/2018 amount Thus, each line item on the balance sheet and income statement should show a percentage increase or decrease. A negative number, or decrease, can be formatted to show in parentheses, which is the preferable notation in accounting circles. Ratios Calculate all of the ratios listed in exhibit 14-26 (page 662). "Summary of Analytical Measures." for AutoNation in 2019 (you do not need to do ratios for 2018). Also calculate the Debt/Equity ratio, which is Total Liabilities/Total Owners Equity (this is not in the book but will be discussed in class); *You also do not need to calculate EPS. It is shown on the income statement In any place where the formula calls for an average use the 2019 number plus the 2018 number divided by 2 The listed items should be submitted in an Excel file. Be sure to change the name of the Excel file to include our last name Cut Calibri 14 Custom Copy Paste Format Painter Clipboard B / Wrap Text Merge & Center % Conditional Format Cell Formatting as Table Styles Number Styles Insert Delete Format Alignment Font & 170 B17 Cells A B D E G H Consolidated Balance Sheets - USD ($) $ in Millions Dec. 31, 2018 Dec. 31, 2019 1 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 $ 290.3 $ 170.0 $ 355.6 $ 708.5 Consolidated Statements of Cash $ 3,997.7 $ 306.2 $ 630.0 $ 44.3 $ 679.9 Ready -- = Auto Nation simplified financial statements (2) - Microsoft Excel Home Insert Page Layout Formulas Data Review View Calibri - 14 A Wrap Text Custom AutoSum Paste Cut Copy Format Painter Clipboard U . Full Merge & Center 09 Insert Delete Format Conditional Format Cell Formatting as Table Styles Styles 2 Clear Alignment Font fi 170 Number Cells Edit B17 B D E TI G 1 16 Accounts payable $ 290.3 $ 306.2 17 Commercial paper $ 170.0 $ 630.0 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) 82 Treasury stock, at cost; 13,212,974 and 12,540,065 shares held, $ (544.1) Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash Ready g EXHIBIT 14-26 Summary of Analytical Measures Ratios or Other Measurements Method of Computation Significance Measures of short-term liquidity Current ratio Current Assets Current Liabilities Quick ratio Quick Assets Current Liabilities Current Assets - Current Liabilities Working capital Net cash provided by operating activities Appears in the statement of cash flows A measure of short-term debt-paying ability A measure of short-term debt-paying ability A measure of short-term debt-paying ability Indicates the cash generated by operations after allowing for cash payment of expenses and operat- ing liabilities Indicates ability to cover currently maturing obligations from recurring operations Indicates how quickly receivables are collected Indicates in days how quickly receivables are collected Indicates how quickly inventory sells Indicates in days how quickly Cash flow from operations to current liabilities Cash Flows from Operating Activities Current Liabilities Accounts receivable turnover rate Days to collect average accounts receivable Inventory turnover rate Net Sales Average Accounts Receivable 365 Days Accounts Receivable Turnover Rate Cost of Goods Sold Average Inventory 365 Days Days to sell the average inventory 15 Vehicle floorplan Payable 16 Accounts Payable 17 Commercial paper 18 Current Maturities of Long Term Debt 19 Other Current Liabilities 20 Total Current Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities $ 3,575.80 33.92% $ 3,997 70 $ 290.30 2.75% $ 306.20 $ 170.00 1.61% $ 630.00 $ 355.60 3.37% $ 44.30 $ 708.50 6.72% $ 679.90 $ 5,100.20 48.37% $ 5,658.10 $ 1,578.50 14.97% $ 1926.20 $ 305.00 2.89% $ 37.48% 2.87% 5.91% 0.42% 6.37% 53.05% 18.06% 0.00% B $ 708.50 $ 5,100.20 $ 1,578.50 $ 305.00 $ 135.10 $ 262.40 $ 7,381.20 C D 6.72% $ 679.90 48.37% $ 5,668.10 14.97% $ 1,926.20 2.89% $ 1.28% $ 89.80 2.49% $ 275.00 70.01% $ 7,949.10 E 6.37% 53.05% 18.06% 0.00% 0.84% 258% 74.53% A 19 Other Current Liabilities 20 Total Current Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities 23 Deferred income taxes 24 Other Liabilities 25 Total Liabilities 26 Commitment and Contingencies 27 Shareholders; Equity 28 Preferred Stock 29 Common Stock 30 Additional paid in Capital 31 Retained Earnings 32 Treasury Stock 33 Total Shareholders' Equity 34 Total Liabilities and shareholders' equity 35 $ 0.00% $ $ 1.00 0.01% $ 1.00 $ 35.90 0.34% $ 20.80 $ 3,688.30 34.98% $ 3.238.30 $ (563.10) 5.34% $ (544.10) $ 3.162.10 29.99% $ 2,716.00 $ 10,543.30 100.00% $10,665.10 0.00% 0.01% 0.20% 30.36% -5.10% 25.47% 100.00% 3R C E B Dec 31, 2019 D Dec 31, 2018 42 916.7 33058 146.6 =SUM B3:36 3174.6 333.1 1501.9 5816 541 SUM B8:B12.17) =B3/$B$13 486 =B4/$B$13 976 2 =B5/$B$13 3850,5 =B8/S8$13 208.7 =B7/$B$13 SUM(D3:D6) =B8/$B$13 3155 3 =B9/$B$13 0 =B10/$B$13 1513.2 =B11/$B$13 595.4 =B12/$B$13 517.2 =B13/$B$13 =SUM/D8:012.07) =D3/$D$13 =D4/$D$13 =D5/$D$13 =D6/$D$13 =D7/SD$13 =D8/SD$13 =D9/$D$13 =D10/SD$13 =D11/$D$13 =D12/$D$13 =D13/$D$13 170 1 Consolidated Balance sheet - USD($) in Million 2 Current Assets 3 Cash and Cash Equivalents 4 Receivables, Net 5 Inventory 6 Other Current Assets 7 Total Current Assets 8 Propertyand 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 20 Total Current Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities 23 Deferred income taxes 24 Other Liabilities 25 Total Liabilities 26 Commitment and Contingencies 27 Shareholders; Equity 28 Preferred Stock 29 Common Stock 30 Additional paid in Capital 31 Retained Earnings 32 Treasury Stock 33 Total Shareholders' Equity 34 Total Liabilities and shareholders' equity 35 3575.8 =B15/$B$13 3997.7 =D15/$D$13 290.3 =B16/$B$13 306.2 =D16/$D$13 =B17/$B$13 630 =D17/$D$13 355 6 =B18/$B$13 443 =D18/$D$13 7085 =B19/$B$13 679.9 =D19/$D$13 -SUM(B15:B19) =B20/$B$13 SUM(D15:D19) =D20/$D$13 1578.5 =B21/$B$13 19262 =D21/SD$13 305 =B22/SB$13 0 =D22/$D$13 15785 =B21/$B$13 19262 =D21/$D$13 305 =B22/$B$13 0 =D22 $D$13 135.1 =B23/$B$13 89.8 =D23/$D$13 262.4 =B24/$B$13 275 =D24/SD$13 =SUM(B21:B24.B20) B25/$B$13 =SUM/D21:D24.D20) =D25/$D$13 0 35 9 36883 -5631 =SUM(B28.B32) =B33+B25 =B28/$B$13 0 =B29/58$13 1 =B30/$B$13 20.8 =B31/$B$13 3238 3 =B32/$B$13 -5441 =B33/$B$13 =SUMD28 D32) B34/58$13 D33+D25 =D28/$D$13 =D29/$D$13 =D30/$D$13 =D31/$D$13 =D32/$D$13 =D33/$D$13 =D34/$D$13 B Dec 31, 2019 D E Dec 31, 2018 1 Consolidated Balance sheet - USD($) in Million 2 Current Assets 3 Cash and Cash Equivalents 4 Receivables, Net 5 Inventory 6 Other Current Assets 7 Total Current Assets 8 Propertyand 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 20 Total Current Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities $ $ 42.00 0.40% $ 48.60 0.46% $ 916.70 8.69% $ 976.20 9.15% $ 3,305.80 31.35% $ 3,650.50 34.23% $ 146.60 1.39% $ 208.70 1.96% $ 4,411.10 ' 41.84% $4,884.00 45.79% $ 3,174.60 30.11% $ 3,155 30 29.59% $ 333.10 3.16% $ 0.00% $ 1,501.90 14.25% $ 1,513.20 14.19% $ 581.60 5.52% $ 595.40 5.58% $ 541.00 5.13% $ 517.20 4.85% $ 10,543.30 100.00% $10,665.10 100.00% $ 3,575.80 33.92% $ 3,997 70 $ 290.30 2.75% $ 306.20 $ 170.00 1.61% $ 630.00 $ 355.60 3.37% $ 44.30 $ 708.50 6.72% $ 679.90 $ 5,100.20 48.37% $ 5,658.10 $ 1,578.50 14.97% $ 1,926.20 $ 305.00 2.89% $ 37.48% 2.87% 5.91% 0.42% 6.37% 53.05% 18.06% 0.00% E 6.37% 53.05% B D $ 708,50 6.72% $ 679.90 $ 5,100.20 48.37% $ 5,658.10 $ 1,578.50 14.97% $ 1,926.20 $ 305.00 2.89% $ $ 135.10 1.28% $ 89.80 $ 262.40 2.49% $ 275.00 $ 7,381.20 70.01% $ 7,949.10 18.06% 0.00% 0.84% 2.58% 74.53% A 19 Other Current Liabilities 20 Total Current Liabilities 21 Long Term debt 22 Non Current Operating lease Liabilities 23 Deferred income taxes 24 Other Liabilities 25 Total Liabilities 26 Commitment and Contingencies 27 Shareholders; Equity 28 Preferred Stock 29 Common Stock 30 Additional paid in Capital 31 Retained Earnings 32 Treasury Stock 33 Total Shareholders' Equity 34 Total Liabilities and shareholders' equity 35 3R $ 0.00% $ $ 1.00 0.01% $ 1.00 $ 35.90 0.34% $ 20.80 $ 3,688.30 34.98% $ 3,238.30 $ (563.10) -5,34% $ (544.10) $ 3,162.10 29.99% $ 2,716.00 $10,543.30 100.00% $10,665.10 0.00% 0.01% 0.20% 30.36% -5.10% 25.47% 100.00% E B Dec 31, 2019 D Dec 31, 2018 1 Consolidated Balance sheet - USD(S) in Million 2 Current Assets 3 Cash and Cash Equivalents 4 Receivables, Net 5 Inventory 6 Other Current Assets 7 Total Current Assets 8 Propertyand Equipment, Net 9 Operating lease Assets 10 Goodwil 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 20 Total Current Liabilities 21 Long Term debt 42 916 7 33058 146.6 =SUMB3:36) 3174.6 333.1 1501.9 581.6 541 - SUMB8:B12,87) =B3/$B$13486 =D3/$0$13 =B4/$B$13 9762 =D4/$0$13 =B5/$B$13 36505 =D5/$0$13 =B6/SB$13 208.7 =D8/$D$13 =B7/$B$13 SUMD3:D6) =D7/SD$13 =B8/SB$13 3155.3 =D8/$D$13 =B9/SB$13 0 =D9/$D$13 =B10/SB$13 1513.2 =D10/$D$13 =B11/$B$13 595.4 =D11/$D$13 =B12/$B$13 5172 =D12 $D$13 =B13/58813 -SUMDB:D12.07)_=D13/$D$13 3575.8 290.3 170 3556 708.5 = SUM(B15-B19) 15785 =B15/$B$13 39977 =B16/$B$13 306 2 =B17/$B$13 630 =B1B/$B$13 443 =B19/$B$13 6799 -B20758$13 SUM/D15:19) =R21/SAS13 19262 =D15/$D$13 =D16/$D$13 =D17/$D$13 =D18/$D$13 =D19/$D$13 =D20/$D$13 =121/SDS13 Common Size Income Statement se 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. Wrap Text Custom Copy Paste Format Painter Clipboard B22 Merge & Center - Font Alignment di Conditional Format Cell Formatting as Table Styles Styles Insert Delete -0.8 Number Cells 1 D F B Consolidated Statements of Income - USD ($) shares in Millions, $ in 12 Months Ended Millions Dec. 31, Dec. 31, Dec. 31, 2 2019 2018 2017 3 Revenue: 4 TOTAL REVENUE $ 21,335.7 ### 5 Cost of Sales: 6 TOTAL COST OF SALES (excluding depreciation shown below) $ 17,812.7 7 Gross Profit: 8 TOTAL GROSS PROFIT $ 3,523.0 $3,397.3 $3,359.0 9 Selling, general, and administrative expenses $ 2,558.6 $ 2,509.8 $2,436.2 10 Depreciation and amortization $ 180.5 $ 166.2 $ 158.6 11 Franchise rights impairment $9.6 $ 8.1 $ 0.0 12 Other income, net $ (49.3) $ (64.7) $ (79.2) 13 OPERATING INCOME $ 823.6 $ 777.9 $ 843.4 14 Non-operating income (expense) items: 15 Floorplan interest expense $(138.4) $(130.4) $ (97.0) 26 Other interest expense $ (106.7) $ (119.4) $ (120.2) $ 0.5 $ 1.1 7 Interest income $ 1.0 $ 33.6 $ 0.2 3 Other income, net $ 9.3 $ 612.6 $ 529.4 $ 636.5 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES Consolidated Balance Sheets Consolidated Statements of Inco Consolidated Statements of Cash ady PI Average: 5 (0.4) 15 Floorplan interest expense 16 Other interest expense 17 Interest income 18 Other income, net 19 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES 20 Income tax provision 21 NET INCOME FROM CONTINUING OPERATIONS 22 Income (loss) from discontinued operations, net of income taxes 23 NET INCOME 24 BASIC EARNINGS (LOSS) PER SHARE: 25 Continuing operations (in dollars per share) 26 Discontinued operations (in dollars per share) 27 Net income (in dollars per share) 28 Weighted average common shares outstanding (in shares) 29 DILUTED EARNINGS (LOSS) PER SHARE: 30 Continuing operations (in dollars per share) 31 Discontinued operations (in dollars per share) 32 Net income (in dollars per share) S (138.4) $ (106.7) $ 0.5 $ 33.6 $ 612.6 $ 161.8 $ 450.8 $ (0.8) $ 450.0 $(130.4) $197.0) $(119.4) S(120.2) $ 1.1 $ 1.0 $ 0.2 $9.3 $ 529.4 $ 636.5 $ 133.5 $201.5 $ 395.9 $ 435.0 $0.1 $ (0.4) $ 396.0 $ 434.6 $ 5 -0.01 $4.99 90.1 $ 4.36 0 $4.36 90.9 $ 4.45 0 $4.44 97.8 $ 4.34 $ 4.98 -0.01 $ 4.97 $ 4.43 0 $ 4.43 $ 4.34 33

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

Advanced Financial Accounting

Authors: Richard E. Baker, Valdean C. Lembke, Thomas E. King

5th Edition

0072444126, 978-0072444124

More Books

Students also viewed these Accounting questions

Question

Write a program to check an input year is leap or not.

Answered: 1 week ago

Question

Write short notes on departmentation.

Answered: 1 week ago

Question

What are the factors affecting organisation structure?

Answered: 1 week ago

Question

What are the features of Management?

Answered: 1 week ago

Question

Briefly explain the advantages of 'Management by Objectives'

Answered: 1 week ago