View the step-by-step solution to:

Question


Please select from the list of companies below to complete problem. In addition to the company's

investor relations webpage you may use other finance-related resources (e.g. Yahoo! Finance).

GROUP A COMPANIES (Consumer Goods - Textile - Apparel Clothing)

 Columbia Sportswear Company (COLM)

o http://investor.columbia.com/financials.cfm

 Ralph Lauren Corporation (RL)

o http://investor.ralphlauren.com/phoenix.zhtml?c=65933&p=irol-irhome

 Capri Holdings Limited (CPRI)

o http://www.capriholdings.com/corporate-overview/default.aspx

GROUP B COMPANIES (Consumer Goods - Toys & Games and Entertainment - Diversified)

 Mattel Inc. (MAT)

o https://mattel.gcs-web.com/investor-relations

 Hasbro Inc. (HAS)

o https://investor.hasbro.com/investor-relations

 The Walt Disney Company (DIS)

o http://thewaltdisneycompany.com/investors


Choosing 2 companies (i.e. 1 from Group A and 1 from Group B).

You work in the corporate finance and treasury department and have just been assigned to the team estimating the company's WACC. You must estimate this WACC in preparation for a team meeting later today. You quickly realize that the information you need is readily available online.

1. Go to the Yahoo! Finance website, http://finance.yahoo.com/ . Under "Market Data," you will find the yield to maturity for 10-year treasury bonds. Collect this number as your risk-free rate.

2. In the box, "Quote Lookup", type in the company's ticker symbol and press enter. Once you see the basic information, find and click on "Key Statistics". From the key statistics, collect the information for the company's market capitalization (its market value of equity), enterprise value (market-value equity + net debt) (note: enterprise value is the total market value of a firm's equity and debt, less the value of its cash and marketable securities), cash and beta.

3. To get the cost of debt, you will need the yield to maturity on the firm's existing long-term bonds. Go to the Financial Industry Regulatory Authority's website, www.finra.org , click on "Investors" and then, under "Market Data Center," click on "Bonds." Under "Search," click on "Corporate" and type in the ticker symbol. A list of the company's outstanding bond issues will appear. Find the yield to maturity for your chosen bond issue (i.e. close to 10 years from maturity) (it is in the column titled "Yield") and use this as your pre-tax cost of debt. (Note: If this information is not available or hard to obtain with FINRA then use as a reference, comparable companies with similar credit ratings.)

4. Compute the weights for equity and debt based on the market value of equity and market value of debt.

5. Calculate the company's cost of equity capital using the CAPM, the risk-free rate you collected, and a market risk premium of 5%. If the company has preferred shares, you will need to consider cost of

preferred shares.

6. Assume that the company has a tax rate of 35%, calculate the effective (after-tax) cost of debt capital.

7. Calculate the company's WACC using the market value of equity and debt.

8. Calculate the company's net debt by subtracting its cash (collected in step 2) from its debt. Recalculate

the weights for the WACC using the market value of equity, net debt, and enterprise value (note: enterprise value is the total market value of a firm's equity and debt, less the value of its cash and marketable securities). Recalculate the company's WACC using the weights based on the net debt. How much does it change?

9. How confident are you of your estimates in steps 7 and 8? Which implicit assumptions did you make during your data collection efforts?


C014A738-C73B-4C13-8E38-C3A7E06C6C41.png05F5230A-00C6-4E59-ABCA-D5172E381739.png6C1BD152-CBB3-4EF9-938C-87253ED2CBF0.png

05F5230A-00C6-4E59-ABCA-D5172E381739.png

J:‘F’l1139 8515 E]- i inst—fs—yul—prod.inscloudgate.net o) 67% E} Complete this problem twice by choosing 2 companies (i.e. 1 from Group A and 1 from Group B). You work in the corporate finance and treasury department and have just been assigned to the team estimating
the company‘s WACC. You must estimate this WACC in preparation for a team meeting later today. You quickly
realize that the information you need is readily available online. N Go to the Yahoo! Finance website, httpzllfinance.yahoo.com[ . Under "Market Data," you will find the
yield to maturity for 10-year treasury bonds. Collect this number as your risk-free rate. In the box, "Quote Lookup", type in the com pany‘s ticker symbol and press enter. Once you see the basic
information, find and click on "Key Statistics". From the key statistics, collect the information for the
company‘s market capitalization (its market value of equity), enterprise value (market-value equity + net
debt) (note: enterprise value is the total market value of a firm ’5 equity and debt, less the value of its cash
and marketable securities), cash and beta. To get the cost of debt, you will need the yield to maturity on the firm‘s existing long-term bonds. Go to
the Financial Industry Regulatory Authority's website, www.finra.org , click on "Investors" and then, under
"Market Data Center," click on "Bonds." Under "Search," click on "Corporate" and type in the ticker
symbol. A list of the company‘s outstanding bond issues will appear. Find the yield to maturity for your
chosen bond issue (i.e. close to 10 years from maturity) (it is in the column titled "Yield") and use this as
your pre-tax cost of debt. (Note: If this information is not available or hard to obtain with FINRA then use
as a reference, comparable companies with similar credit ratings.) Compute the weights for equity and debt based on the market value of equity and market value of debt.
Calculate the company‘s cost of equity capital using the CAPM, the risk-free rate you collected, and a
market risk premium of 5%. if the company has preferred shares, you will need to consider cost of
preferred shares. Assume that the company has a tax rate of 35%, calculate the effective (after-tax) cost of debt capital.
Calculate the company‘s WACC using the market value of equity and debt. Calculate the company’s net debt by subtracting its cash (collected in step 2) from its debt. Recalculate
the weights for the WACC using the market value of equity, net debt, and enterprise value (note:
enterprise value is the total market value of a firm’s equity and debt, less the value of its cash and

6C1BD152-CBB3-4EF9-938C-87253ED2CBF0.png

LCF‘l‘liSQ 8H1E| @1331 ‘3: EE—T, 1511mm: X D https://inst-fs-yul-prod.insc X D https://parking.utm.utoront X HomeworkHelp-Q&Afrom X
< C i inst—fs—yul—prod.inscloudgate.net .9 fi [1] no
the Financial Industry Regulatory Authority's website, www.finra.org , click on "Investors" and then, under
2/5 "Market Data Center," click on "Bonds." Under "Search," click on "Corporate" and type in the ticker symbol. A list of the company‘s outstanding bond issues will appear. Find the yield to maturity for your
chosen bond issue (i.e. close to 10 years from maturity) (it is in the column titled "Yield") and use this as
your pre-tax cost of debt. (Note: If this information is not available or hard to obtain with FINRA then use
as a reference, comparable companies with similar credit ratings.) 4. Compute the weights for equity and debt based on the market value of equity and market value of debt. 5. Calculate the company‘s cost of equity capital using the CAPM, the risk-free rate you collected, and a
market risk premium of 5%. If the company has preferred shares, you will need to consider cost of
preferred shares. 6. Assume that the company has a tax rate of 35%, calculate the effective (after-tax) cost of debt capital. 7. Calculate the company‘s WACC using the market value of equity and debt. 8. Calculate the company’s net debt by subtracting its cash (collected in step 2) from its debt. Recalculate
the weights for the WACC using the market value of equity, net debt, and enterprise value (note:
enterprise value is the total market value of a firm's equity and debt, less the value of its cash and
marketable securities). Recalculate the company‘s WACC using the weights based on the net debt. How
much does it change? 9. How confident are you of your estimates in steps 7 and 8? Which implicit assumptions did you make
during your data collection efforts?

C014A738-C73B-4C13-8E38-C3A7E06C6C41.png

1 411:39 8A1: AL
68%
a inst-fs-yul-prod.inscloudgate.net
Problem 1 - Cost of Capital (50 Marks)
Please select from the list of companies below to complete this problem. In addition to the company's investor
relations webpage you may use other finance-related resources (e.g. Yahoo! Finance).
GROUP A COMPANIES (Consumer Goods - Textile - Apparel Clothing)
. Columbia Sportswear Company (COLM)
o http://investor.columbia.com/financials.cfm
.
Ralph Lauren Corporation (RL)
o http://investor.ralphlauren.com/phoenix.zhtml?c=65933&p=irol-irhome
. Capri Holdings Limited (CPRI)
o http://www.capriholdings.com/corporate-overview/default.aspx
GROUP B COMPANIES (Consumer Goods - Toys & Games and Entertainment - Diversified)
.
Mattel Inc. (MAT)
o https://mattel.gcs-web.com/investor-relations
. Hasbro Inc. (HAS)
o https://investor.hasbro.com/investor-relations
.
The Walt Disney Company (DIS)
o http://thewaltdisneycompany.com/investors

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question