User Tools

Site Tools


syntax:functions:pv

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
Last revisionBoth sides next revision
syntax:functions:pv [2021/10/23 23:50] – created craigtsyntax:functions:pv [2021/10/24 00:36] – [Examples] craigt
Line 9: Line 9:
 =====Additional syntax===== =====Additional syntax=====
 Optional //future value// (fut_val) argument. Optional //future value// (fut_val) argument.
-  PV(rate, num_per, payment, fut_val)+  pv(rate, num_per, payment, fut_val)
 \\  \\ 
 Optional //payments due// (pay_due) argument. Optional //payments due// (pay_due) argument.
-  PV(rate, num_per, payment, fut_val, pay_due)+  pv(rate, num_per, payment, fut_val, pay_due)
  
 \\  \\ 
Line 35: Line 35:
   pv( (0.10/12), 36, -225) //Returns $6973.03 (months, rounded)   pv( (0.10/12), 36, -225) //Returns $6973.03 (months, rounded)
 \\  \\ 
-** Calculate the present value:**  Interest rate is 14% (annual), payment is $6000 per year, final value is $30,000, payments due at the end of the period.+** Calculate the present value:**  Interest rate is 14% (annual), payment is $6000 per year, final value is $30,000.
   pv(0.14, 10, -6000, 30000) //Returns $23,204.38 (rounded)   pv(0.14, 10, -6000, 30000) //Returns $23,204.38 (rounded)
 \\  \\ 
syntax/functions/pv.txt · Last modified: 2021/10/24 00:36 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki