CHALLENGE S Your last challenge is to value the bond using Excel. Use the PV formula (see below) and assume an annual yield to maturity of 7.25%. Enter your answer into the space below, Face then click "Submit" to check your work. Value (fv) Present Value function: -PV(rate, nper, pmt, (fv), (type]) You can ignore (type) for bond valuation. $5000 Hint: Don't forget to enter the yield per payment Remaining Coupon period (semiannual). You may enter this number Payments Payment as a percent (3.625%) or a decimal (.03625). (nper) (pmt) Make sure you include the "=" before the formula. 10 $181.25 Check out an example. Answer: $ Submit