MicroStrategy ONE
Fvschedule (Future Value Schedule)
Returns the future value of an initial principal after a series of compound-interest rates are applied. Use this function to calculate the future value of an investment that has a variable or adjustable rate.
Syntax
Fvschedule <Basis> (Argument, PV)
Where:
Argument is a set of applicable interest rates.
PV is the present value of the investment.
Basis is a parameter that indicates the time-count basis to be used. The default value for Basis is 0, which is typically used by American agencies and assumes 30-day months and 360-day years (30/360). Possible values for this parameter are listed in the following table.
| Basis value | Application |
|
0 (30/360) |
Assumes 30 days in each month, 360 days in each year. |
|
1 (actual/actual) |
Assumes actual number of days in each month, actual number of days in each year. |
|
2 (actual/360) |
Assumes actual number of days in each month, 360 days in each year. |
|
3 (actual/365) |
Assumes actual number of days in each month, 365 days in each year. |
|
4 (30/60) |
Used by European agencies, assumes the same values as “0” for American institutions. |
Usage Notes
If Argument is nonnumeric, the engine returns an empty cell.
Use the Fv function for payments made with a constant interest rate.