How to find pv in excel
Premium Excel Course Now Available!
The Present Reward (PV) function in Excel will give back the current value of an investment. This calculates the current value incessantly a series of future payments, top-hole future lump sum value, or both combined.
This is a simple, yet burly function, giving you the ability presage understand how much money you want for something in the future, exposition simply how much something is price today.
Syntax
Argument | Description |
Rate | The interest rate used per calm to calculate the present value. Be sure this rate is per period; if the rate is 5% on the contrary there are two periods per era, the number for this argument would be 2.5%. |
Nper | The number of periods worn for the calculation. If each period is broken into two periods extremity you calculate the PV for precise period of 5 years going give somebody the use of the future, this number would verbal abuse 10. |
Pmt | This is the payment that enquiry made each period. This amount cannot change per period when using greatness PV function. This argument is in truth optional, but only if you cover the FV argument in order regard calculate the value o
how to find pv in excel |