Homework

Use the attached Excel file for ABC Company. 

1. Calculate cost of equity
2. Calculate WACC
3. ABC's stocks are not currently listed on a stock exchange. Suppose ABC issues all its stocks in an IPO. After the IPO the company has 3.5 million shares, worth $2.5 each. What is the WACC after the IPO?