Great Lakes Packing has two bond issues outstanding. The first issue has a coupon rate of 3.48 percent, a par value of $1,000 per bond, matures in 7 years, has a total face value of $3.5 million, and is quoted at 108 percent of face value. The second issue has a coupon rate of 5.86 percent, a par value of $2,000 per bond, matures in 20 years, has a total face value of $7.8 million, and is quoted at 94 percent of face value. Both bonds pay interest semiannually. The company's tax rate is 39 percent. What is the firm's weighted average aftertax cost of debt?

Answers:

2.48%

4.98%

4.01%

2.63%

2.95%

If possible please show work in excel. Thanks!