please solve with Excel formula

TUL Search File Home Insert Page Layout Formulas Data Review View Help 388 X A B C D E F G H PARTI How does the equation for valuing a bond change if semiannual payments are made? Find the 1 value of a 10-year, semiannual payment, 10% coupon bond if nominal rd = 13%. 2 33 N 10 34 1/YR 13% 85 CPN % 10% 86 FV $1,000 87 88 PRICE Periods per year 89 Bond valuation Search File Home Insert Page Layout Formulas Data Review View Help 686 A B D E F H 79 80 PARTI How does the equation for valuing a bond change if semiannual payments are made? Find the 81 value of a 10-year, semiannual payment, 10% coupon bond if nominal d = 13%. 82 Solve With excel formula please! 83 N 10 Periods per year 2 84 I/YR 13% 85 CPN % 10% 86 FV $1,000 87 88 PRICE SO