Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

1. Relative Valuation The valuation begins with identifying seven potentially comparable companies to assess Target Corporation. The potentially comparable companies are 1) Amazon Inc., 2) Costco...

1 answer below »
1. Relative Valuation
The valuation begins with identifying seven potentially comparable companies to assess Target Corporation. The potentially comparable companies are 1) Amazon Inc., 2) Costco Wholesale Corp., 3) Dollar General Corp., 4) Home Depot Inc., 5) Lowes Companies Inc., 6) TJX Companies Inc. and 7) Walmart Inc. While the selection is based on global industry classification standards and market capitalization, the assessment examines U.S. companies to better assess comparable operations to Target’s management of COVID-19 restrictions, regulations, and customer behavior.
2. Price to Sales Multiples
3. Key Value Drivers
4. Final Comparables
Key value drivers were applied to na
ow potentially comparable companies for assessing Target Corporation. Final comparable companies are 1) Amazon Inc., 2) Costco Wholesale Corp., 3) Dollar General Corp., 4) TJX Companies Inc., and 5) Walmart Inc.
5. Implied Total Equity Value
Part II - Historical Data for DCF Valuation
Works Cited
S&P Capital IQ XXXXXXXXXXTarget Corp., Amazon Inc., Costco Wholesale Corp., Dollar General Corp., Home Depot Inc., Lowes Companies Inc., TJX Companies
Inc., Walmart Inc.: Public company profile. Retrieved April 25, 2021 from S&P Capital IQ database.

1. Background
Target Corp., established as the discount division of the Dayton's Company of Minneapolis, MN in 1962, is the second-largest discount retailer in the United States. As of 2021, the company operates 1,897 stores across the US. Since April 2020, the company’s share price has outperformed the S&P 500 by 55%, thanks to its strong sales and earnings growth during the pandemic period. For example, the company has beaten analyst consensus sales and earnings estimates four quarters in a row since the first quarter of 2020. In particular, Target’s e-commerce sales growth has outperformed other retail peers such as Walmart and Home Depot, and its own delivery service, Shipt, and pickup services are getting traction.
Perhaps not surprising given these positives, the majority of the analysts recommend that the company’s equity will outperform the market.1 However, continued investment in the company’s e-commerce infrastructure, refu
ishing stores, and labor could put pressure on its operating margins going forward. Also, it is not clear whether the benefits Target has enjoyed during the pandemic would last in the medium to long run. Therefore, Target’s equity poses both potential challenges and opportunities to analysts and investors: On the one hand, the recent outperformance relative to the overall market as well as the retail peers might indicate that the company’s equity now fully reflects its fundamentals or is even potentially overvalued. On the other hand, Target’s equity may still offer an attractive investment opportunity, if the company’s future outlook for generating free cash flows and growth, given the risk, more than justify the cu
ent valuation. Therefore, the conclusion as to whether Target is an attractive investment should depend on your careful valuation analysis that incorporates its fundamental cash flow generating abilities and prices of the company as well as other comparable companies.
Answered 5 days After May 11, 2021

Solution

Sugandh answered on May 17 2021
161 Votes
Executive Summary
The paper is an analysis of the summary of the valuation of the seven companies which are compared in the manner as follows:- 1) Amazon Inc., 2) Costco Wholesale Corp., 3) Dollar General Corp., 4) Home Depot Inc., 5) Lowes Companies Inc., 6) TJX Companies Inc. and 7) Wal-Mart Inc. It explains the concept in term with the DCF Valuation Analysis which is divided as follows:-
· Relative Valuation
· DCF Valuation in connection with the historical data
· Project free Cash Flow using the method as the Sales Driven to DCF Valuation
· Estimating Cost of Capital
· DCF Valuation in terms with the Terminal Value
· Concluding Analysis on Valuation
1. Relative Valuation
The valuation begins with identifying seven potentially comparable companies to assess Target Corporation. The potentially comparable companies are 1) Amazon Inc., 2) Costco Wholesale Corp., 3) Dollar General Corp., 4) Home Depot Inc., 5) Lowes Companies Inc., 6) TJX Companies Inc. and 7) Walmart Inc. While the selection is based on global industry classification standards and market capitalization, the assessment examines U.S. companies to better assess comparable operations to Target’s management of COVID-19 restrictions, regulations, and customer behavior.
2. Price to Sales Multiples
3. Key Value Drivers of TGT will be stated as follows:-
a)
    Amazon Inc
    2021
    2022
    2023
    2024
    2025.0
    Net Operating Profits
    21344.4
    43947.15
    48130.92
    52712.98
    57731.26
    Profits growth
    Â 
    105.90%
    9.52%
    9.52%
    9.52%
    Costco Wholesale Corp
    2021
    2022
    2023
    2024
    2025
    Net Operating Profits
    21344.4
    41705.99
    42227.31
    45711.07
    49482.23
    Profits growth
    Â 
    95%
    1%
    8%
    8%
    Dollar General Corp
    2021
    2022
    2023
    2024
    2025
    Net Operating Profits
    22550.36
    44062.38
    44613.16
    48293.74
    52277.97
    Profits growth
    Â 
    95%
    1%
    8%
    8%
    Home Depot Inc
    2021
    2022
    2023
    2024
    2025
    Net Operating Profits
    22625.06
    44208.35
    44760.95
    48453.73
    52451.16
    Profits growth
    
    95%
    1%
    8%
    8%
    Lowes Companies Inc
    2021
    2022
    2023
    2024
    2025
    Net Operating Profits
    22178.97
    43336.69
    43878.4
    47498.37
    51416.98
    Profits growth
    Â 
    95.395%
    1.250%
    8.250%
    8.250%
    TJX Companies Inc
    2021
    2022
    2023
    2024
    2025
    Net Operating Profits
    20373.23
    39808.36
    40305.97
    43631.21
    47230.79
    Profits growth
    Â 
    95%
    1%
    8%
    8%
    Wal-Mart Inc
    2021
    2022
    2023
    2024
    2025
    Net Operating Profits
    21700.85
    42402.48
    42932.51
    46474.44
    50308.58
    Profits growth
    
    95.40%
    1.25%
    8.25%
    8.25%
) Net Income Margins
    Amazon Inc
    2021
    2022
    2023
    2024
    2025
    Sales Revenue
    92400
    99653.4
    109140.4
    119530.6
    130909.9
    Net Operating Profits
    21344.4
    43947.15
    48130.92
    52712.98
    57731.26
    Â 
    0.231
    0.441
    0.441
    0.441
    0.441
    Costco Wholesale Corp
    2021
    2022
    2023
    2024
    2025
    Sales Revenue
    92400
    94571.4
    95753.54
    103653.2
    112204.6
    Net Operating Profits
    21344.4
    41705.99
    42227.31
    45711.07
    49482.23
    Â 
    0.231
    0.441
    0.441
    0.441
    0.441
    Dollar General Corp
    2021
    2022
    2023
    2024
    2025
    Sales Revenue
    97620.6
    99914.68
    101163.6
    109509.6
    118544.2
    Net Operating Profits
    22550.36
    44062.38
    44613.16
    48293.74
    52277.97
    Â 
    0.231
    0.441
    0.441
    0.441
    0.441
    Home Depot Inc
    2021
    2022
    2023
    2024
    2025
    Sales Revenue
    97944
    100245.7
    101498.8
    109872.4
    118936.9
    Net Operating Profits
    22625.06
    44208.35
    44760.95
    48453.73
    52451.16
    
    0.231
    0.441
    0.441
    0.441
    0.441
c)
    Amazon Inc
    Amazon Inc
    Costco Wholesale Corp
    Dollar General Corp
    Home Depot Inc
    Lowes Companies Inc
    TJX Companies Inc
    Walmart Inc
    WACC
    5.4
    3.25%
    3.10%
    5.98%
    7.94%
    9.73%
    2.85%
d)
    Particulars
    Amazon Inc
    Costco Wholesale Corp
    Dollar General Corp
    Home Depot Inc
    Lowes Companies Inc
    TJX Companies Inc
    Walmart Inc
    Market Cap
     1.625 T rillion
     170.11 Billion
     49.336B
     347.973B
     142.654B
     87.351B
     392.537B
    Reveune
     $ 41,91,30,000.00
     $ 17,86,26,000.00
     $ 3,37,46,839.00
     $ 13,21,100.00
     $ 8,95,97,000.00
     $ 3,21,36,962.00
     $ 55,91,51,000.00
    
4. Final Comparables
Key value drivers were applied to na
ow potentially comparable companies for assessing Target Corporation. Final comparable companies are 1) Amazon Inc., 2) Costco Wholesale Corp., 3) Dollar General Corp., 4) TJX Companies Inc., and 5) Walmart Inc.
5. Implied Total Equity Value
Part II - Historical Data for DCF Valuation
Part III – Free Cash Flows Using Sales Driven Approach
1) & 2) The Sales projection along with the income statement analysis is stated as below it is evident that the factors growth rate is computed as per the benchmarks as well as the amounts established in previous computations.
    Amazon Inc
    2021
    2022
    2023
    2024
    2025
    Sales Revenue
    92400
    99653.4
    109140.4
    119530.6
    130909.9
    COGS
    46200
    19930.68
    21828.08
    23906.11
    26181.98
    Selling and Distribution
    13860
    14948.01
    16371.06
    17929.59
    19636.48
    Depreciation
    1848
    1993.068
    2182.808
    2390.611
    2618.198
    Operating Profits...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here