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?