South African Market Insights
  • Home
  • Blog
    • Blog-5Jun2018
    • Blog-18May2018
    • Blog-16May2018
    • Blog-3May2018
    • Blog-2May2018
    • Blog-30Apr2018
    • Blog-26Apr2018
    • Blog-24Apr2018
    • Blog-18Apr2018
    • Blog-17Apr2018
    • Blog-16Apr2018
    • Blog-3Apr2018
    • Blog-22Mar2018
    • Blog-20Mar2018
    • Blog-19Mar2018
    • Blog-23Oct2017
    • Blog-20Oct2017
    • Blog-11Oct2017
    • Blog-10Oct2017
    • Blog-6Oct2017
    • Blog-3Oct2017
    • Blog-2Oct2017
  • Economics
    • Rand Dollar Exchange Rate
    • South Africa's GDP
    • South Africa's Unemployment
    • SA by numbers
    • Economic Progress Index
    • Taylors Rule
    • South Africa's Formal Business Sector
    • South-Africa's-Fiscal-Policy
    • SA EU Trade Data
    • Inflation Heat Map
    • Population Density Map
    • Labour Market Dynamics
    • Estimating the Size of the Informal Economy
    • SA Consumer Spending Patterns
    • South Africa's Monetary Fiscal Policy Mix
    • GDP Animations >
      • SouthAfrica
      • WesternCape
      • EasternCape
      • NorthernCape
      • FreeState
      • KwaZuluNatal
      • NorthWest
      • Gauteng
      • Mpumalanga
      • Limpopo
    • South Africa's Economic Structure
    • South Africa's Economic History
    • South Africa's Trade Data Page
    • South Africa's Food and Beverages Sector
    • Financial Well-being of South African Companies_2015
    • SA vs the World
    • Budget Day Page (24 Feb 2016)
  • Stock in Focus
    • JSE ALSI Chart
    • Sector Comparison Page
    • JSE-Calendar-Tracker-2019
    • Adcorp (ADR)
    • Amazon (AMZN)
    • Apple (AAPL)
    • Ascendis (ASC)
    • AVI (AVI)
    • Bidvest (BVT)
    • Blue Label Telecoms (BLU)
    • Bowler Metcalf (BCF)
    • Capitec (CPI)
    • City Lodge Hotel Group
    • Clicks Group (CLS)
    • Coronation (CML)
    • Curro Holdings (COH)
    • Discovery (DSY)
    • Distell (DST)
    • EOH (EOH)
    • Famous Brands (FBR)
    • Ferrari (RACE)
    • FirstRand Group (FSR)
    • Grindrod (GND)
    • GrowthPoint (GRT)
    • Holdsport (HSP)
    • Harley-Davidson (HOG)
    • Hyprop (HYP)
    • Hyprop (HYP)_1Jun2016
    • Investec Property Fund (IPF)
    • JSE (JSE)
    • Massmart (MSM)
    • MediClinic (MEI)
    • MTN (MTN)
    • MTN (MTN)_May2016
    • Mr Price Group (MRP)
    • Mr Price Group (MRP)_8APR2016
    • Nedbank (NED)
    • OneLogix (OLG)
    • Peregrine Holdings (PGR)
    • Pick 'n Pay Stores (PIK)
    • Pioneer Foods (PFG)
    • PSG Group (PSG)
    • Quantum Foods (QFH)
    • RCL Foods (RCL)
    • Remgro (REM)
    • Richemont (CFR)
    • RMB Holdings (RMH)
    • Rolfes (RLF)
    • Sanlam (SLM)
    • Sasol (SOL)
    • Sasol (SOL)_18sep2016
    • Santova (SNV)
    • Spar Group (SPP)
    • Shoprite Holdings (SHP)
    • Spur Corporation (SUR)_7Sep2017
    • Standard Bank (SBK)
    • Steinhoff International Holdings (SNH)
    • Stor-Age (SSS)
    • Super Group (SPG)
    • Taste Holdings (TAS)_30May2016
    • The Foshini Group (TFG)
    • Value Logistics (VLE)
    • Vodacom (VOD)
    • Wilson Bayly Holmes Ovcon (WBO)
    • Woolworths (WHL)
    • Woolworths (WHL)_24Aug2017
    • Zeder (ZED)
  • Online Calculators
    • Rand Petrol Price Estimator
    • Share Valuation
    • Financial Ratios Calculator
    • GDP Growth Estimator
    • Future Value of Investment Calculator
    • Loan repayment calculator
  • Contact
  • About
  • Search

< HoldSport
Hyprop >

Home Depot (NYSE: HD) stock valuation on 21 October 2016

Category: Financial markets and stock valuations
Date:21 October 2016

Price at time of writing: $126.25

Related Topics

  • No related shares value yet. Back to Home Page

chart created with amCharts | amCharts

Background and overview of Home Depot (HD:NYSE)
HD is the largest home improvement retailer in the world. They sell any and everything related to DIY, home improvements and building projects. From power tools and hardware supplies to garden equipment to ordering custom made kitchen cabinets they cover it all. According to the company's website the company was founded in 1978. "When The Home Depot was founded in 1978, Bernie Marcus and Arthur Blank had no idea how revolutionary this new “hardware store” would be for home improvement and the retail industry.Today, we’re proud to be the world’s largest home improvement retailer. In more than 2,200 stores across North America, we aspire to excel in service – to our customers, associates, communities and shareholders. That’s what leadership means to us. That's The Home Depot difference"

​Scroll over or click on the funnel chart to get more details of HD's latest financial results.
funnel | amCharts

Financial review: 
Home Depot is sitting on a net profit margin of 9.2%. So essentially for every $100 they receive they make $9.2 in profits after paying all expenses and taxes. Pretty strong net profit margins considering the competitive environment they operate in. Guess being the largest home improvements retailer in the world gives you some bargaining power when it comes to discussing cost of goods from suppliers.

Diluted earnings per share came in at $1.97 a share for the quarter. This places HD on a PE ratio of 17.1  (assuming the next two quarters will provide same earnings per share as the last quarter). The PE is not exactly the cheapest in the US market. Even Apple (AAPL) is trading at a lower PE ratio. HD is sitting on a dividend yield of 2.19% (assuming the next two quarters will provide same dividen per share as the last quarter).
​
​
Cash generated by operating activities for the 6 months (first two quarters of the fiscal year) amounted to $6877million (or roughly $5.55 a shares). That makes it about $2.77 a share in cash generated from operating activities per quarter. Showing HD is generating a lof of cash. At the end of the 6 months their cash and equivalents on their balance sheet was $4018million

Pie chart shows revenue earned per product category (for the fiscal year ending January 2016)
3D donut | amCharts
From the pie charts above it's clear that HD has a wide variety of product catergories and they all contribute meaningfully to their revenue. There is not a dependence on one particular category to generate revenue from. For management this must be very encouraging and comforting knowning all products sold is contributing meaningfully to their revenue.

​A little bit of a concern to us is the fact that in the 6months from Janary 31 ,2016 to July 31 ,2016 inventories went up by almost $515million (or 4.3%). Question is whether stock in their stores are not moving as fast as they had planned hence the increased build up of inventories? or are they expecting stronger sales and therefore carrying more inventories? In addition to this receivables owed to HD, I.e money owed to HD for goods supplied increased by $105million (or an increase of 5.56%) over the 6months period. Are their customers taking longer to pay them back for goods and services rendered? This is a concern as some of their clients might be defaulting on their payments and this will lead to write offs on HD's books.

A few financial ratios for Home Depot (calculated using our Financial Ratios Calculator):
  • Debt to Equity Ratio: 5.65 (more than 2 shows high levels of financial leverage). This high ratio shows that the company rather issues debt than raise funds from shareholders. 
  • Current Ratio: 1.30  (A measure of liquidity. Less than one signals possible trouble in paying off current liabilities).  
  • Quick Ratio: 0.46 (Another liquidity measure. Shows how much in liquid assets is available to cover current liabilities or short term debt).  This ratio is a lot lower than the current ratio due to large amount of inventories HD carries.
  • Return on Assets (ROA): 5.52%
  • Return on Equity (ROE): 36.67%
  • Net Profit Margin: 9.22%
  • Dividend Yield: 2.19%

Valuation: 
Based on HD current financial results we value them at between $125.30 and $125.64. We therefore feel that at it's current price it is close to being fully valued. It has dropped by about $10 in the last 3months but we feel it is currently trading at full value.
​
For South African investors, please remember exchange rate movements will have an impact on the value of your HD shares when the value is calculated in Rand terms.

​
We use our Share Valuation Calculator as guide to valuing shares. We believe in value investing and our above mentioned share valuation is based on the underlying fundamentals and financial statements of the stock in question. Note this is not a binding valuation and investors should do their own research before investing in a specific share. Southafricanmi.com cannot be held liable for any losses incurred, We would accept donations on profits made though ;)

Related Topics

  • No related shares value yet. Back to Home Page


​Homepage

Economics Page
Stock in Focus Page


​About


Contact Us

Copyright © 2015
  • Home
  • Blog
    • Blog-5Jun2018
    • Blog-18May2018
    • Blog-16May2018
    • Blog-3May2018
    • Blog-2May2018
    • Blog-30Apr2018
    • Blog-26Apr2018
    • Blog-24Apr2018
    • Blog-18Apr2018
    • Blog-17Apr2018
    • Blog-16Apr2018
    • Blog-3Apr2018
    • Blog-22Mar2018
    • Blog-20Mar2018
    • Blog-19Mar2018
    • Blog-23Oct2017
    • Blog-20Oct2017
    • Blog-11Oct2017
    • Blog-10Oct2017
    • Blog-6Oct2017
    • Blog-3Oct2017
    • Blog-2Oct2017
  • Economics
    • Rand Dollar Exchange Rate
    • South Africa's GDP
    • South Africa's Unemployment
    • SA by numbers
    • Economic Progress Index
    • Taylors Rule
    • South Africa's Formal Business Sector
    • South-Africa's-Fiscal-Policy
    • SA EU Trade Data
    • Inflation Heat Map
    • Population Density Map
    • Labour Market Dynamics
    • Estimating the Size of the Informal Economy
    • SA Consumer Spending Patterns
    • South Africa's Monetary Fiscal Policy Mix
    • GDP Animations >
      • SouthAfrica
      • WesternCape
      • EasternCape
      • NorthernCape
      • FreeState
      • KwaZuluNatal
      • NorthWest
      • Gauteng
      • Mpumalanga
      • Limpopo
    • South Africa's Economic Structure
    • South Africa's Economic History
    • South Africa's Trade Data Page
    • South Africa's Food and Beverages Sector
    • Financial Well-being of South African Companies_2015
    • SA vs the World
    • Budget Day Page (24 Feb 2016)
  • Stock in Focus
    • JSE ALSI Chart
    • Sector Comparison Page
    • JSE-Calendar-Tracker-2019
    • Adcorp (ADR)
    • Amazon (AMZN)
    • Apple (AAPL)
    • Ascendis (ASC)
    • AVI (AVI)
    • Bidvest (BVT)
    • Blue Label Telecoms (BLU)
    • Bowler Metcalf (BCF)
    • Capitec (CPI)
    • City Lodge Hotel Group
    • Clicks Group (CLS)
    • Coronation (CML)
    • Curro Holdings (COH)
    • Discovery (DSY)
    • Distell (DST)
    • EOH (EOH)
    • Famous Brands (FBR)
    • Ferrari (RACE)
    • FirstRand Group (FSR)
    • Grindrod (GND)
    • GrowthPoint (GRT)
    • Holdsport (HSP)
    • Harley-Davidson (HOG)
    • Hyprop (HYP)
    • Hyprop (HYP)_1Jun2016
    • Investec Property Fund (IPF)
    • JSE (JSE)
    • Massmart (MSM)
    • MediClinic (MEI)
    • MTN (MTN)
    • MTN (MTN)_May2016
    • Mr Price Group (MRP)
    • Mr Price Group (MRP)_8APR2016
    • Nedbank (NED)
    • OneLogix (OLG)
    • Peregrine Holdings (PGR)
    • Pick 'n Pay Stores (PIK)
    • Pioneer Foods (PFG)
    • PSG Group (PSG)
    • Quantum Foods (QFH)
    • RCL Foods (RCL)
    • Remgro (REM)
    • Richemont (CFR)
    • RMB Holdings (RMH)
    • Rolfes (RLF)
    • Sanlam (SLM)
    • Sasol (SOL)
    • Sasol (SOL)_18sep2016
    • Santova (SNV)
    • Spar Group (SPP)
    • Shoprite Holdings (SHP)
    • Spur Corporation (SUR)_7Sep2017
    • Standard Bank (SBK)
    • Steinhoff International Holdings (SNH)
    • Stor-Age (SSS)
    • Super Group (SPG)
    • Taste Holdings (TAS)_30May2016
    • The Foshini Group (TFG)
    • Value Logistics (VLE)
    • Vodacom (VOD)
    • Wilson Bayly Holmes Ovcon (WBO)
    • Woolworths (WHL)
    • Woolworths (WHL)_24Aug2017
    • Zeder (ZED)
  • Online Calculators
    • Rand Petrol Price Estimator
    • Share Valuation
    • Financial Ratios Calculator
    • GDP Growth Estimator
    • Future Value of Investment Calculator
    • Loan repayment calculator
  • Contact
  • About
  • Search