Returns the future value of an initial principal after applying a series of compound interest rates.
ไวยากรณ์
FVSCHEDULE(principal, schedule)อาร์กิวเมนต์
principalจำเป็น
The present value of the investment.
scheduleจำเป็น
An array or range of interest rates to apply.
FVSCHEDULE calculates the future value of an investment by applying a schedule of varying interest rates to the initial principal. It is useful for modeling investments where the interest rate changes over different periods.
=FVSCHEDULE(1000, {0.05, 0.06})→1113Calculates the future value of 1000 after two periods with rates of 5% and 6%.
Prepare your data
Enter your initial principal amount and list the interest rates in a range of cells.
Apply the function
Use the FVSCHEDULE function, referencing the principal and the range containing the interest rates.
Yes, you can select a range of cells containing the interest rates.