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?
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?