FVSCHEDULE function returns the future value of an investment (an initial principal) after applying series of compound interest rates.
the principal means the initial amount of investment, and
the schedule is an array of compound interest rates to apply.
Excel returns with #VALUE!, if we put non-numaric value in the argument.
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.