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?
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%