Question: 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%.

 Your last challenge is to value the bond using Excel. Use

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 in to the space below, then click "Submit" to check your work. Present Value function: =PV(rate, nper, pmt, [fv], [type]) You can ignore [type] for bond valuation. Hint: Don't forget to enter the yield per payment period (semiannual). You may enter this number as a percent (3.625% or a decimal (.03625). Make sure you include the " " before the formula. Check out an example

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!