Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less Show PV, one of the financial functions, calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that's your investment goal.
Use the Excel Formula Coach to find the present value (loan amount) you can afford, based on a set monthly payment. At the same time, you'll learn how to use the PV function in a formula. Or, use the Excel Formula Coach to find the present value of your financial investment goal. SyntaxPV(rate, nper, pmt, [fv], [type]) The PV function syntax has the following arguments:
Remarks
(pmt * nper) + pv + fv = 0 ExampleCopy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. For formulas to show results, select them, press F2, and then press Enter. If you need to, you can adjust the column widths to see all the data.
Need more help?What is the sum of future values of all payments to be made during the entire terms of the annuity?The future value of any annuity equals the sum of all the future values for all of the annuity payments when they are moved to the end of the last payment interval. For example, assume you will make $1,000 contributions at the end of every year for the next three years to an investment earning 10% compounded annually.
What is the sum of present values of all the payments to be made during the entire term?Yes, the sum of the present value of all the payments to be made during the entire term of the annuity. The present value of a future sum of money or stream of cash flows with a preset rate of return is the sum of money or stream of cash flows' current worth (PV).
What is the future value of an annuity?The future value of an annuity is the value of a group of recurring payments at a certain date in the future, assuming a particular rate of return, or discount rate. The higher the discount rate, the greater the annuity's future value.
What is the time between successive payments?A payment interval is the time between successive payments.
|