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

# Insert Title HCS/385 v4 Week Five Financial Exercises HCS/385 v4 Page 2 of 2 Week Five Financial Exercises Your task is to determine the WACC for a given firm using what you know about WACC, as well...

Insert Title
HCS/385 v4
Week Five Financial Exercises
HCS/385 v4
Page 2 of 2
Week Five Financial Exercises
Your task is to determine the WACC for a given firm using what you know about WACC, as well as data you can find through research. Your deliverable is a
ief report in which you state your determination of WACC, describe and justify how you determined the number, and provide relevant information as to the sources of your data.
Select a publicly traded company that has debt or bonds and common stock to calculate the cu
ent WACC. One good source for financial data for companies, as well as data about their equity, is Yahoo! Finance. By looking around this site, you should be able to find the market capitalization (E) as well as the Î² for any publicly traded company.
There are not many places left where data about corporate bonds is still available. One of them is the Finra Bonds website. To find data for a particular companyâ€™s publicly traded bonds use the Quick Search feature, then be sure to specify corporate bonds and type in the name of the issuing company. This should give you a list of all of the companyâ€™s outstanding bond issues. Clicking on the symbol for a given bond issue will lead you to the cu
ent amount outstanding and the yield to maturity. You are interested in both. The total of all bonds outstanding is D in the above formula.
If you like, you can use the YTM on a bond issue that is not callable as the pre-tax cost of debt for the company.
Assumptions:
As you recall, the formula for WACC is:
WACC = (E/E+D) rE + D/(E+D) rD (1-TC)
The formula for the required return on a given equity investment is:
i= rf + Î²i * (RMkt-rf)
RMkt-rf is the Market Risk Premium. For this project, you may assume the Market Risk Premium is 5% unless you can develop a better number.
f is the risk-free rate. The risk-free rate is normally the yield on US Treasury securities such as a 10-year treasury. For this assignment, please use 3.5%.
You may assume a corporate tax rate of 40%.
Submit the following:
Write a 350- to 700-word report that contains the following elements:
Â· How data was used to calculate WACC (provide the formula and the formula with your values substituted)
Â· A discussion of how much confidence you have in your answer, including what the limiting assumptions you made were, if any
Include a MicrosoftÂ® ExcelÂ® file showing your WACC calculations discussed above.
Answered Same Day Jun 30, 2021

## Solution

Neenisha answered on Jul 01 2021
Weighted Average Cost of Capital (WACC)
Pfizer Inc. (PFE)
Equity
\$ 1,81,42,10,00,000
Debt
\$ 35,95,50,00,000

Cost of Equity

Risk Free Rate
3.50%
5%
Beta
0.69
Cost of Equity
6.95%

Cost of Debt
2.49%
Tax Rate
40%

WACC
6.05%
The computed WACC is 6.05%
To compute WACC, we used the formula
WACC =
Debt was obtained from the Morningstar website as the sum of all the corporate bonds. The Outstanding amount of all the corporate bonds were added to obtain the debt...
SOLUTION.PDF

More Questions Â»

### Submit New Assignment

Copy and Paste Your Assignment Here