Page
|
|
|
Next Page |
|
| Contents > Functions reference (alphabetical list) > Financial functions > FV function |
|
|
| FV function |
| Format |
FV(payment;interestRate;periods) |
| Parameters |
| payment - payment to be made per period |
| interestRate - interest rate per period |
| periods - number of periods |
| Data type returned |
| number |
| Description |
| Notes |
 |
When interestRate is 0, this function returns the result of payment * periods. |
|
The FV function doesn't account for the present value of your investment, and it assumes that payment is made at the end of each period. |
|
|
|
| Examples |
| FV(50;.11/12;5 * 12) returns 3975.90398429.... |
| FV(2000;.12;30) + 5000 * (.12 + 1) ^ 30 returns 632464.97928640.... |
| FV(500;.11/5;60) returns 61141.65130790.... |
| To set the decimal precision of the returned value, enclose the current formulas with the Round function. For example, Round(Current Formula;2). |
| Related topics |
|
Functions reference (category list) |
|
Functions reference (alphabetical list) |
|
About formulas |
|
About functions |
|
Defining calculation fields |
|
Using operators in formulas |
|
|
| Contents > Functions reference (alphabetical list) > Financial functions > FV function |
|
|
Next Page |
|