Ask a New Question
Search
Questions and answers by
mipi
Answers (2)
Bond Yield Example Data A B 1 FV 1000 2 Annual Coupon Rate 7.5% 3 Annual Return 5.5% 4 Years to Maturity 14 5 Years 1 6 Payment Frequency 1 7 Value of Bond 1191.79 PUT THIS IN EXCEL AND YOU HAVE A CALCULATOR VALUE OF BOND= =-PV(B4/B7,B5*B7,B3/B7*B2,B2)
Bond Yield Example Data A B 1 FV 1000 2 Annual Coupon Rate 7.5% 3 Annual Return 5.5% 4 Years to Maturity 14 5 Years 1 6 Payment Frequency 1 7 Value of Bond 1191.79 PUT THIS IN EXCEL AND YOU HAVE A CALCULATOR VALUE OF BOND= =-PV(B4/B7,B5*B7,B3/B7*B2,B2)