• Mathematical and Financial Functions
  • ABS Function
  • AVERAGE Function
  • CGROUP Function
  • CGROUPT Function
  • COLCOUNT Function
  • COUNTIF function
  • EXP Function
  • FV Function
  • LOG Function
  • Mathematical and Financial Functions
  • MAX Function
  • MEDIAN Function
  • MIN Function
  • MKDEC Function
  • MKINT Function
  • MOD Function
  • POS Function
  • PV Function
  • R Function
  • RATIO Function
  • RC Function
  • RCNV Function
  • RCR Function
  • RCTOTAL Function
  • ROUND Function
  • ROWCOUNT Function
  • RR Function
  • RRTOTAL Function
  • STDDEV Function
  • SUM Function
  • TOTAL Function

PV Function

The PV function calculates the present value factor that you can multiply by the expected cash flow to determine the present value.

Syntax

PV(number of periods, discount rate)

Where the discount rate is expressed as a percentage.

Example

PV(5,8)

Returns the present value of $1 to be received five years from now at the discount rate of 8%. This value can then be multiplied by the actual future value of a cash receipt.

Related Topics

• Mathematical and Financial Functions