ZuoTi.Pro
Question

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 and other, net Earnings before provision for income taxes Provision for income taxes Net earnings 17,864 1,811 19,675 14,681 17,132 1,754 18,886 13,427 16,801 1.690 18.491 11,774 17.70% 1.79% 19.50% 14.55% 18.11% 1.85% 19.97% 14.19% 18.98% 1.91% 20.89% 13.30% 74 1,057 983 13,698 5,068 8,630 36 972 936 12,491 4,534 7.957 166 919 753 11,021 4.012 7.009 -0.04% 1.03% 99% 13.20% 4.79% 8.41% -0.19% 1.04% 85% 12.45% 4.53% 7.92% -0.07% 13.58% 5.02% 8.55%12 Months Ended in Millions $ Percentages Feb. 02, 2018Feb. 03, 2017 Lowes Companies, Inc. Common Size Statement of Earnings Feb. 02, 2018 Feb. 03, 2017 Jan. 29, 2016 Jan. 29, 2016 S 68,619 45,210 23,409 S 65,017 42,553 22,464 Net sales Cost of sales Gross margin Expenses Selling, general and administrative Depreciation and amortization Operating income Interest - net Loss on extinguishment of debt Pre-tax earnings Income tax provision Net earnings S59,074 38,504 20,570 100.00% 100.00% 100.00% 65.1 8% 34.82% 34.11%, 34.55% 15,129 1,489 5,846 645 14,105 1,494 4,971 552 15,376 1,447 6,586 633 464 5,489 2,042 S 3,447 22.41% 2.11% 9.60% 0.92% 23.27% 2.29% 8.99% 0.99% 23.88% 2.53% 8.41% 0.93% 5,201 2,108 S 3,093 4,419 1,873 S 2,546 8.00% 2.98% 5.02% 8.00% 3.24% 476% 7.48% 3.1 7% 4.31%

Lowes Companies, Inc. Common-Size Balance Sheets Dollar amounts in Millions Feb. 02, 2018 Feb. 03, 2017 Percentages Feb. 02, 2018 Feb. 03, 2017 Current assets Cash and cash equivalents Short-term investments Merchandise inventory-net Other current assets Total current assets S 558 0.29% 32.28% 1.62% 0.29% 30.39% 11,393 10,458 884 12,000 12,772 Property, less accumulated depreciation Long-term investments Deferred income taxes net Goodwil Other assets Total assets 19,949 366 55.88% 57.98% 1.06% 0.65% 408 0.48% 3.70% 2.59% 100.00% 789 34,408 2.29% 100.00% Current liabilities: Short-term borrowings Current maturities of long-term debt Accounts payable Accrued compensation and employee benefits Deferred revenue Other current liabilities Total current liabilities 3.22% 0.83% 18.67% 2.12% 3.90% 1.48% 2.31% 19.33% 2.30% 3.64% 294 6,651 790 1,253 1,975 11,974 747 1,378 15,564 Long-term debt, excluding current maturities Deferred revenue-extended protection plans Other liabilities Total liabilities 44. 1 0% 2.28% 41.83% 2.22% 27,974 83.36% 81.30% Shareholders equity: Common stock-$.50 par value; Shares issued and outstanding 830 at February 2, 2018 and 866 at February 3,2017, respectively Capital in excess of par value Retained earni Accumulated other comprehensive income/(loss Total shareholders equity Total liabilities and shareholders equity 433 1.26% 0.00% 0.06% 15.37% -0.70% 18.70% 6,434 S 34,408 16.64% S 35,291Home Depot Inc. Common-Size Balance Sheets Dollar amounts in Millions Jan. 28, 2018 Percentages Jan. 29. 2017 Jan. 28, 2018 Jan. 29, 2017 Current assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total curent assets S 2,538 12,549 17,724 8.07% 4.38% 28.63% 5.91% 4.72% 29.21% 12,748 638 Net property and equipment Goodwill Other assets Total assets 22,075 2,275 49.57% 2,093 1,235 42,966 51.00% 4.87% 2.87% 100.00% 2.80% 100.00% 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 debt Other accrued expenses Total curent liabilities 1,559 3.50% 18.27% 3.68% 7,244 520 54 7,000 508 25 18.29% 3.45% 3.88% 0.06% 1.26% 4,05% 2.70% 4.87% 0.00% 54.50% 0.99% 4.88% 96.73% 24,267 Long-term debt, excluding current installments Deferred income taxes Other long-term liabilities Total liabilities 22,349 296 1,855 38,633 52.02% 0.69% 440 43,075 89 89.92% Common stock, par value S0.05; authorized: 10,000 shares; issued: 1,780 shares at January 28 2018 and 1,776 shares at January 29, 2017 Paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost, 622 shares at January 28, 2018 and 573 shares at January 29, 2017 Total stockholders equit Total liabilities and stockholders equity 0.20% 22.89% 89.68% 1.27% 108.24% 0.20% 22.78% 82.67% 2.02% 93.55% 10.08% 9,787 35,519 867 39,935 48,196 S 44,529 4,333 S 42,966Home Depot Inc. Lowes Companies, Inc. Please note the ratio computations in the comment box. This is the same information that was included in the part 2 instructions. Please let me know if you have questions. Total Assets 2016 41,973 Total Assets 2016 S31,266 Total Stockholders equity 2016 $6,316 Total Stockholders equity 2016 $7,654 Jan. 28, 2018 Feb. 02, 2018 Feb. 03, 2017 1. Current ratio Current ratio 2. Liabilities-to equity 3. Times interest earned 4. Return on Equity-shown as a percentage 5. Profit Margin-Shown as a 1.06 5.01 10.40 8.92 .35 Liabilities-to-equity 3, Times interest earned 4. Return on Equity -shown as a 29.63 298.25% 149.44% 56.02% 43.91% 5. Profit Margin-Shown as a percentage 6. Asset Turnover 7, Financial Leverage 8. Redo your Return on Equity calculation by calculating Profit MarginAsset Tumover Financial 2.23 7.98 2.31 6. Asset Turnover 7, Financial Leverage 8. Redo your Return on Equity calculation by calculating Profit MarginAsset Tumover Financial 1.97 1.98 298.25% 56.02% 43.91% 4. On the Ratio and Comments worksheet answer the following questions in the text box I have provided the specifc results you have determined throughout part 2. I am not looking for generic comments you have found on a webste. ur answer. You grade is based on you applying financial analysis to a. Compare the two vertical analyses and look for major differences over time and between the companies. Which company is more profitable? Why? Which statement are you using to make your assessment on profitability? b. Is the profit margin similar for the two companies? Compare the percentage of profit margin over the past 2 years. c. Explain how the Return on Equity has changed over time? Include a discussion of changes in profit margin, asset turnover, and financial leverage. Do the changes make sense given the economic and competitive factors that affect the industry and the companies? d. Explain what liquidity means. Which company is more liquid? Why?

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Over the year home Depot Inc, gross profit margin has decreased , however decremental percentage is not very high. It has decreased from 34.19% in Jan 31, 2016 to 34.16% in Jan 28, 2017 to 34.05% in Jan 28, 2018.

Over the year operating expenses have also decreased from 20.89% in Jan 31, 2016 to 19.97% in Jan 28. 2017 to 19.50% in Jan 28, 2018. As a result of which operating income has improved from 13.30% in Jan 31, 2016 to 14.19% in Jan 28, 2017 to 14.55% in Jan 28, 2018. And similarly there has also been improvement in net profit margin from 7.92% in Jan 31, 2016 to 8.41% in Jan 28, 2017 to 8.55% in Jan 28. 2018.

Over the year Lowe's companies Inc gross profit ratio has declined from 34.82% in Jan 29, 2016 to 34.55% in Feb 3, 2017 to 34.11% in Feb 2, 2018. However due to decreasing trend of operating expenses , we can see that operating income has increased year over year from 8.41% in Jan 29, 2016 to 8.99% in Feb 3, 2017 to 9.60% in Feb 2, 2018. Similarly there has also been improvement in net profit ratios of the company year over year. It has improved from 4.31% in Jan 29, 2016 to 4.76% in Feb 3, 2016 to 5.02% in Feb 2, 2018.

Comparing the sales and profit of both the company we can see that sales of home inc is more than Lowe's company by a major amount . There has been increase in sales of both the company year on year. Gross profit margin of both the company is very close which shows that both the company charges almost similar price for their product and product of the company is priced by the market and not by the company which shows perfect competition in the market. Also gross profit margin of the company is on the declining trend. When we talk about about operating income Margin of both the company we can see that operating profit margin home Depot Inc is far better than Lowe's company . The reason may be high volume of fixed expense of Lowe's company.

Finally when it comes to Net profit margin again the performance of home Depot company is better than Lowe's company.

So overall we can conclude that home Depot inc is more profitable than Lowe's companies Inc the foremost reason being higher sales amount of home Depot Inc and comparitively lesser administrative expense. For analyzing the profit of the both the company common size statement of earning of both the companies will be used.

2. No profit margin of both the company is quote quite different . However the rate of increase is quite similar in both the companies.

Following is the comparative view of profitability margin of both the company :-

Year Home Depot Inc Lowe's companies Inc
2017 (Jan &Feb 2018) 8.55%

5.02
2016 (Jan & Feb 2017 8.41%

4.76%

Clearly we can see that home Depot Inc have better profit margin as compared to lose's companies Inc mainly due to higher sales and comparetively lower administrative expenses .

Note :- due to lack of time on board, I am able to solve this much . Please upload the remaining Part of the question, i will definitely complete it then. I am extremely sorry for the inconvenience caused to you.

0 0
Add a comment
Know the answer?
Add Answer to:
12 Months Ended in Millions $ Percentages Jan. 29, 2017 Home Depot, Inc. Common Size Statement...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Home Depot Inc. Common-Size Balance Sheets Dollar amounts in Millions Jan. 28, 2018 Jan. 29, 2017...

    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...

  • Home Depot Inc. Dollar amounts in Miltions Jan. 2a 2016 | Jan. 29,20171 Balance Sheets 4...

    Home Depot Inc. Dollar amounts in Miltions Jan. 2a 2016 | Jan. 29,20171 Balance Sheets 4 Current assets: Jn2g 2018- Jan. 29, 2017 Cash and cash equivalents 6 Receivables, net $2,538 2,029 12,549 608 3,595 1,952 2,748 8 Other aurrent assets Total current assets 10 11 Net property and equipment 12 Goodwi 13 Other assets 933 22,075 2,275 1,246 44,529 21,914 2,093 4957% 611% 4 Total assets 966 16 Current Liabilities 17 Short-term debt 18 Accounts payable 19 Accrued salaries...

  • 12 Months Ended in Millions $ Home Depot, Ine. Common Size Statement of Enmings Feb. 03,...

    12 Months Ended in Millions $ Home Depot, Ine. Common Size Statement of Enmings Feb. 03, 2019 Jan 28, 2018 Jan. 29, 2017 Feb. 03, 2019 Jan 28, 2018 Jan. 29, 2017 $ 108,203 71,043 37,160 $100,904 66,548 34,356 $ 94,595 62,282 32,313 17,864 1.811 6 Gross proft 7 Operating expenses Seng peneral and a n Deprecation and mortation 10 Impamentos 11 Tooperating expenses 12 Operating income 13 Interest and other income) expense: 14 Interest and investment income 19,513 1,870...

  • Refer to the January 29, 2016, income statement and balance sheet of Lowe's Companies Inc. below....

    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 Lowe's Companies, Inc. Common Size Statement of Earings Feb....

    12 Months Ended in Millions $ Percentages Lowe's Companies, Inc. Common Size Statement of Earings Feb. 01, 2019 Feb. 02, 2018 Feb. 03, 2017 Feb 01, 2019 Feb. 02, 2018 Feb. 03, 2017 You must us references to Net Sales Cost of sales Gross $71,309 48,401 22,908 $ 68,619 46,185 22,434 $ 65,017 43,343 21,674 Song general and admi Depreciation and amo Operating income Interest - het Loss on extinguishment of debt Pre-tax Barnings Income tax provision Net earings 17,413...

  • Please solve and show the work for this information below. Home Depot, Inc. Common Size Statement...

    Please solve and show the work for this information below. Home Depot, Inc. Common Size Statement of Earnings 12 Months Ended in Millions $ Percentages Feb. 03, 2019 Jan. 28, 2018 Jan. 29, 2017 Feb. 03, 2019 Jan. 28, 2018 Jan. 29, 2017 Net Sales $ 108,203 $ 100,904 $ 94,595 Cost of sales 71,043 66,548 62,282 Gross profit 37,160 34,356 32,313 Operating expenses: Selling, general and administrative 19,513 17,864 17,132 Depreciation and amortization 1,870 1,811 1,754 Impairment loss 247...

  • KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2018, 2017, and 2016 2018 2017...

    KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2018, 2017, and 2016 2018 2017 2016 Sales $389,743 $298,575 $207,200 Cost of goods sold 234,625 188,401 132,608 Gross profit 155, 118 110,174 74,592 Selling expenses 55,344 41,203 27, 350 Administrative expenses 35,077 26,275 | 17,198 Total expenses 90,421 67,478 44,548 Income before taxes 64,697 42,696 30,044 Income tax expense 12,034 8,753 6,099 Net income $ 52,663 $ 33,943 $ 23,945 KORBIN COMPANY Comparative Balance Sheets December 31, 2018, 2017,...

  • Home Depot, Inc. Common Size Statement of Earnings Jan. 28, 2018 Jan 29, 2017 Jan, 31,2016...

    Home Depot, Inc. Common Size Statement of Earnings Jan. 28, 2018 Jan 29, 2017 Jan, 31,2016 $ 100,904$ 94,595 $88,51 Net sales Cost of sales Gross proft 66,54B 17,864 4,68 62 282 30 265 Selling, general and administrative Depreciation and amortization 17,132 16,801 Operating income Interest and other Oncome) expense: nterest and investment income Interest experse nterest and other, net Earnings before provision for income taxes Provision for income taxes Net earnings 36 972 166 963 13,698 491 1,021 7...

  • THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February 3, 2019 January 28, 2018 in millions, except per share data A...

    THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February 3, 2019 January 28, 2018 in millions, except per share data Assets Current assets: Cash and cash equivalents 1,778 $ 3,595 Receivables, net 1,936 1,952 Merchandise inventories 13,925 12,748 Other current assets 890 638 Total current assets 18,529 18,933 22,375 Net property and equipment 22,075 Goodwill 2,252 2,275 Other assets 847 1,246 Total assets 44,003 44,529 Liabilities and Stockholders' Equity Current liabilities: 1,339 $ Short-term debt $ 1,559 Accounts payable Accrued salaries...

  • 12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions...

    12 Months Ended Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions Jan. 31, 2018 Jan. 31, 2017 99.08% 0 $ 495,761 4,582 500,343 $ 481,317 4,556 485,873 99.06% 0.94% 0 373,396 106,510 0 o 361,256 101,853 20,437 22,764 3 Revenues: 4 Net sales 5 Membership and other income 6 Total revenues 7 Costs and expenses: 8 Cost of sales Operating, selling, general and administrative 9 expenses 10 Operating income 11 Interest: 12 Debt 13 Capital...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT