Vertical Analysis of the Income Statement (Common-Size Statements) Do NOT do a Cut operation on any cell in the project. Use the data from Lowe's Consolidated Statements of Earnings to fill in Fiscal 2018 below. Enter the amounts exactly as they are shown on the financial statement, which are in millions. Fiscal 2016 ended February 3, 2017 Dollars $ Lowe's Consolidated Statements of Earnings (Dollars in Millions) Fiscal 2018 Fiscal 2017 ended February 1, 2019 ended February 2, 2018 Dollars Dollars % Click Here to Unlock Yellow Input Cells Net Sales 0.00% $ 68,619 100.00% Cost of Sales 0.00% 46,185 67.31% Gross Margin 0.00% 22,434 32.69% Expenses: Selling, General and Admin. 0.00% 14,444 21.05% Depreciation and Amortization 0.00% 1,404 2.05% Operating Income 0.00% 6,586 9.60% Interest - net 0.00% 633 0.92% Loss on Extinguishment of Debt 0.00% 464 0.68% Pre-Tax Earnings 0.00% 5,489 8.00% Income Tax Provision 0.00% 2,042 2.98% Net Earnings 0.00% $ 3,447 5.02% 65,017 43,343 21,674 100.00% 66.66% 33.34% 14,375 1,453 5,846 645 22.11% 2.23% 8.99% 0.99% 0.00% 8.00% 3.24% 0 5,201 2,108 $ 3,093 4.76% Tip: Lowe's labels Net Income as "Net Eamings" Be sure to use Net Earnings in all calculations that use a Net Income amount. Basic Earnings per Common Share $4.09 $3.48 ** % columns may not add-un due to rounding Enter the amounts for Fiscal 2018 for the following income statement items. Then calculate and enter the Dollar Change and the % Change from Fiscal 2017 to Fiscal 2018. Enter the dollar amounts just as they are shown on the financial statement. Round the percentages to 2 decimal places. XX.XX% Tip: Most cells that require input have a cell format indicator above or below the cell. These format indicators show the type of number required for the cell. These format indicators do not show the size of the number expected for the cell. Click Here to Unlock Yellow Input Cells Fiscal 2018 Sxxx, XXX Dollar Change % Change 2017 to 2018 $xxx,xxx + Fiscal 2017 Dollar Change % Change 2016 to 2017 Fiscal 2016 Net Sales $68,619 $3,602 5.54 $65,017 For example: $XXX,Xxx shows that the input for the cell should be whole dollars with no decimal point. The $xxx,xxx does not indicate that the number should be a 6 digit number. The correct answer for the cell could be as small as 1 digit or as large as 14 digits. % % xx.xx% Sxxx XXX $xxx.xxx Cost of Sales $46,185 $43,343 $2,842 6.56 % Sxxx.xxx SXXX.XXX Gross Margin $22,434 $21,674 Tip: When entering a formula, be sure to begin the formula with an "=" sign. $760 3.51 % % XX.XX% Sxxx,xxx Sxxx XXX $14,444 $14,375 Selling, General and Administrative $69 0.48 % xx.xx% Sxxx,xxx $xxx xxx Pre-Tax Earnings $5,489 $288 5.54 $5,201 % XXXX% Sxxx, xxx Sxxx XXX Income Tax Provision $2,042 $2,108 ($66) (3.13) % % Xxxx% Sxxx XXX Net Earnings Net Earnings $3,447 $3,093 $354 11.45 % SXXX $XXXX $4.09 $3.48 Basic Earnings Per Share Fix Sx.xx Cell Format $0.61 17.53 % xx.xx% Vertical Analysis of the Income Statement (Common-Size Statements) Do NOT do a Cut operation on any cell in the project. Use the data from Lowe's Consolidated Statements of Earnings to fill in Fiscal 2018 below. Enter the amounts exactly as they are shown on the financial statement, which are in millions. Fiscal 2016 ended February 3, 2017 Dollars $ Lowe's Consolidated Statements of Earnings (Dollars in Millions) Fiscal 2018 Fiscal 2017 ended February 1, 2019 ended February 2, 2018 Dollars Dollars % Click Here to Unlock Yellow Input Cells Net Sales 0.00% $ 68,619 100.00% Cost of Sales 0.00% 46,185 67.31% Gross Margin 0.00% 22,434 32.69% Expenses: Selling, General and Admin. 0.00% 14,444 21.05% Depreciation and Amortization 0.00% 1,404 2.05% Operating Income 0.00% 6,586 9.60% Interest - net 0.00% 633 0.92% Loss on Extinguishment of Debt 0.00% 464 0.68% Pre-Tax Earnings 0.00% 5,489 8.00% Income Tax Provision 0.00% 2,042 2.98% Net Earnings 0.00% $ 3,447 5.02% 65,017 43,343 21,674 100.00% 66.66% 33.34% 14,375 1,453 5,846 645 22.11% 2.23% 8.99% 0.99% 0.00% 8.00% 3.24% 0 5,201 2,108 $ 3,093 4.76% Tip: Lowe's labels Net Income as "Net Eamings" Be sure to use Net Earnings in all calculations that use a Net Income amount. Basic Earnings per Common Share $4.09 $3.48 ** % columns may not add-un due to rounding Enter the amounts for Fiscal 2018 for the following income statement items. Then calculate and enter the Dollar Change and the % Change from Fiscal 2017 to Fiscal 2018. Enter the dollar amounts just as they are shown on the financial statement. Round the percentages to 2 decimal places. XX.XX% Tip: Most cells that require input have a cell format indicator above or below the cell. These format indicators show the type of number required for the cell. These format indicators do not show the size of the number expected for the cell. Click Here to Unlock Yellow Input Cells Fiscal 2018 Sxxx, XXX Dollar Change % Change 2017 to 2018 $xxx,xxx + Fiscal 2017 Dollar Change % Change 2016 to 2017 Fiscal 2016 Net Sales $68,619 $3,602 5.54 $65,017 For example: $XXX,Xxx shows that the input for the cell should be whole dollars with no decimal point. The $xxx,xxx does not indicate that the number should be a 6 digit number. The correct answer for the cell could be as small as 1 digit or as large as 14 digits. % % xx.xx% Sxxx XXX $xxx.xxx Cost of Sales $46,185 $43,343 $2,842 6.56 % Sxxx.xxx SXXX.XXX Gross Margin $22,434 $21,674 Tip: When entering a formula, be sure to begin the formula with an "=" sign. $760 3.51 % % XX.XX% Sxxx,xxx Sxxx XXX $14,444 $14,375 Selling, General and Administrative $69 0.48 % xx.xx% Sxxx,xxx $xxx xxx Pre-Tax Earnings $5,489 $288 5.54 $5,201 % XXXX% Sxxx, xxx Sxxx XXX Income Tax Provision $2,042 $2,108 ($66) (3.13) % % Xxxx% Sxxx XXX Net Earnings Net Earnings $3,447 $3,093 $354 11.45 % SXXX $XXXX $4.09 $3.48 Basic Earnings Per Share Fix Sx.xx Cell Format $0.61 17.53 % xx.xx%