90.2K

Verified Solution

Link Copied!

what is the current ratio? (1:1)

what is the debt ratio? (%)

please show work

1. What is the current ratio? (1:1) 2. What is the debt ratio? (%) *Income Statement Income Statement Balance SheetCash Flow Statement Annual Financials Quarter Financials Quarterly Financials for Lowe's Cos. View Ratios All values USD millions. 31-Oct- 2018 31-Jan- 2019 30-Apr- 2019 31-Jul- 2019 31-Oct- 2019 5-qtr trend Sales/Revenue 17.42B 15.65B 17.74B 20.99B 7.39B Cost of Goods Sold (COGS) incl. D&A 12.19B 11.12B 12.46B 14.56B 12.06B COGS excluding D&A 11.73B 10.72B 12.13B 14.22B 11.71B Depreciation & Amortization Expense 455M 401M 337M 347M 345M Depreciation Amortization of Intangibles Gross Income 5.23B 4.53B 5.28B 6.43B 5.33B 31-Oct- 2018 31-Jan- 30-Apr- 2019 31-Jul- 31-Oct- 2019 2019 5-qtr trend SG&A Expense 3.99B 3.52B 3.86B 4.05B 3.77B Research & Development Other SG&A 3.99B 3.52B 3.86B 4.05B 3.77B Other Operating Expense Unusual Expense 280M 1.58B EBIT after Unusual Expense (280M) (1.58B) Non Operating Income/Expense (3M) (1M) (4M) Non-Operating Interest Income 9M 7M 7M 12M 5M Equity in Affiliates (Pretax) Interest Expense 162M 161M 169M 180M 178M Gross Interest Expense 162M 162M 169M 180M 178M Interest Capitalized IM Pretax Income 804M (725M) 1.26B 2.21B 1.38B Income Tax 175M 99M 209M 536M 332M Income Tax - Current Domestic Income Tax - Current Foreign Income Tax - Deferred Domestic Income Tax - Deferred Foreign Income Tax Credits Equity in Affiliates Other After Tax Income (Expense) (1M) 3M (821M) (3M) (6M) 1.04B 1.67B (3M) 1.05B Consolidated Net Income 628M Minority Interest Expense Net Income 628M (821M) 1.043 1.67B 1.05B Extraordinaries & Discontinued Operations Minority Interest Expense Net Income 628M (821M) 1.04B 1.67B 1.05B Extraordinaries & Discontinued Operations Extra Items & Gain/Loss Sale Of Assets Cumulative Effect - Accounting Che Discontinued Operations Net Income After Extraordinaries 628M (821M) 1.043 1.67B 1.05B Preferred Dividends Net Income Available to Common 628M (821M) 1.043 1.67B 1.05B EPS (Basic) 0.78 (1.03) 1.31 2.14 1.36 Basic Shares Outstanding 806M 801M 796M 781M 769M EPS (Diluted) 0.78 (1.03) 1.31 2.14 1.36 Diluted Shares Outstanding 807M 801M 797M 781M 770M EBITDA 1.69B 1.41B 1.750 2.73B 1.9B *Balance Sheet Assets All values USD millions. 31-Oct- 31-Jan-30-Apr- 31-Jul- 2018 2019 2019 2019 31-Oct- 2019 Cash & Short Term Investments 1.88B 729M 729M 3.16B 3.16B 2.07B 2.078 921M Cash Only 1.67B 511M 2.97B 1.8B 794M Short-Term Investments Total Accounts Receivable Accounts Receivables, Net Accounts Receivables, Gross Bad Debt/Doubtful Accounts Other Receivables Inventories 12.37B 12.56B 15.03B 13.73B 13.72B Finished Goods 12.37B 12.56B 15.03B 13.73B 13.72B Work in Progress Raw Materials Progress Payments & Other Other Current Assets 897M 938M 1.15B 995M 1.03B Miscellaneous Current Assets 897M 938M 1.15B 995M 1.03B Total Current Assets 15.14B 14.23B 19.34B 16.8B 15.66B 31-Oct- 2018 31-Jan- 2019 30-Apr- 2019 31-Jul- 2019 31-Oct- 2019 tren Net Property, Plant & Equipment 18.43B 22.08B 22.17B 22.24B Property, Plant & Equipment - Gross 36.62B 35.86B 39.38B 39.54B Buildings Land & Improvements Computer Software and Equipment Other Property, Plant & Equipment Accumulated Depreciation 17.7B 17.43B 17.3B 17.30 Total Investments and Advances 290M 256M 235M 179M 363M Other Long-Term Investments 290M 256M 235M 179M 363M Long-Term Note Receivable Intangible Assets 1.27B 303M 303M 303M 303M Net Goodwill 1.27B 303M 303M 303M 303M Net Other Intangibles Other Assets 805M 995M 775M 735M 713M Tangible Other Assets 805M 995M 713M 775M 43.22B 735M 40.7B Total Assets 36.71B 34.64B 39.76B Liabilities & Shareholders' Equity 31-Oct- 2018 31-Jan- 2019 30-Apr- 2019 31-Jul- 2019 31-Oct-5- 2019 ST Debt & Current Portion LT Debt 1.12B 1.83B 1.510 1.5B 1.71B 1.14B Short Term Debt 722M 500M 492M Current Portion of Long Term Debt 11.12B 1.11B 1.013 1.013 574M Accounts Payable 9.28B 8.28B 11.49B 9.5B 8.82B Income Tax Payable 179M Other Current Liabilities 4.67B 4.21B 4.79B 4.84B 4.53B Dividends Payable Accrued Payroll 806M 662M 769M 717M 779M Miscellaneous Current Liabilities 3.86B 3.16B 4.02B 4.12B 3.75B Total Current Liabilities 15.07B 14.50 17.78B 15.84B 15.06B Long-Term Debt 14.46B 14.39B 20.61B 20.59B 20.58B Long-Term Debt excl. Capitalized Leases 14.46B 13.68B 16.54B 16.16B 16.15B Non-Convertible Debt Convertible Debt Capitalized Lease Obligations 709M 382M 481M Provision for Risks & Charges Deferred Taxes (285M) (294M) (495M) (512M) (479M) Deferred Taxes - Credit 133M Deferred Taxes - Debit 285M 427M 495M 512M 479M Other Liabilities 1.79B 1.98B 1.6B 1.63B 1.67B Other Liabilities (excl. Deferred Income) 963M 1.15B 759M 759M 791M Deferred Income 827M 827M 837M 868M 875M Total Liabilities 31.32B 31B 39.98B 38.06B 37.31B Non-Equity Reserves Preferred Stock (Carrying Value) Deferred Taxes - Debit 285M 427M 495M 512M 479M Other Liabilities 1.79B 1.98B 1.6B 1.63B 1.67B Other Liabilities (excl. Deferred Income) 963M 1.15B 759M 759M 791M Deferred Income 827M 827M 837M 868M 875M Total Liabilities 3132B 31B 39.98B 38.06B 3731B Non-Equity Reserves Preferred Stock (Carrying Value) Redeemable Preferred Stock Non-Redeemable Preferred Stock Common Equity (Total) 5.39B 3.64B 3.24B 2.64B 2.46B Common Stock Par/Carry Value 403M 401M 384M 397M 3.13 388M 2.44B Retained Earnings 5.16B 3.45B 2.24B ESOP Debt Guarantee Cumulative Translation Adjustment/Unrealized For. Exch. Gain (165M) (209M) (256M) (187M) (164M) Unrealized Gain/Loss Marketable Securities Revaluation Reserves Treasury Stock Total Shareholders' Equity 5.39B 3.64B 3.24B 2.643 2.46B Accumulated Minority Interest Total Equity 5.39B 3.64B 3.24B 2.648 2.46B Liabilities & Shareholders' Equity 36.71B 34.64B 43.221 40.73 39.76B

Answer & Explanation Solved by verified expert

See Answer