present value function

D

DAB

I am trying to use the PV Function to calculate present value of a bond with
a face vaule of $1.5, 20 years, 12% stated rate paid semi annual with an
effective rate of 10. When I input the data using this function
=PV(5,20,-90000,-1500000) - the value comes out as $18,000 and it should be
1,686,934 - what am I doing wrong?
 
F

Fred Smith

First, pv and pmt in your formula need different signs, because you pay for the
bond, but receive the interest.

Second, you need to specify the interest rate as 5%, not 5.

Third, the period of your interest rate and term must match. You have 5%
semi-annual interest, therefore you have 40 semi-annual periods.

Fourth, what you really want is the Price function (in the Analysis Tookpak). It
will calculate the price of the bond properly for you, which you can then
multiply by the face amount to get the present value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top