please show how to solve this on excel

A. n Group 35 Assume that a 25-year bond with a face value of $1,000 has an 8% coupon rate and is compounded semi-annually. The bond is callable after 15 years at 108% of par value and the market rate in today's market is 7%. What is the value of the bond? (rounded to the nearest number) $1,117 B. $1,240 50 C. $1,120 FV $ 1,000 D. $954 coupon rate 4% $978 semi annual 2 callable after years 30 callable at 108% i E. 3.5% PV called PV at maturity revious Nex