Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision |
syntax:functions [2021/10/24 00:18] – [Financial functions] Add FV craigt | syntax:functions [2021/10/24 00:39] – [Financial functions] craigt |
---|
^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. | |