Differences

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

--- syntax:functions:pv [2021/10/23 23:51] – craigt
+++ syntax:functions:pv [2021/10/24 00:36] (current) – [See also] updated See Also section craigt
@@ Line 35: / Line 35: @@
   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)
 \\
@@ Line 43: / Line 43: @@
 \\
 ===== See also =====
-  * [[syntax:functions:ppmt|PMT(rate, num_per, curr_val)]]
+  * [[syntax:functions:fv|FV(rate, num_per, payment)]]
-  * [[syntax:functions:ppmt|PPMT(rate, num_per, curr_val)]]
+  * [[syntax:functions:nper|NPer(rate, payment, curr_val)]]
+  * [[syntax:functions:ipmt|IPmt(rate, per, num_per, curr_val)]]
+  * [[syntax:functions:pmt|Pmt(rate, num_per, curr_val)]]
+  * [[syntax:functions:ppmt|PPmt(rate, num_per, curr_val)]]
+  * [[syntax:functions:rate|Rate(num_per, payment, curr_val)]]