Easy Explanation Notes with Examples

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,

the principal means the initial amount of investment, and

the 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.

Similar Functions

FV function calculates the future value of an investment.

PV function is used to get the present value/ current worth of the future cash flows that will receive at a future date.

EFFECT function calculates an effective annual interest rate for a loan or an investment.

INTRATE function calculates the interest rate for a fully invested security.




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