USING EXCEL FORMULAS ONLY AND SHOWING ALL WORK: COST OF DEBT USING THE APPROXIMATION FORMULA: For each of the following $1,000 par value bonds, assuming annual interest payment and a 21% tax rate, please calculate the after-tax cost to maturity using the approximation formulaB

Bond	Life (yrs)	Underwriting Fee	Discount(-) or Premium(+)	Coupon Interest Rate
A	20	$25	-$20	9%
B	16	40	+10	10
C	15	30	-15	12
D	25	15	par	9
E	22	20	-60	11