complete the problems using Excel formula.

P-9: Approximate yield to maturity and cost of debt (LO11-3) Airborne Airlines Inc. has a $1,000 par value bond outstanding with 25 years to maturity. The bond carries an annual interest payment of $88 and is currently selling for $950. Airborne is in a 25 percent tax bracket. The firm wishes to know what the aftertax cost of a new bond issue is likely to be. The yield to maturity on the new issue will be the same as the yield to maturity on the old issue because the risk and maturity date will be similar. a. Compute the yield to maturity on the old issue and use this as the yield for the new issue. b. Make the appropriate tax adjustment to determine the aftertax cost of debt. P.10: Approximate yield to maturity and cost of debt (Lo11-3) Russell Container Corporation has a $1,000 par value bond outstanding with 30 years to maturity. The bond carries an annual interest payment of $105 and is currently selling for $880 per bond. Russell Corp, is in a 25 percent tax bracket. The firm wishes to know what the aftertax cost of a new bond issue is likely to be. The yield to maturity on the new issue will be the same as the yield to maturity on the old issue because the risk and maturity date will be similar. a. Compute the yleld to maturity on the old issue and use this as the yield for the new issue. b. Make the appropriate tax adjustment to determine the aftertax cost of debt