Can you please use Excel and provide =formulatext so I can follow work. Cheers!

3. Zero Coupon Bonds Suppose your company needs to raise $50 million and you want to issue 30-year bonds for this purpose. Assume the required return on your bond issue will be 6 percent, and you're evaluating two issue alternatives: a semiannual coupon bond with a 6 percent coupon rate, and a zero coupon bond. Your company's tax rate is 35 percent. a. How many of the coupon bonds would you need to issue to raise the $50 million? How many of the zeroes would you need to issue? b. In 30 years, what will your company's repayment be if you issue the coupon bonds? What if you issue the zeroes