This case study requires you to do some research (company selection, information collection, calculation, etc.). The mini lecture in Chapter 9 provides guidance on this assignment.casestu
This case study requires you to do some research (company selection, information collection, calculation, etc.). The mini lecture in Chapter 9 provides guidance on this assignment.
Case Study #3
| Case Study | |||||||
| You want to calculate the WACC for a public company (your choice). Complete the following steps to construct a spreadsheet that can be updated. | |||||||
| a. | State the company that you chose. Find out the company's ticker symbol, create hyperlinks to the web pages that you will need to find all of the information necessary to calculate the cost of equity. Use a market risk premium of seven percent when using CAPM. | ||||||
| Ticker symbol: | |||||||
| Stock quote link | |||||||
| Stock price: | $ | ||||||
| Dividend: | $ | ||||||
| Key statistics link | |||||||
| Beta: | |||||||
| Shares outstanding: | |||||||
| Bond center link: | |||||||
| Risk-free rate: | |||||||
| Market risk premium: | 7.00% | ||||||
| Market value of equity: | |||||||
| Cost of equity | |||||||
| CAPM: | |||||||
| b. | Create hyperlinks to the FINRA bond quote website and the SEC EDGAR database and find the information for the company's bonds. Create a table that calculates the cost of debt for the company. Assume the tax rate is 35 percent. | ||||||
| (Assume the target capital structure equals to the market value weight) | |||||||
| Maturity | YTM | Quoted Price | Book Value | Market Value | Market Value Weight | Weighted cost of debt | |
| 0.000% | |||||||
| 0.000% | |||||||
| 0.000% | |||||||
| 0.000% | |||||||
| 0.000% | |||||||
| 0.000% | |||||||
| 0.000% | |||||||
| Total market value = | $ – | Cost of debt = | 0.000% | ||||
| Tax rate: | 35% | ||||||
| Aftertax cost of debt: | |||||||
| Cost of equity: | |||||||
| Market value of equity: | $ | ||||||
| Aftertax cost of debt: | |||||||
| Market value of debt: | $ | ||||||
| c. | Finally, calculate the market value weights for debt and equity. What is the WACC for the company? | ||||||
| Weight of debt: | |||||||
| Weight of equity: | |||||||
| WACC: |
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
