Menu
EXCEL FVSCHEDULE FUNCTION
Excel FVSCHEDULE Function Introduction
The Excel FVSchedule function computes the Future Value of a variable-interest-rate investment.
Description of Excel FVSCHEDULEFunction
Syntax :
=FVSCHEDULE( principal, schedule )
Parameters :
- The arguments are as follows:
Primary :
- The primary is the investment’s present value.
Schedule :
- An array of values containing the interest rate schedule to be applied to the principal. If supplied in the form of a range of cells, they may contain numeric values or be empty (empty cells denote a zero interest rate).
Step By Step Guide of FVSCHEDULE Function
Example :
The Excel Fvschedule function is used in cell B1 of the spreadsheet below to compute the future value of a $10,000 investment over 5 years. The investment earns 5% interest for the first two years and 3.5 percent interest for the third, fourth, and fifth years.
Key Points
- #VALUE! – This error occurs if any of the supplied parameters is not a number.
(Blank cells in the schedule array are permitted and are considered as the numeric value 0).
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
