ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Present Value (https://www.excelbanter.com/new-users-excel/11607-present-value.html)

DME

Present Value
 
What is the formula to find the PV of a future payment.

I know my payment is going to be $214.29 at 1/1/05. What is the present
value of this payment on 1/1/04 if the interest rate is 10%. Does anyone
have a formula for this?

Thank You.



gls858

DME wrote:
What is the formula to find the PV of a future payment.

I know my payment is going to be $214.29 at 1/1/05. What is the present
value of this payment on 1/1/04 if the interest rate is 10%. Does anyone
have a formula for this?

Thank You.

Click on the function button on the tool bar,
then select financial, then look for the PV function.
It will step you through setting up the formula.

gls858


All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com