Question

Can you please show this in excel with formulas? And with showing where each # is derived from?

Ying Import has several bond issues outstanding, each making semiannual interest payments. The bonds are listed in the table below.

Bond	Coupon Rate		Price Quote	Maturity		Face Value
1	8.90	%	105.4	3	years	$	24,000,000
2	6.60		95.0	6	years		44,000,000
3	8.60		104.2	13.5	years		49,000,000
4	9.10		106.1	23	years		64,000,000

If the corporate tax rate is 35 percent, what is the aftertax cost of the company’s debt? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
  
Aftertax cost of debt              %

Answer 1