Question
Refer to the Excel workbook titled WACC_Project_FinancialStatements.xlsx for financial information and additional information in the bulleted list below The firm has 25 million shares of
Refer to the Excel workbook titled WACC_Project_FinancialStatements.xlsx for financial information and additional information in the bulleted list below The firm has 25 million shares of common stock outstanding. The beta is 1.4. The firm plans to increase dividends by 25% each year for the next 2 years and then by 3% per
year after that. The expected return on the market portfolio is 13% and the risk-free rate is 3.5%. The firm has three bond issues outstanding. All bonds make annual coupon payments. o Bond 1 is a 5% coupon bond with face value of $1000. The YTM is 4% and the bonds
mature in 14 years. There are 10,000 of these bonds. o Bond 2 is a zero coupon bond with face value of $5000. The YTM is 3% and the bonds mature in 22 years. There are 4,000 of these bonds. o Bond 3 is a 7% coupon bond with face value of $1000. The YTM is 5.5% and the bonds mature in 7 years. There are 65,000 of these bonds. The firm has 250,000 shares of preferred stock outstanding that pay a dividend of $5 per share annually. The current price of a share of preferred stock is $65. The companys average tax rate is 30%. 1. Find WACC using market values:
a. Find the cost of equity using CAPM. b. Find the stock price using the dividend growth model. c. Find the cost of debt by taking a weighted average of the bonds YTMs:
i. Find bond value for each bond. ii. Find total value for each of the bond issues outstanding. iii. Use i. and ii. to find the weights and the YTMs to find the weighted average YTM. d. Find the total market value of equity using your answer to b. and the number of shares outstanding. e. Find the cost of preferred stock. f. Find Wd, We, and Wp using market values. g. Plug the numbers into the WACC formula to get the market value-based WACC.
2. Find WACC using book values and ignoring the preferred stock: a. Find the cost of equity using CAPM (already did this) b. Find the weights using the most recent balance sheet.
c. Use your cost of debt from #1c above. d. Plug the numbers in the WACC formula to get a book value-based WACC.
| All numbers in $thousands | 2008 | 2009 |
| Sales | $305,830.00 | |
| Cost of Goods Sold | $210,935.00 | |
| Depreciation | $26,850.00 | |
| EBIT | $68,045.00 | |
| Interest | $11,930.00 | |
| Taxable Income | $56,115.00 | |
| Taxes (35%) | $19,640.25 | |
| Net income | $36,474.75 | |
| Dividends | $19,999.75 | |
| Retained Earnings | $16,475.00 | |
| Cash | $21,860.00 | $22,050.00 |
| Accounts Receivable | $11,316.00 | $13,850.00 |
| Inventory | $23,084.00 | $24,650.00 |
| Total Current Assets | $56,260.00 | $60,550.00 |
| Fixed Assets | $340,000.00 | $393,307.00 |
| Accumulated Depreciation | $105,932.00 | $132,782.00 |
| Net Fixed Assets | $234,068.00 | $260,525.00 |
| Total Assets | $290,328.00 | $321,075.00 |
| Accounts Payable | $19,320.00 | $22,850.00 |
| Notes Payable | $19,643.00 | $20,385.00 |
| Total Current Liabilities | $38,963.00 | $43,235.00 |
| Long-term Debt | $75,000.00 | $85,000.00 |
| Total Debt | $113,963.00 | $128,235.00 |
| Comon Stock | $25,000.00 | $25,000.00 |
| Accumulated Retained Earnings | $151,365.00 | $167,840.00 |
| Total Equity | $176,365.00 | $192,840.00 |
| Total Debt and Equity | $290,328.00 | $321,075.00 |
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
Equity Asset Valuation
Authors: Jerald E Pinto, CFA Institute
3rd Edition
1119850517, 978-1119850519
