The free guide

FVSCHEDULE function in Excel

Use

FVSCHEDULE function returns the future value of an investment (an initial principal) after applying series of compound interest rates.

Syntax

FVSCHEDULE(principal, schedule)

where,

principal means the initial amount of investment, and

schedule is an array of compound interest rates to apply.

Example

Formula:

Result:

Common Error

Excel returns with #VALUE!, if we put non-numaric value in the argument.

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved