week 5 worksheet

Anonymous
timer Asked: Jul 4th, 2018
account_balance_wallet $15

Question description

need the excel portion done and or the other part would be nice been having issues with this class and am so confused with the math portions

Week Five Financial Exercises HCS/385 Version 3 University of Phoenix Material 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 brief 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 current 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 bonds, find 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 current 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: rWACC = (E/E+D) rE + D/(E+D) rD (1-TC) The formula for the required return on a given equity investment is: ri= 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. rf 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: • Your calculated WACC. • How data was used to calculate WACC. This would be the formula and the formula with your values substituted. • Sources for your data. • A discussion of how much confidence you have in your answer. What were the limiting assumptions that you made, if any? Include a Microsoft® Excel® file showing your WACC calculations discussed above. Click the Assignment Files tab to submit your assignment. Copyright © 2017 by University of Phoenix. All rights reserved. 1

Tutor Answer

Tutor_Booth
School: New York University

Attached.

Source of capital
Market value of equity
Market value of debt

Amount

Cost of debt
Interest expense
Market value of debt
Pretax Cost of debt
Tax rate
After-tax cost of debt

Weight
911,267 89,99%
101,356 10,01%

2,32
101,36
2,29%
40%
1,38%

Cost of equity
Risk-free rate
Beta
Market risk premium
Cost of equity

3,50%
1,15
5%
5,23%

WACC
Source of funding
Debt
Common stock

weight Cost of capital
10%
2,29%
90%
5,23%
WACC

4,93%


Surname 1

Name

Supervisor

Course

Date

WACC calculation: Apple Company

Weighted average cost of capital describes a calculation of the cost of capital of a
business enterprise in which every category of financing is proportionally weighted. All the
financing sources including bonds, preferred stock, common stock, and other long-term
obligations, are emb...

flag Report DMCA
Review

Anonymous
Outstanding Job!!!!

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors