Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the following ratios for Lowe's: 1. Quarterly Revenue Growth; 2. Quarterly Earnings Growth, 3. Profit Margin 4. Debts/Assets Ratio, 5. Return on Equity (ROE)

Calculate the following ratios for Lowe's: 1. Quarterly Revenue Growth; 2. Quarterly Earnings Growth, 3. Profit Margin 4. Debts/Assets Ratio, 5. Return on Equity (ROE) 6. Earnings per Share (EPS) and 7. Price Earnings Ratio (P/E).

image text in transcribed

Lowe's Companies, Inc. Consolidated Statements of Current and Retained Earnings (Unaudited) In Millions, Except Per Share and Percentage Data Three Months Ended Six Months Ended July 31, 2020 August 2, 2019 July 31, 2020 August 2, 2019 Amount % Sales Amount % Sales Amount % Sales Amount % Sales $ 27,302 100.00 $ 20,992 100.00 $ 46,977 100.00 $ 38,733 100.00 17,998 65.92 14,252 67.89 31,161 66.33 26,412 68.19 9,304 34.08 6,740 32.11 15,816 33.67 12.321 31.81 5,020 327 3,957 219 3,738 910 $ 2,828 18.39 4,048 1.20 311 14.49 2.381 0.80 169 13.69 2,212 3.33 536 10.36 $ 1,676 19.29 9.215 1.48 653 11.34 5.948 0.80 423 10.54 5,525 2.56 1.360 7.98 $ 4,165 19.62 7,909 1.39 614 12.66 3,798 0.90 331 11.76 3,467 2.89 745 8.87 $ 2,722 20.42 1.58 9.81 0.86 8.95 1.92 7.03 Current Earnings Net sales Cost of sales Gross margin Expenses: Selling, general and administrative Depreciation and amortization Operating income Interest - net Pre-tax earnings Income tax provision Net earnings Weighted average common shares outstanding basic Basic earnings per common share (1) Weighted average common shares outstanding -diluted Diluted earnings per common share (1) Cash dividends per share Retained Earnings Balance at beginning of period Cumulative effect of accounting change Net earnings Cash dividends declared Share repurchases Balance at end of period 754 752 3.74 781 2.14 788 3.44 $ $ $ 5.50 $ $ 753 3.74 0.55 S 781 2.14 0.55 $ 755 5.50 1.10 789 $ 3.44 S 1.03 S S S $ 1,722 $ 3,095 $ 1,727 2.828 (416) 1,676 (428) (1,904) $ 2,439 4,165 (831) (927) $ 4,134 $ 3,452 (263) 2,722 (810) (2,662) $ 2.439 $ 4,134 Under the two-class method, earnings per share is calculated using net earnings allocable to common shares, which is derived by reducing net earnings by the earnings allocable to participating securities. Net earnings allocable to common shares used in the basic and diluted earnings per share calculation were $2,816 million for the three months ended July 31, 2020 and $1,670 million for the three months ended August 2, 2019. Net earnings allocable to common shares used in the basic and diluted earnings per share calculation were $4,149 million for the six months ended July 31, 2020 and $2,713 million for the six months ended August 2, 2019. Lowe's Companies, Inc. Consolidated Statements of Current and Retained Earnings (Unaudited) In Millions. Except Per Share and Percentage Data 65.92 67.89 Three Months Ended Six Months Ended July 31, 2020 August 2, 2019 July 31, 2020 August 2, 2019 Current Earnings Amount % Sales Amount % Sales Amount % Sales Amount % Sales Net sales $ 27,302 100.00 $ 20,992 100.00 $ 46,977 100.00 $ 38,733 100.00 Cost of sales 17.998 14.252 31,161 66.33 26,412 68.19 Gross margin 9,304 34.08 6,740 32.11 15,816 33.67 12,321 31.81 Expenses Selling, general and administrative 5,020 18.39 4,048 19.29 9.215 19.62 7.909 20.42 Depreciation and amortization 327 1.20 311 1.48 653 1.39 614 1.58 Operating income 3,957 14.49 2,381 11.34 5,948 12.66 3,798 9.81 Interest-net 219 0.80 169 0.80 423 0.90 331 0.86 Pre-tax earnings 3,738 13.69 2,212 10.54 5,525 11.76 3,467 8.95 Income tax provision 910 3.33 536 2.56 1,360 2.89 745 1.92 Net earnings $ 2.828 10.36 $ 1,676 7.98 $ 4,165 8.87 $ 2,722 7.03 Weighted average common shares outstanding basic 752 781 754 788 Basic earnings per common share) $ 3.74 $ 2.14 5.50 3.44 Weighted average common shares outstanding diluted 753 781 755 789 Diluted earnings per common share (1) $ 3.74 $ 2.14 5.50 $ 3.44 Cash dividends per share S 0.55 S 0.55 $ 1.10 $ 1.03 Retained Earnings Balance at beginning of period $ 1,722 $ 3,095 $ 1,727 $ 3,452 Cumulative effect of accounting change (263) Net earnings 2,828 1,676 4,165 2,722 Cash dividends declared (428) (831) (810) Share repurchases (1,904) (927) (2,662) Balance at end of period $ 4,134 $ 2,439 $ 4,134 $ 2,439 Under the two-class method, eamings per share is calculated using net earnings allocable to common shares, which is derived by reducing net earnings by the earnings allocable to participating securities. Net earnings allocable to common shares used in the basic and diluted earnings per share calculation were $2,816 million for the three months ended July 31, 2020 and $1,670 million for the three months ended August 2, 2019. Net eamings allocable to common shares used in the basic and diluted earnings per share calculation were $4,149 million for the six months ended July 31, 2020 and $2,713 million for the six months ended August 2, 2019. Lowe's Companies, Inc. Consolidated Statements of Current and Retained Earnings (Unaudited) In Millions, Except Per Share and Percentage Data (416) Three Months Ended Six Months Ended July 31, 2020 August 2, 2019 July 31, 2020 August 2, 2019 Current Earnings Amount % Sales Amount % Sales Amount % Sales Amount % Sales Net sales $ 27,302 100.00 $ 20,992 100.00 $ 46,977 100.00 $ 38,733 100.00 Cost of sales 17,998 65.92 14,252 67.89 31,161 66.33 26,412 68.19 Gross margin 9,304 34.08 6,740 32.11 15,816 33.67 12,321 31.81 Expenses: Selling, general and administrative 5,020 18.39 4,048 19.29 9.215 19.62 7,909 20.42 Depreciation and amortization 327 1.20 311 1.48 653 1.39 614 1.58 Operating income 3,957 14.49 2,381 11.34 5,948 12.66 3,798 9.81 Interest - net 219 0.80 169 0.80 423 0.90 331 0.86 Pre-tax earnings 3,738 13.69 2.212 10.54 5,525 11.76 3,467 8.95 Income tax provision 910 3.33 536 2.56 1,360 2.89 745 1.92 Net earnings $ 2,828 10.36 $ 1,676 7.98 $ 4,165 8.87 $ 2,722 7.03 Weighted average common shares outstanding basic 752 781 754 788 Basic earnings per common share (1) S 3.74 $ 2.14 $ 5.50 $ 3.44 Weighted average common shares outstanding diluted 753 781 755 789 Diluted earnings per common share (1) S 3.74 S 2.14 $ 5.50 S 3.44 Cash dividends per share S 0.55 $ 0.55 $ 1.10 $ 1.03 Retained Earnings Balance at beginning of period $ 1,722 $ 3,095 $ 1,727 $ 3,452 Cumulative effect of accounting change (263) Net earnings 2,828 1,676 4,165 2,722 Cash dividends declared (416) (428) (831) (810) Share repurchases (1,904) (927) (2,662) Balance at end of period $ 4,134 $ 2,439 $ 4,134 $ 2,439 Under the two-class method, earnings per share is calculated using net earnings allocable to common shares, which is derived by reducing net earnings by the eamings allocable to participating securities. Net earnings allocable to common shares used in the basic and diluted eamings per share calculation were $2,816 million for the three months ended July 31, 2020 and $1,670 million for the three months ended August 2, 2019. Net earnings allocable to common shares used in the basic and diluted earnings per share calculation were $4,149 million for the six months ended July 31, 2020 and $2.713 million for the six months ended August 2, 2019. Lowe's Companies, Inc. Consolidated Statements of Cash Flows (Unaudited) In Millions Six Months Ended July 31, 2020 August 2, 2019 $ 4,165 $ 2,722 747 234 (14) Cash flows from operating activities: Net earnings Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization Noncash lease expense Deferred income taxes Loss on property and other assets net Share-based payment expense Changes in operating assets and liabilities: Merchandise inventory - net Other operating assets Accounts payable Other operating liabilities Net cash provided by operating activities 684 228 (121) 38 51 80 64 (674) 66 5,259 1,825 11,752 (1,153) (104) 1,202 36 3,583 Cash flows from investing activities: Purchases of investments Proceeds from sale/maturity of investments Capital expenditures Proceeds from sale of property and other long-term assets Other - net Net cash used in investing activities (1,132) 260 (710) 46 (24) (1,560) (245) 272 (526) 42 (1) (458) Cash flows from financing activities: Net change in commercial paper Net proceeds from issuance of debt Repayment of long-term debt Proceeds from issuance of common stock under share-based payment plans Cash dividend payments Repurchase of common stock Other - net Net cash provided by (used in) financing activities (941) 3,961 (568) 83 (836) (966) (4) 729 (722) 2.972 (629) 72 (767) (2,770) (7) (1,851) Effect of exchange rate changes on cash 4 (1) 10.925 1,273 Net increase in cash and cash equivalents, including cash classified within current assets held for sale Less: Net decrease in cash classified within current assets held for sale Net increase in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, end of period 10,925 716 11,641 $ 12 1,285 511 1,796 $ Lowe's Companies, Inc. Non-GAAP Financial Measures Reconciliation (Unaudited) To provide additional transparency, the Company has presented the non-GAAP financial measure of adjusted diluted earnings per share for comparing its operating performance for the three months ended July 31, 2020, with the respective period ended August 2, 2019. This measure excludes the impact of certain discrete items, as further described below, not contemplated in Lowe's Original Business Outlook to assist analysts and investors in understanding operational performance for the second quarter of fiscal 2020 and fiscal 2019 Fiscal 2020 Impacts For fiscal 2020, the Company has recognized financial impacts from the following discrete item, not contemplated in the Company's Original Business Outlook for the second quarter of fiscal 2020: Beginning in the third quarter of fiscal 2019, the Company began a strategic review of its Canadian operations, and in the fourth quarter of fiscal 2019, the Company announced additional actions to improve future performance and profitability of its Canadian operations. As a result of this review and related actions, in the second quarter of fiscal 2020, the Company recognized $10 million of pre-tax operating costs related to remaining inventory write-downs and store closing costs (Canada restructuring) Fiscal 2019 Impacts During fiscal 2019, the Company recognized financial impacts from the following discrete item, not contemplated in the Company's Business Outlook for the second quarter of fiscal 2019: Prior to the beginning of fiscal 2019, the Company announced its intention to exit its Mexico retail operations and had planned to sell the operating business. During the three months ended August 2, 2019, the Company recognized a net loss of $12 million in pre-tax operating losses associated with the exit and ongoing wind-down of the Mexico retail operations (Mexico adjustments). Adjusted diluted earnings per share should not be considered an alternative to, or more meaningful indicator of the Company's diluted earnings per share as prepared in accordance with GAAP. The Company's methods of determining non-GAAP financial measures may differ from the method used by other companies and may not be comparable. Detailed reconciliations between the Company's GAAP and non- GAAP financial results are shown below and available on the Company's website at www.lowes.com/investor. Three Months Ended (Unaudited) July 31, 2020 Pre-Tax Earnings (Unaudited) August 2, 2019 Net Pre-Tax Net Earnings Earnings Tax Earnings $ 3.74 2.14 Tax (in millions, except per share data) Diluted earnings per share, as reported Non-GAAP adjustments - per share impacts Canada restructuring Mexico adjustments Adjusted diluted earnings per share 0.01 0.01 0.02 (0.01) 0.01 2.15 S 3.75 $ Lowe's Companies, Inc. Consolidated Statements of Current and Retained Earnings (Unaudited) In Millions, Except Per Share and Percentage Data Three Months Ended Six Months Ended July 31, 2020 August 2, 2019 July 31, 2020 August 2, 2019 Amount % Sales Amount % Sales Amount % Sales Amount % Sales $ 27,302 100.00 $ 20,992 100.00 $ 46,977 100.00 $ 38,733 100.00 17,998 65.92 14,252 67.89 31,161 66.33 26,412 68.19 9,304 34.08 6,740 32.11 15,816 33.67 12.321 31.81 5,020 327 3,957 219 3,738 910 $ 2,828 18.39 4,048 1.20 311 14.49 2.381 0.80 169 13.69 2,212 3.33 536 10.36 $ 1,676 19.29 9.215 1.48 653 11.34 5.948 0.80 423 10.54 5,525 2.56 1.360 7.98 $ 4,165 19.62 7,909 1.39 614 12.66 3,798 0.90 331 11.76 3,467 2.89 745 8.87 $ 2,722 20.42 1.58 9.81 0.86 8.95 1.92 7.03 Current Earnings Net sales Cost of sales Gross margin Expenses: Selling, general and administrative Depreciation and amortization Operating income Interest - net Pre-tax earnings Income tax provision Net earnings Weighted average common shares outstanding basic Basic earnings per common share (1) Weighted average common shares outstanding -diluted Diluted earnings per common share (1) Cash dividends per share Retained Earnings Balance at beginning of period Cumulative effect of accounting change Net earnings Cash dividends declared Share repurchases Balance at end of period 754 752 3.74 781 2.14 788 3.44 $ $ $ 5.50 $ $ 753 3.74 0.55 S 781 2.14 0.55 $ 755 5.50 1.10 789 $ 3.44 S 1.03 S S S $ 1,722 $ 3,095 $ 1,727 2.828 (416) 1,676 (428) (1,904) $ 2,439 4,165 (831) (927) $ 4,134 $ 3,452 (263) 2,722 (810) (2,662) $ 2.439 $ 4,134 Under the two-class method, earnings per share is calculated using net earnings allocable to common shares, which is derived by reducing net earnings by the earnings allocable to participating securities. Net earnings allocable to common shares used in the basic and diluted earnings per share calculation were $2,816 million for the three months ended July 31, 2020 and $1,670 million for the three months ended August 2, 2019. Net earnings allocable to common shares used in the basic and diluted earnings per share calculation were $4,149 million for the six months ended July 31, 2020 and $2,713 million for the six months ended August 2, 2019. Lowe's Companies, Inc. Consolidated Statements of Current and Retained Earnings (Unaudited) In Millions. Except Per Share and Percentage Data 65.92 67.89 Three Months Ended Six Months Ended July 31, 2020 August 2, 2019 July 31, 2020 August 2, 2019 Current Earnings Amount % Sales Amount % Sales Amount % Sales Amount % Sales Net sales $ 27,302 100.00 $ 20,992 100.00 $ 46,977 100.00 $ 38,733 100.00 Cost of sales 17.998 14.252 31,161 66.33 26,412 68.19 Gross margin 9,304 34.08 6,740 32.11 15,816 33.67 12,321 31.81 Expenses Selling, general and administrative 5,020 18.39 4,048 19.29 9.215 19.62 7.909 20.42 Depreciation and amortization 327 1.20 311 1.48 653 1.39 614 1.58 Operating income 3,957 14.49 2,381 11.34 5,948 12.66 3,798 9.81 Interest-net 219 0.80 169 0.80 423 0.90 331 0.86 Pre-tax earnings 3,738 13.69 2,212 10.54 5,525 11.76 3,467 8.95 Income tax provision 910 3.33 536 2.56 1,360 2.89 745 1.92 Net earnings $ 2.828 10.36 $ 1,676 7.98 $ 4,165 8.87 $ 2,722 7.03 Weighted average common shares outstanding basic 752 781 754 788 Basic earnings per common share) $ 3.74 $ 2.14 5.50 3.44 Weighted average common shares outstanding diluted 753 781 755 789 Diluted earnings per common share (1) $ 3.74 $ 2.14 5.50 $ 3.44 Cash dividends per share S 0.55 S 0.55 $ 1.10 $ 1.03 Retained Earnings Balance at beginning of period $ 1,722 $ 3,095 $ 1,727 $ 3,452 Cumulative effect of accounting change (263) Net earnings 2,828 1,676 4,165 2,722 Cash dividends declared (428) (831) (810) Share repurchases (1,904) (927) (2,662) Balance at end of period $ 4,134 $ 2,439 $ 4,134 $ 2,439 Under the two-class method, eamings per share is calculated using net earnings allocable to common shares, which is derived by reducing net earnings by the earnings allocable to participating securities. Net earnings allocable to common shares used in the basic and diluted earnings per share calculation were $2,816 million for the three months ended July 31, 2020 and $1,670 million for the three months ended August 2, 2019. Net eamings allocable to common shares used in the basic and diluted earnings per share calculation were $4,149 million for the six months ended July 31, 2020 and $2,713 million for the six months ended August 2, 2019. Lowe's Companies, Inc. Consolidated Statements of Current and Retained Earnings (Unaudited) In Millions, Except Per Share and Percentage Data (416) Three Months Ended Six Months Ended July 31, 2020 August 2, 2019 July 31, 2020 August 2, 2019 Current Earnings Amount % Sales Amount % Sales Amount % Sales Amount % Sales Net sales $ 27,302 100.00 $ 20,992 100.00 $ 46,977 100.00 $ 38,733 100.00 Cost of sales 17,998 65.92 14,252 67.89 31,161 66.33 26,412 68.19 Gross margin 9,304 34.08 6,740 32.11 15,816 33.67 12,321 31.81 Expenses: Selling, general and administrative 5,020 18.39 4,048 19.29 9.215 19.62 7,909 20.42 Depreciation and amortization 327 1.20 311 1.48 653 1.39 614 1.58 Operating income 3,957 14.49 2,381 11.34 5,948 12.66 3,798 9.81 Interest - net 219 0.80 169 0.80 423 0.90 331 0.86 Pre-tax earnings 3,738 13.69 2.212 10.54 5,525 11.76 3,467 8.95 Income tax provision 910 3.33 536 2.56 1,360 2.89 745 1.92 Net earnings $ 2,828 10.36 $ 1,676 7.98 $ 4,165 8.87 $ 2,722 7.03 Weighted average common shares outstanding basic 752 781 754 788 Basic earnings per common share (1) S 3.74 $ 2.14 $ 5.50 $ 3.44 Weighted average common shares outstanding diluted 753 781 755 789 Diluted earnings per common share (1) S 3.74 S 2.14 $ 5.50 S 3.44 Cash dividends per share S 0.55 $ 0.55 $ 1.10 $ 1.03 Retained Earnings Balance at beginning of period $ 1,722 $ 3,095 $ 1,727 $ 3,452 Cumulative effect of accounting change (263) Net earnings 2,828 1,676 4,165 2,722 Cash dividends declared (416) (428) (831) (810) Share repurchases (1,904) (927) (2,662) Balance at end of period $ 4,134 $ 2,439 $ 4,134 $ 2,439 Under the two-class method, earnings per share is calculated using net earnings allocable to common shares, which is derived by reducing net earnings by the eamings allocable to participating securities. Net earnings allocable to common shares used in the basic and diluted eamings per share calculation were $2,816 million for the three months ended July 31, 2020 and $1,670 million for the three months ended August 2, 2019. Net earnings allocable to common shares used in the basic and diluted earnings per share calculation were $4,149 million for the six months ended July 31, 2020 and $2.713 million for the six months ended August 2, 2019. Lowe's Companies, Inc. Consolidated Statements of Cash Flows (Unaudited) In Millions Six Months Ended July 31, 2020 August 2, 2019 $ 4,165 $ 2,722 747 234 (14) Cash flows from operating activities: Net earnings Adjustments to reconcile net earnings to net cash provided by operating activities: Depreciation and amortization Noncash lease expense Deferred income taxes Loss on property and other assets net Share-based payment expense Changes in operating assets and liabilities: Merchandise inventory - net Other operating assets Accounts payable Other operating liabilities Net cash provided by operating activities 684 228 (121) 38 51 80 64 (674) 66 5,259 1,825 11,752 (1,153) (104) 1,202 36 3,583 Cash flows from investing activities: Purchases of investments Proceeds from sale/maturity of investments Capital expenditures Proceeds from sale of property and other long-term assets Other - net Net cash used in investing activities (1,132) 260 (710) 46 (24) (1,560) (245) 272 (526) 42 (1) (458) Cash flows from financing activities: Net change in commercial paper Net proceeds from issuance of debt Repayment of long-term debt Proceeds from issuance of common stock under share-based payment plans Cash dividend payments Repurchase of common stock Other - net Net cash provided by (used in) financing activities (941) 3,961 (568) 83 (836) (966) (4) 729 (722) 2.972 (629) 72 (767) (2,770) (7) (1,851) Effect of exchange rate changes on cash 4 (1) 10.925 1,273 Net increase in cash and cash equivalents, including cash classified within current assets held for sale Less: Net decrease in cash classified within current assets held for sale Net increase in cash and cash equivalents Cash and cash equivalents, beginning of period Cash and cash equivalents, end of period 10,925 716 11,641 $ 12 1,285 511 1,796 $ Lowe's Companies, Inc. Non-GAAP Financial Measures Reconciliation (Unaudited) To provide additional transparency, the Company has presented the non-GAAP financial measure of adjusted diluted earnings per share for comparing its operating performance for the three months ended July 31, 2020, with the respective period ended August 2, 2019. This measure excludes the impact of certain discrete items, as further described below, not contemplated in Lowe's Original Business Outlook to assist analysts and investors in understanding operational performance for the second quarter of fiscal 2020 and fiscal 2019 Fiscal 2020 Impacts For fiscal 2020, the Company has recognized financial impacts from the following discrete item, not contemplated in the Company's Original Business Outlook for the second quarter of fiscal 2020: Beginning in the third quarter of fiscal 2019, the Company began a strategic review of its Canadian operations, and in the fourth quarter of fiscal 2019, the Company announced additional actions to improve future performance and profitability of its Canadian operations. As a result of this review and related actions, in the second quarter of fiscal 2020, the Company recognized $10 million of pre-tax operating costs related to remaining inventory write-downs and store closing costs (Canada restructuring) Fiscal 2019 Impacts During fiscal 2019, the Company recognized financial impacts from the following discrete item, not contemplated in the Company's Business Outlook for the second quarter of fiscal 2019: Prior to the beginning of fiscal 2019, the Company announced its intention to exit its Mexico retail operations and had planned to sell the operating business. During the three months ended August 2, 2019, the Company recognized a net loss of $12 million in pre-tax operating losses associated with the exit and ongoing wind-down of the Mexico retail operations (Mexico adjustments). Adjusted diluted earnings per share should not be considered an alternative to, or more meaningful indicator of the Company's diluted earnings per share as prepared in accordance with GAAP. The Company's methods of determining non-GAAP financial measures may differ from the method used by other companies and may not be comparable. Detailed reconciliations between the Company's GAAP and non- GAAP financial results are shown below and available on the Company's website at www.lowes.com/investor. Three Months Ended (Unaudited) July 31, 2020 Pre-Tax Earnings (Unaudited) August 2, 2019 Net Pre-Tax Net Earnings Earnings Tax Earnings $ 3.74 2.14 Tax (in millions, except per share data) Diluted earnings per share, as reported Non-GAAP adjustments - per share impacts Canada restructuring Mexico adjustments Adjusted diluted earnings per share 0.01 0.01 0.02 (0.01) 0.01 2.15 S 3.75 $

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

Focus On Personal Finance

Authors: Jack Kapoor, Les Dlabay, Robert Hughes, Melissa Hart

6th Edition

125991965X, 978-1259919657

More Books

Students also viewed these Finance questions

Question

4. Give examples of five potential appraisal problems.

Answered: 1 week ago

Question

6. Explain how to install a performance management program.

Answered: 1 week ago