26 Jun Proeject number three week 5 FIN 515 6 slides power point
Once again, your team is the key financial management team for your company. The company’s CEO is now looking to expand its operations by investing in new property, plant, and equipment. In order to effectively evaluate the project’s effectiveness, you have been asked to determine the firm’s weighted average cost of capital. To determine the cost of capital, here is what you have been asked to do.
1. Go to Yahoo Finance (http://finance.yahoo.com) and capture the income statement information for the company you selected. (Be sure that your company has debt on their balance sheet. This will be required in your project.)
a. Enter your company’s name or ticker symbol. Your company’s information should appear.
b. Click on the Financials tab, and select the income statement option. Three years’ worth of income statements should appear. Copy and paste this data into a spreadsheet.
c. Repeat step b. above for the balance sheets of the company.
d. Click on “Historical Prices.” Capture the closing price of the stock as of the balance sheet date for the three fiscal years used in steps b and c above.
2. Calculate the Weighted Average Cost of Capital (WACC) for the company:
a. Cost of Debt
i. Determine the market value of the firm’s debt issues. Be sure to review the firm’s 10-K. Also, the website http://finra-markets.morningstar.com/BondCenter may be of assistance.
ii. You will need to calculate the firm’s composite YTM on its bonds. This can be achieved by calculating a weighted-average YTM for its bond issues.
iii. After calculating the YTM for the bond issues, calculate the firm’s after-tax cost of debt. If the firm’s marginal tax rate cannot be identified in its 10-K, assume that the tax rate will be 35%.
b. Cost of Equity
i. Calculate the firm’s cost of equity using the capital asset pricing model (CAPM). The formula for the CAPM is ri = rf + βi × (RMkt – rf).
ii. Assume the risk-free rate (rf) is the current rate of 10-year U.S. Treasury Bonds.
iii. Calculate the market rate (RMkt) by calculating the market return on the Standard & Poor’s 500 for the past 2 calendar years.
iv. The beta for the firm can be obtained from Yahoo! Finance.
c. Calculate the WACC
i. Determine the market capitalization of the firm’s common equity and preferred equity, if any.
ii. Determine the firm’s capital structure based on the market value of the firm’s equity and debt. The market value of the firm’s debt can be obtained from the Morningstar website, listed in the Cost of Debt section above.
iii. Calculate the WACC. As you recall, the formula for WACC is rWACC = E ÷ (E + D) rE + D ÷ (E + D) rD (1 – TC).
Deliverable
Prepare a narrated PowerPoint presentation using VoiceThread or WebEx that shows the steps you performed to calculate the WACC for your firm. Feel free to embed your Excel spreadsheets in the presentation to demonstrate your calculations. Be sure to discuss how the values were obtained or derived to arrive at your WACC result. Finally, be sure to discuss any strengths or limitations in the calculations you performed, and discuss your analysis about the overall validity of your results. Both members of the team must be part of the narration in the presentation.
Grading Rubric
1
FIN515: Week 6 Project
–
Calculating the Weighted Average Cost of
Capital
1
Once again, your team is the key financial management team for your company.
The
company’s
CEO
is
now
looking
to
expand
its
operations
by
investing
in
new
property,
plant,
and
equipment.
In
order
to
effectively
evaluate
the
project’s
effectiveness,
you
have
been
asked
to
determine
the
firm’s
weighted
average
cost
of
capital.
To
determine
the
cost
o
f
capital,
here
is
what
you
have
been
asked
to
do.
1.
Go to Yahoo Finance (
http://finance.yahoo.com
) and capture the income statement information
for the company you selected.
(Be sure that your company has debt on th
eir balance sheet. This
will be required in your project.)
a.
Enter your company’s name or ticker symbol. Your company’s information should
appear.
b.
Click on the
Financials
tab, and select the income statement option. Three years’ worth
of income statements sh
ould appear. Copy and paste this data into a spreadsheet.
c.
Repeat step b. above for the balance sheets of the company.
d.
Click on “Historical Prices.” Capture the closing price of the stock as of the balance sheet
date for the three fiscal years used in steps
b and c above.
2.
Calculate the Weighted Average Cost of Capital (WACC) for the company:
a.
Cost of Debt
i.
Determine
the
market
value
of
the
firm’s
debt
issues.
Be
sure
to
review
the
firm’s
10
–
K.
Also,
the
website
http://finra
–
markets.morningstar.com/BondCenter
may be of assistance.
ii.
You
will
need
to
calculate
the
firm’s
composite
YTM
on
its
bonds.
This
can
be
achieved
by
calculating
a
weighted
–
average
YTM
for
its
bond
issues.
iii.
After
calculating
the
YT
M
for
the
bond
issues,
calculate
the
firm’s
after
–
tax
cost
of
debt.
If
the
firm’s
marginal
tax
rate
cannot
be
identified
in
its
10
–
K,
assume
that
the
tax
rate
will
be
35%.
b.
Cost
of
Equity
i.
Calculate
the
firm’s
cost
of
equity
using
the
capital
asset
pricing
model
(CAPM).
The
formula
for
the
CAPM
is
r
i
=
r
f
+ â
i
× (
R
Mkt
–
r
f
).
ii.
Assume
the
risk
–
free
rate
(
r
f
)
is
the
current
rate
of
10
–
year
U.S.
Treasury
Bonds.
iii.
Calculate
the
market
rate
(
R
Mkt
)
by
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.