Question
Once again, your team is the key financial management team for your company. The companys CEO is now looking to expand its operations by investing
Once again, your team is the key financial management team for your company. The companys CEO is now looking to expand its operations by investing in new property, plant, and equipment. In order to effectively evaluate the projects effectiveness, you have been asked to determine the firms 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 companys name or ticker symbol. Your companys 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 firms debt issues. Be sure to review the firms 10-K. Also, the website http://finra-markets.morningstar.com/BondCenter may be of assistance.
ii. You will need to calculate the firms 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 firms after-tax cost of debt. If the firms 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 firms 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 & Poors 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 firms common equity and preferred equity, if any.
ii. Determine the firms capital structure based on the market value of the firms equity and debt. The market value of the firms 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).
URGENT: NEED ANSWER ASAP
PLEASE RESPOND WITH COPY AND PASTE, NOT ATTACHMENT USE ORIGINAL CONTENT NOT USED BEFORE ON CHEGG
PLEASE ANSWER THROUGHLY TO ALL ANSWER TO BEST ABILITES ORIGINAL SOURCE NEVER USED BEFORE!!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started