Loading...

Imagine you have $10,000 to invest in any company. What would attract you to invest in a company? What would deter you from investing in a company?

Open Posted By: surajrudrajnv33 Date: 25/04/2021 High School Assignment Writing

In this group project, you will consider investing in one of two companies (mentioned below) and write a paper on the positives and negatives you assessed when evaluating and comparing these two companies for a potential investment of your $10,000. You will need to perform a ratio analysis using Excel, the fundamentals of ratio analysis are discussed in the recording below. 

The two companies that you need to evaluate and compare

  • Home Depot
  • Lowe's

write the ratio analysis. Make sure to include the following:

  • Part 1: For each company analyze the ratios for the current year and the prior year and group them into either negative or positive findings. Make sure to include a discussion as to why you group them as negative or positive! 
  • Part 2: Which company would you rather invest in and why? 
  • Part 3: Pick 1 one ratio with a big difference between the companies and discuss what might be driving this difference. 
  • Part 4: Provide one recommendation for each company to improve one of the ratios that you've calculated. The improvement should be implementable, it is not sufficient to suggest something like "improve the debt to equity ratio by improving debt."
Category: Engineering & Sciences Subjects: Biology Deadline: 12 Hours Budget: $100 - $150 Pages: 2-3 Pages (Short Assignment)

Attachment 1

HOME DEPOT INC

2019 2018 2017 Current ratio 1.08 1.11 (current assets/current liabilities)

Gross Profit Ratio revenue 110225000 108203000 cost of good sold -72346000 -70761000 gross Profit 37879000 37442000

gross margin ratio 34% 34%~35%

Return on Assets gross Profit 37879000 37442000 34607000 Operating profit -15843000 -15530000 -14681000 net income -11242000 -11121000 -8630000

Total Assets 51236000 44003000 44529000 average assets 47619500 44266000

ROA -24% -25%

Inventory turnover in days Inventory 14531000 13925000 12748000 average inventory 14228000 13336500

cost of good sold 72346000 70761000

inventory turnovers 5.08 5.31 in days 72 69

Debt to Equity ratio

Total Assets 51,236,000 44,003,000 44,529,000 Total Liabilities 54,352,000 45,881,000 43,075,000 Total shareholders e -3,116,000 -1,878,000 1,454,000

Debt to Equity -17.44 -24.43 as % -1744% -2443%

Horizontal Analysis Total Revenues / Gross Sales 110,225,000 108,203,000 2% Cost of Goods Sold -72,346,000 -70,761,000 2% Gross profit 37,879,000 37,442,000 1% Other Operating Items -19,740,000 -19,513,000 1% Total Depreciation, Amort. & Depl. -2,296,000 -2,399,000 -5% Operating Income 15,843,000 15,530,000 2% Unusual / Exceptional Items 0 0

Financial Revenue 73,000 93,000 -27% Financial Expenses -1,201,000 -1,051,000 13% Other Non Oper./ Financial Inc./ Exp. 0 -16,000

Earnings before Tax 14,715,000 14,556,000 1% Income Taxes -3,473,000 -3,435,000 1% Net Income 11,242,000 11,121,000 1%

Vertical Analysis Total Revenues / Gross Sales 110,225,000 108,203,000

Cost of Goods Sold -72,346,000 65.60% -70,761,000 65.40% Gross profit 37,879,000 34.40% 37,442,000 34.60% Other Operating Items -19,740,000 17.90% -19,513,000

Total Depreciation, Amort. & Depl. -2,296,000 20.80% -2,399,000

Operating Income 15,843,000 14.40% 15,530,000 14.35% Unusual / Exceptional Items 0 0

Financial Revenue 73,000 93,000

Financial Expenses -1,201,000 -1,051,000

Other Non Oper./ Financial Inc./ Exp. 0 -16,000

Earnings before Tax 14,715,000 13.35% 14,556,000 13.45% Income Taxes -3,473,000 -3,435,000

Net Income 11,242,000 10.20% 11,121,000 10.28%

LOWE'S COMPANIES, INC. 2019 2018 2017

Current Ratio Current Assets 15318000 14228000 Current Liabilities 15182000 14497000

Current Ratio 101% 98%

Gross Profit Ratio Total Revenues / Gross sales 72,148,000 71,309,000

Cost of Goods Sold -49,057,000 -48,271,000

Gross profit 23,091,000 23,038,000

gross profit ratio 32% 32.30%

Return on Assets Gross profit 23,091,000 23,038,000 22,570,000 Operating Income after Deprec. & Amort.6,331,000 4,597,000 6,586,000 Net Income 4,281,000 2,314,000 3,447,000

Total assets 39,471,000 34,508,000 35,291,000 average assets 36989500 34899500

ROA 11.60% 66.30%

Inventory turnover in days Inventory 13179000 12561000 11393000 average inventory 12870000 11977000

Cost of good sold -49,057,000 -48,271,000 -46,049,000

Inventory turnovers 3.81 4.03 in days 96 91

Debt to Equity ratio Total assets 39,471,000 34,508,000 35,291,000 Total Liabilities 37,499,000 30,864,000 29,418,000 Total Equity 1,972,000 3,644,000 5,873,000

Debt to equity 19.02 8.47 % 1902% 847%

Horizontal Analysis Total Revenues / Gross sales 72,148,000 71,309,000 1% Cost of Goods Sold -49,057,000 -48,271,000 2% Gross profit 23,091,000 23,038,000 0.20% Other Operating Items -15,297,000 -16,285,000 -6% Total Depreciation, Amort. & Depl. -1,463,000 -2,156,000 -32% Operating Income after Deprec. & Amort.6,331,000 4,597,000 38% Unusual / Exceptional Items -17,000 -579,000 -97% Financial Revenue 27,000 28,000 -4% Financial Expenses -697,000 -637,000 9% Other Non Oper./ Financial Inc./ Exp. -21,000 -15,000 66% Earnings before Tax 5,623,000 3,394,000 66%

Income Taxes -1,342,000 -1,080,000 24% Net Income 4,281,000 2,314,000 85%

Vertical Analysis Total Revenues / Gross sales 72,148,000 71,309,000

Cost of Goods Sold -49,057,000 68% -48,271,000 68% Gross profit 23,091,000 32% 23,038,000 32% Other Operating Items -15,297,000 -16,285,000

Total Depreciation, Amort. & Depl. -1,463,000 -2,156,000

Operating Income after Deprec. & Amort.6,331,000 9% 4,597,000 6% Unusual / Exceptional Items -17,000 -579,000

Financial Revenue 27,000 28,000

Financial Expenses -697,000 -637,000

Other Non Oper./ Financial Inc./ Exp. -21,000 -15,000

Earnings before Tax 5,623,000 8% 3,394,000 5% Income Taxes -1,342,000 -1,080,000

Net Income 4,281,000 6% 2,314,000 3%