Lowe's Companies, Inc. |
Dollar amounts in Millions |
|
Common-Size Balance Sheets |
Feb. 01, 2019 |
Feb. 02, 2018 |
Current assets: |
||
Cash and cash equivalents |
$ 511 |
$ 588 |
Short-term investments |
218 |
102 |
Merchandise inventory - net |
12,561 |
11,393 |
Other current assets |
938 |
689 |
Total current assets |
14,228 |
12,772 |
Property, less accumulated depreciation |
18,432 |
19,721 |
Long-term investments |
256 |
408 |
Deferred income taxes - net |
294 |
168 |
Goodwill |
303 |
1,307 |
Other assets |
995 |
915 |
Total assets |
34,508 |
35,291 |
Current liabilities: |
||
Short-term borrowings |
722 |
1,137 |
Current maturities of long-term debt |
1,110 |
294 |
Accounts payable |
8,279 |
6,590 |
Accrued compensation and employee benefits |
662 |
747 |
Deferred revenue |
1,299 |
1,378 |
Other current liabilities |
2,425 |
1,950 |
Total current liabilities |
14,497 |
12,096 |
Long-term debt, excluding current maturities |
14,391 |
15,564 |
Deferred revenue - extended protection plans |
827 |
803 |
Other liabilities |
1,149 |
955 |
Total liabilities |
30,864 |
29,418 |
Shareholders’ equity: |
||
Preferred stock - $5 par value, none issued |
0 |
0 |
Common stock - $.50 par value; Shares issued and outstanding 801 at February 1, 2019 and 830 at February 2, 2018, respectively |
401 |
415 |
Capital in excess of par value |
0 |
22 |
Retained earnings |
3,452 |
5,425 |
Accumulated other comprehensive income/(loss) |
(209) |
11 |
Total shareholders’ equity |
3,644 |
5,873 |
Total liabilities and shareholders’ equity |
$ 34,508 |
$ 35,291 |
a. Identify the current operating liabilities (only include liabilities that will impact operating expenses) for each company and the applicable common-size percentage for each operating liability in the current year using your common-size balance sheet from part 2 of the financial analysis case. Explain why you picked these as the current operating liabilities. Operating liabilities are discussed in Module 4, but relates to module 7 with the continuation of the discussion on liabilities.
b. Identify the largest current operating liability for each company and explain why this current operating liability is so large compared to the other current operating liabilities.
c. What current liabilities did you not include in your analysis of current operating liabilities? Make sure you list out each of the current liabilities that were not included in “a”. Explain why you did not include them.
(a): For Lowe’s Companies the current operating liabilities are accounts payable, accrued compensation and employee benefits, and other current liabilities.
The applicable common-size percentage for these current operating liabilities is shown below:
2019 | 2018 | |
Accounts payable | 23.99% | 18.67% |
Accrued compensation and employee benefits | 1.92% | 2.12% |
Other current liabilities | 7.03% | 5.53% |
The percentages are computed using the total asset amount as base for each year.
The reason for picking these assets as current operating liability is that these liabilities are resulting directly from Lowe's primary operations.
(b): The largest current operating liability for Lowe’s for both 2019 and 2018 was accounts payable. The reason why this is the largest current operating liability is that this account shows the amount of money the company owes to its vendors. It is a crucial part of Lowe's working capital and because the organization has a large quantum of purchases and because a significant proportion of these purchases are on credit the accounts payable is so large for the company. In other words accounts payable is highly related to the company’s operations and this is the reason why accounts payable is so large when compared to the other current operating liabilities.
(c ): The current liabilities that I have not included are – short term borrowings, current maturities of long term debt and deferred revenue. The reason for not including them is based on accounting rational and principles. Short term debt and current installments of long-term debt are excluded because they are interest bearing in nature. It should be noted that current operating liabilities exclude any current loans or interest bearing liabilities. Deferred revenue is excluded because it is just the revenue which has been received in advance and so is not directly impacting Lowe’s operations for the year.
Lowe's Companies, Inc. Dollar amounts in Millions Common-Size Balance Sheets Feb. 01, 2019 Feb. 02, 2018...
Common-Size Balance Sheets Feb. 01, 2019 Feb. 02, 2018 Feb. 01. 2019 Feb 02, 2018 cell references to ar credit 3 Current assets 4 Cash and cash equivalents 5 Short Investments 6 Merchandise Inventory.net 7 Other current assets 3 Total current assets $ 511 21B $ 588 102 12,561 938 14,228 BAG 12,772 18,432 19.721 406 258 294 995 34,508 1,307 915 35,291 10 Property, less accumulated depreciation 11 Long-term investments 12. Deferad income taxes-net 13 Good 14 Other assets...
Identify and Compute Net Operating Assets Following is the balance sheet for Lowe's Companies Inc. $511 218 LOWE'S COMPANIES INC. Consolidated Balance Sheet $ millions, except par value Feb. 1, 2019 Current assets Cash and cash equivalents Short-term investments Merchandise inventory_net Other current assets Total current assets Property, less accumulated depreciation Long-term investments Deferred income taxes-net Goodwill 12,561 938 14.228 18,432 256 294 303 Other assets 995 $34,508 $722 Total assets Current liabilities Short-term borrowings Current maturities of long-term debt...
Identify and Compute Net Operating Assets Following is the balance sheet for Lowe's Companies Inc. 461 LOWE'S COMPANIES INC. Consolidated Balance Sheet $ millions, except par value Feb. 1, 2019 Current assets Cash and cash equivalents $920 Short-term investments 392 Merchandise inventory-net 22,610 Other current assets 1,688 Total current assets 25,610 Property, less accumulated depreciation 33,178 Long-term investments Deferred income taxes-net 529 Goodwill 545 Other assets 1,791 Total assets $62,114 Current liabilities Short-term borrowings $1,300 Current maturities of long-term debt...
Lowe's Companies, Inc. Consolidated Statements of Earnings (In millions, except per share and percentage data) February 1, 0 Sales February 2, 20197 Sales 2018 $ 71,309 100.00% $ 68,619 48,40167.88 46,185 22,908 32.12 22,434 0% Sales February % Sales 100.00% $ 65,017 67.31 43,343 32.69 21,674 % Sales 100.00% 66.66 33.34 Fiscal years ended on Net sales Cost of sales Gross margin Expenses: Selling, general and administrative Depreciation and amortization Operating income Interest - net Loss on extinguishment of debt...
Home Depot Inc. Common-Size Balance Sheets Dollar amounts in Millions Jan. 28, 2018 Jan. 29, 2017 Current assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets $ 2,538 2,02 1,952 12,748 638 18,933 608 Net property and equipment Goodwill Other assets Total assets 22,075 2,275 1246 21,914 2,093 1,23 42,966 44,529 Current Liabilities: Short-term debt Accounts payable Accrued salaries and related expenses Sales taxes payable Deferred revenue Income taxes payable Current installments of long-term...
Refer to the January 29, 2016, income statement and balance sheet of Lowe's Companies Inc. below. LOWE'S COMPANIES INC. Income Statement (In millions) For Fiscal Year Ended January 29, 2016 Net sales.............................................. Cost of sales.................................. ... Gross margin ....................................... Selling, general and administrative Depreciation.. tion......................................... Interest-net........................................ Total expenses... Pretax earnings Income tax provision ... Net earnings $59,074 38,504 20,570 14,115 1,484 552 16.151 4,419 1,873 $ 2,546 Required: Compute the following liquidity, solvency, and coverage ratios for Lowe's Companies. Interpret...
12 Months Ended in Millions $ Percentages Jan. 29, 2017 Home Depot, Inc. Common Size Statement of Earnings Jan. 28, 2018 Jan. 29, 2017 Jan. 31, 2016 Jan. 28, 2018 Jan. 31, 2016 88,519 Net sales Cost of sales Gross profit Operating expenses Sel S 100,904 66,548 S 94,595 62,282 100.00% 100.00% 100.00% 58.254 34.16% 34.19% ling, general and administrative Depreciation and amortization Total operating expenses Operating income Interest and other (income) expense Interest and investment income nterest expense Interest...
Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target's common-size balance sheets as of January 31, 2015 and February 1, 2014 (Round your answers to one decimal place.) January 31, February 1, (5 millions) 2015 2014 Assets Cash and cash equivalents 52.210 5670 Inventory 8.790 Other current assets 2.625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders' investment Accounts payable 57,759...
Balance sheets and income statements for the home depot inc. and lowe's companies inc . 1.Compute return on equity, return on assets, and return on financial leverage for each company in 2014 2. Disaggregate the ROA's computed into profit margin (PM) and asset turnover (AT) components. Which of these factors drives ROA for each company? 3. Compute the gross profit margin (GPM) and operating expense-to-sales ratios for each company. How do these companies' profitability measures compare? 4. Compute the accounts...
CAMPBELL SOUP COMPANY Consolidated Balance Sheets (Millions, except per share amounts) July 30, 2017 319 605 902 74 1,900 2,454 2,115 1,118 139 $ 7,726 $ 1,037 666 561 111 20 Current assets Cash and cash equivalents Accounts receivable, net Inventories Other current assets Total current assets Plant assets, net of depreciation Goodwill Other intangible assets, net of amortization Other assets ($51 as of 2017 attributable to variable interest entity) Total assets Current liabilities Short-term borrowings Payable to suppliers and...