FVSCHEDULE function

CALC FUNCTIONS

Financial Functions

< Previous Section

Next Section >

FUNCTIONS

Depreciation

• AMORDEGRC
• AMORLINC
• DB
• DDB
• SLN
• SYD
• VDB

Payment Streams, Annuities, Loans

• CUMIPMT
• CUMIPMT_ADD
• CUMPRINC
• CUMPRINC ADD
• FV
• FVSCHEDULE
• IPMT
• IRR
• ISPMT
• MIRR
• NPER
• NPV
• PMT
• PPMT
• PV
• RATE
• RRI
• XIRR
• XNPV

Securities

• ACCRINT
• ACCRINTM
• DISC
• DURATION
• DURATION ADD
• EFFECTIVE
• EFFECT ADD
• INTRATE
• MDURATION
• NOMINAL
• NOMINAL ADD
• ODDFPRICE
• ODDFYIELD
• ODDLPRICE
• ODDLYIELD

Coupons

• COUPDAYBS
• COUPDAYS
• COUPDAYSNC
• COUPNCD
• COUPNUM
• COUPPCD

Miscellaneous

• DOLLARDE
• DOLLARFR

< Previous Page

Next Page >

FVSCHEDULE

Returns the future value of a lump sum, with changing future interest rates.

Syntax:

FVSCHEDULE(principal; interestrates)

principal: the initial value of the lump sum.

interestrates: a range or array containing a schedule of interest rates which apply to each period.

FVSCHEDULE calculates the future value by applying each interest rate in turn, and compounding. The formula is:

principal * (1+rate₁) * (1+rate₂) *(1+rate₃) * ...

where rate_i is the i^th interest rate in interestrates.

Example:

FVSCHEDULE(1000; {.05; .06; .07})

returns 1,190.91, the future value of 1000 in 3 years time, where you believe the appropriate interest rates will be 5% in the first year, 6% in the second year and 7% in the third year.

---

See Also

• FV

• Financial functions

• Functions listed alphabetically
• Functions listed by category