Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
| syntax:functions [2021/10/23 23:53] – [Financial functions] Add PV craigt | syntax:functions [2021/10/24 00:39] – [Financial functions] craigt |
|---|
| ===== Financial functions ===== | ===== Financial functions ===== |
| ^Function^Description ^ | ^Function^Description ^ |
| |[[syntax:functions:ipmt|IPMT]]|Calculates the payment on the interest for an investment over a given period. | | |[[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: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. | |
