User Tools

Site Tools


syntax:functions

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
syntax:functions [2021/10/24 00:18]
craigt [Financial functions] Add FV
syntax:functions [2021/10/24 00:39] (current)
craigt [Financial functions]
Line 134: Line 134:
 ^Function^Description  ^ ^Function^Description  ^
 |[[syntax:functions:fv|FV]]|Calculates the future value of a loan or an investment, based on a constant interest rate.  | |[[syntax:functions:fv|FV]]|Calculates the future value of a loan or an investment, based on a constant interest rate.  |
-|[[syntax:functions:ipmt|IPMT]]|Calculates the payment on the interest for an investment over a given period.  |+|[[syntax:functions:ipmt|IPmt]]|Calculates the payment on the interest for an investment over a given period.  |
 |[[syntax:functions:nper|NPer]]|Calculates the number of periods for an investment based on periodic payments and interest rate.  | |[[syntax:functions:nper|NPer]]|Calculates the number of periods for an investment based on periodic payments and interest rate.  |
-|[[syntax:functions:pmt|PMT]]|Calculates the periodic payment of an annuity. +|[[syntax:functions:pmt|Pmt]]|Calculates the periodic payment of an annuity. 
-|[[syntax:functions:ppmt|PPMT]]|Calculates the payment on the principal for an investment over a given period.  |+|[[syntax:functions:ppmt|PPmt]]|Calculates the payment on the principal for an investment over a given period.  |
 |[[syntax:functions:pv|PV]]|Calculates the present value of a loan or an investment, based on a constant interest rate.  | |[[syntax:functions:pv|PV]]|Calculates the present value of a loan or an investment, based on a constant interest rate.  |
 |[[syntax:functions:rate|Rate]]|Calculates the interest rate per period of an annuity.  | |[[syntax:functions:rate|Rate]]|Calculates the interest rate per period of an annuity.  |
syntax/functions.txt · Last modified: 2021/10/24 00:39 by craigt