- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Financial - FVSCHEDULE Function
Description
The FVSCHEDULE function returns the future value of an initial principal after applying a series of compound interest rates. Use FVSCHEDULE to calculate the future value of an investment with a variable or adjustable rate.
Syntax
FVSCHEDULE (principal, schedule)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Principal | The present value. | Required |
| Schedule | An array of interest rates to apply. | Required |
Notes
The values in schedule can be numbers or blank cells. Any other value produces the #VALUE! error value.
Blank cells are taken as zeros (no interest).
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_financial_functions.htm
Advertisements