How do you calculate the missing 3 boxes?

Lowo's - Fiscal 2020 Pg. 12 CAUTION Do NOT do a Cut operation on any cell in the project Equity Investor Indicators Use the information in Lowe's Consolidated Statements of Shareholders' Equity to calculate Lowe's Dividend Payout % Use the information at the bottom of Lowe's Consolidated Statements of Earnings and Lowe's Year-End Closing Market Price of 1 Common Share to calculate Lowe's Price-Earnings Ratio. Use the information in Lowe's Consolidated Statements of Shareholders' Equity and Lowo's Year-End Closing Market Price of 1 Common Share to calculate Lowe's Dividend Yield % Enter the financial statement dollar amounts just as they are shown on the financial statements Round the percentages to 2 decimal places. xx.xx% Fix and Xxx Round the decimal results to 2 decimal places. XX.XX Call Format Tip: When entering the names of the financial statement toms, use the Terminology that is used in Lowe's financial statements. These names will not be graded by the grading software 2020 2019 Dividend Payout % Total Dividend fox $1,724 Tip: Enter the cash didend amount as a positive number 29.55 38.61 % Net Earings $5,835 SXXXXX Tip: Be sure to use the Net Earnings amount shown in the Total Equity column. This amount should match the Not Earnings amount on the Consolidated Statements of Earnings Year End Closing Market Price of 1 Common Share The Year-End Closing Market Price of 1 share of Lowe's Common Stock is not given in Low's annual report. The Year-End Closing Market Price is used in the two calculations below. The last day in Lowo's 2020 fiscal year wes Friday, Jan 29, 2021. Lowe's common stock trades on the New York Stock Exchange (NYSE). On the NYSE, Lowe's year-end closing market price on Friday, Jan. 29, 2021 was $166.85. Enter that price in the box below. 2020 Year End Cloning Market Price of 1 Common Share: 2020 2019 (PE Ratio) Price-Earnings Ratio Market Price Share BE $166.85 mes 21.17 Balo camins per common share KLXX Dividend Yield Cath dividends per share 52.30 1.38% 1.83 Market Price Share 5166,85 Round the percentages to 2 decimal places. xx.xx% Round the decimal results to 2 decimal places. XX.XX Fix xxco and xxxx Cell Formats terminolog) financial sta not be grad 2020 2019 Dividend Payout % $xx, xox $1,724 Tip: Entert amount as a Total Dividend 38.61 % 29.55 1% Xxxx Net Earnings $5,835 $xx, xocx Tip: Be sure Earnings am Total Equity amount shou Earnings ams Consolidated Eamings Year-End Closing Market Price of 1 Common Share The Year-End Closing Market Price of 1 share of Lowe's Common Stock is not given in Lowe's annual report. The Year-End Closing Market Price is used in the two calculations below. The last day in Lowe's 2020 fiscal year was Friday, Jan. 29, 2021. Lowe's common stock trades on the New York Stock Exchange (NYSE). On the NYSE, Lowe's year-end closing market price on Friday, Jan 29, 2021 was $166.85. Enter that price in the box below. 2020 Year-End Closing Market Price of 1 Common Share: Sx 2020 2019 (PE Ratio) Price-Earnings Ratio Market Price Share Soc $166.85 times 21.17 XX.XX Basic earnings per common share Sco Dividend Yield % $2.30 Cash dividends per share 1.38 % 1.83 % Market Price Share $166.85 Soo Lowe's Companies, Inc. Consolidated Statements of Earnings (In millions, except per share and percentage data) Fiscal Years Ended January 29, 2021 January 31, 2020 February 1, 2019 Current Earnings Amount % Sales Amount % Sales Amount % Sales Net sales S 89,597 100,00 % S 72,148 100.00 % S 71,309100.00 % Cost of sales 60,025 66.99 49,205 68.20 48,401 67.88 Gross margin 29,572 33.01 22,943 31.80 22,908 32.12 Expenses: Selling, general and administrative 18,526 20.68 15,367 21.30 17,413 24.41 Depreciation and amortization 1,399 1.56 1,262 1.75 1,477 2.07 Operating income 9,647 10.77 6,314 8.75 4,018 5.64 Interest-net 848 0.95 691 0.96 624 0.88 Loss on extinguishment of debt 1,060 1.18 Pre-tax earnings 7,739 8.64 5,623 7.79 3,394 4.76 Income tax provision 1,904 2.13 1,342 1.86 1,080 1.52 Net earnings 5,835 6.51 % S 4,281 5.93% $ 2,314 3.24% Basic earnings per common share Diluted earnings per common share S 5 7.77 7.75 S S 5.49 5.49 s S 2.84 2.84 Lowe's Companies, Inc. Consolidated Statements of Comprehensive Income (In millions, except percentage data) Fiscal Year Ended January 29, 2021 January 31, 2020 February 1, 2019 Amount % Sales Amount % Sales Amount % Sales Net earnings 5,835 6.51 % 5 4,281 5.93 % 5 2314 3.24% Foreign currency translation adjustments - net of tax 78 0.09 94 0.13 (221) (0.30) Cash flow hedges - net of tax (79) (0.09) (22) (0.03) (1) Other 1 1 2 Other comprehensive Income (loss) 73 0.10 (220) (0.30) Comprehensive income S 5,835 6.51 % S 4,354 6,03 % 2,094 2.9496 See accompanying notes to consolidated financial statementy. Lowe's Companies, Inc. Consolidated Balance Sheets (In millions, except par value) January 29, 2021 January 31, 2020 4,690 S 506 16,193 937 22,326 19.155 3,832 200 340 882 46.7355 716 160 13,179 1.263 15,318 18,769 3,891 372 216 905 39.471 s 1,112 541 Assets Current assets: Cash and cash equivalents Short-term investments Merchandise inventory-net Other current assets Total current assets Property, less accumulated depreciation Operating lease right-of-use assets Long-term investments Deferred income taxes -- net Other assets Total assets Liabilities and shareholders' equity Current liabilities: Short-term borrowings Current maturities of long-term debt Current operating lease liabilities Accounts payable Accrued compensation and employee benefits Deferred revenue Other current liabilities Total current liabilities Long-term deht, excluding current maturities Noncurrent operating lease liabilities Deferred revenue-extended protection plans Other liabilities Total liabilities Commitments and contingencies Shareholders' equity Preferred stock-$5 par value: Authorized - 5.0 million shares Issued and outstanding-hope Common stock -50.50 par value: Authorized - 5,6 billion shares Issued and outstanding - 731 million and 763 million respectively Capital in excess of par value Retained coming Accumulated other comprehensive loss Total shareholders' equity Total liabilities and shareholders' equity See accompanying notes to consolidated financialnements 10,884 1,350 1,608 235 18,730 20,668 3.890 1,019 991 45,298 1941 597 501 7.659 684 1,219 2.581 15,182 16,768 3,943 894 712 37.499 381 366 90 1.117 (136) 1,437 46.7355 1.727 (136) 1,972 39.471 Lowe's Companies, Inc. Consolidated Statements of Shareholders' Equity (In millions, except per share data) Accumulated Other Capital in Total Common Stock Excess Retained Comprehensive Shareholders' Shares Amount of Par Value Earnings Income/(Loss) Equity Balance February 2, 2018 8305 4155 225 5,4255 11 5,873 Cumulative effect of accounting change 33 33 Net earnings 2,314 2,314 Other comprehensive loss (220) (220) Cash dividends declared, S1,85 per share (1.500) (1.500) Share-based payment expense 74 74 Repurchases of common stock (32 (16) (209) (2,820) (3,045) Issuance of common stock under sharc- based payment plans 3 113 115 Balance February 1, 2019 8015 4015 - 5 3,4525 (209) 3,644 Cumulative effect of accounting change (263) (263) Net earnings 4,281 4.281 Other comprehensive income 73 73 Cash dividends declared, $2.13 per share (1.653) (1.633) Share-based payment expense 98 98 Reparchases of common stock (41) (21) (214) (4,090) (4,325) Issuance of common stock under share based payment plans 116 117 Balance January 31, 2020 763 S 3815 $ 1.727's (136) Net coming 1,972 5.835 Cash dividends declared, $2.30 per share 5,835 (1.724) Share-based payment expense (1.724 135 155 Repurchases of common stock (34 (16) (214) Issuance of common stock under share (4.721) (4.951) based payment plans 2 1 149 Balance January 29, 2021 150 7315 3665 90 5 1.117 5 See accompanying notes to consolidated financial statements (136) 1.437 le - III III Lowe's Companies, Inc. Consolidated Statements of Cash Flows (In millions Fiscal Years Ended January 29, January 31, February 1, 2021 2020 2019 S 5,835 S 4,281 S 2,314 1,410 1,607 468 1.594 479 (108) 139 127 117 (151) 630 952 1,060 155 98 74 (2.967) 326 3,211 512 813 11,049 (600) (364) (637) (15) (639) 4.296 (1,289) (101) 1.720 23 414 6,193 Cash flows from operating activities: Net earnings Adjustments to reconcile net earings to net cash provided by operating activities Depreciation and amortization Noncash lease expense Deferred income taxes Loss on property and other assets-net Impairment of goodwill Loss on extinguishment of debt Share-based payment expense Changes in operating assets and liabilities: Merchandise inventory - Det Other operating assets Accounts payable Deferred revenue Other operating liabilities Net cash provided by operating activities Cash flows from Investing netivities: Purchases of investments Proceeds from sale/maturity of inveutments Capital expenditures Proceeds from sale of property and other long-term assets Othernet Net cash used in investing activities Cash flows from financing activities: Net change in commercial paper Net proceeds from issuance of debt Repayment of debt Proceeds from issuance of common steek under share-based payment plans Cash dividend payments Repurchases of common stock Othernet Netcash used in flancing activities Effect of exchange rate changes on cash Net increase decrease in cash and cash equivalents, including cash classified within cum ut held for sale Less: Net decrease increase in cash classified within current assets beld for sale Net increase (decrease in cash and cash equivalente Cash and cash equivalents, beginning of your Cash and cash equivalents, end of year See accompanying notes to consolidated financial statements (3.094) 2,926 (1.791) 90 (25) (1,894) (743) 695 (1,484 161 (1,373) 1,393 (1.174) 76 (2) (1,080) (1,369) (415) (941) 7.929 (5.618) 152 (1,704) (4.971) (38) (5.191) 10 220 3,972 (1,113) LIS (1.618) (4,313) (1) (2.735) 1 (326) 114 (1,455) 03.037) (5) (5.124) 3.974 3,974 716 4.6.90$ 193 12 205 511 716 5 (23) (54) (7) 588 $11 S