Present value is calculated by taking the future cashflows expected from an investment and discounting them back to the present day. To do so, the investor needs three key data points: the expected cashflows, the number of years in which the cashflows will be paid, and their discount rate.

What is an example of present value?

Present value is the value right now of some amount of money in the future. For example, if you are promised $110 in one year, the present value is the current value of that $110 today.

How does the present value formula work?

Present value (PV) is the current value of a stream of cash flows. PV can be calculated in excel with the formula =PV(rate, nper, pmt, [fv], [type]). If FV is omitted, PMT must be included, or vice versa, but both can also be included. NPV is different from PV, as it takes into account the initial investment amount.