Hi, I need assistance with the problem below. Please include all steps or provide an excel document with formulas:

Hi, I need assistance with the problem below. Please include all steps or provide an excel document with formulas:

Tufte Industries has a bond outstanding with 10 years to maturity, a 6% coupon paid semiannually, and a $1,000 par value. The bond has a 4% nominal yield to maturity, but it can be called in 5 years at a price of $1,060. What is the bond’s nominal yield to call?

Interests paid semi annually,Semi Annaully CouponCurrent PriceCallable PriceSemi annual Callable Period = Yield to Call == Bond's Nominal Yield to call = (Coupon+(Callable Price-Current...