PLEASE SHOW ALL EXCEL WORK

Photochronograph Corporation (PC) manufactures time series photographic equipment. It is currently at its target debtequity ratio of .45. It's considering building a new $37 million manufacturing facility. This new plant is expected to generate after-tax cash flows of $5.1 million in perpetuity. There are three financing options: 1. A new issue of common stock: The required return on the company's new equity is 15 percent. 2. A new issue of 20-year bonds: If the company issues these new bonds at an annual coupon rate of 7 percent, they will sell at par. What is the NPV and IRR and MIRR the of the new plant? Assume that the company has a 35% tax rate