Reference no: EM131381807
Assignment: Project - Calculating the Weighted Average Cost of Capital
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 (https://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 https://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.
|
Sequences of positive numbers
: 1) Prove that if xn → ∞, then the sequence {xn/1+xn} converges. Is the converse true? Justify your answer. 2) a)Suppose {an} and {bn} are sequences of positive numbers, an → ∞, and(1) limn→∞an/bn= α for some α ∈ R. Show that bn → ∞.
|
|
Explain what the margin of error means
: Margin of error. A medical researcher estimates the percentage of children exposed to lead-base paint, adding that he believes his estimate has a margin of error of about 3%. Explain what the margin of error means.
|
|
Linear relationship between the two variables
: In a regression, the F statistic value is 6.3. Assume the sample size used was n = 104, and conduct an F test for the existence of a linear relationship between the two variables.
|
|
What led to the development of each policy
: The policy that will be covered in this assignment is domestic violence. I just need two (2) slides with very detailed speaker notes in each slide. The two (2) states that we are comparing to are the state of florida and the state of north carolin..
|
|
Calculate the firms cost of equity using the capm
: FIN515- 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). Assume the risk-free rate (rf) is the current rate of 10-year U.S. Treasury Bonds.
|
|
Conduct an f test for the existence of a linear relationship
: In a simple linear regression analysis, it is found that b1 = 2.556 and s(b1) = 4.122. The sample size is n = 22. Conduct an F test for the existence of a linear relationship between the two variables.
|
|
Complete celebrity catering service inc form 1120
: Rachael Ray, Paula Deen and Gordon Ramsay each own one-third of the common stock of Celebrity Catering Services, Inc. (CCS). Complete Celebrity Catering Service Inc.'s (CCS) Form 1120 and all related schedules. Be sure to attach schedules for any li..
|
|
Is there any apparent model inadequacy
: Produce residual plots for the regression of given problem. Is there any apparent model inadequacy?- Run a simple linear regression of these five pairs of numbers and estimate a linear relationship between income and percentage growth in wealth.
|
|
What would happen if the population was left unattended
: CJHS420:Identify the characteristics and specific needs of the selected special population.Describe how the problems associated with your special population can be resolved.What would happen if the population was left unattended and not managed prope..
|