C catslgc Jun 2, 2010 #1 I'm trying to use excell to calculate the present value of a security that will pay $5000.00 in 20 years at 7% interest. PV=FVn/(1+I)N
I'm trying to use excell to calculate the present value of a security that will pay $5000.00 in 20 years at 7% interest. PV=FVn/(1+I)N
T Tom-S Jun 2, 2010 #2 There is a PV function in Excel. Have a look in the Excel built-in Help for more info on how to use the function. Regards, Tom
There is a PV function in Excel. Have a look in the Excel built-in Help for more info on how to use the function. Regards, Tom