FVSCHEDULE Function Explained
The FVSCHEDULE Function in Microsoft Excel calculates the future value of an initial principal after applying a series of compound interest rates. It takes three arguments: principal, schedule, and type. The principal argument is the initial amount of money. The schedule argument is an array of interest rates to be applied to the principal. The type argument is a number that indicates when the interest is applied (0 for the end of the period, 1 for the beginning of the period). The function returns the future value of the principal after applying the interest rates.
FVSCHEDULE Function Syntax
FVSCHEDULE(principal, schedule)
- principal: The initial amount of the loan or investment.
- schedule: An array of cash flows that correspond to a schedule of payments in the same order as the payment dates.