Summary

The Excel FVSCHEDULE function returns the future value of an initial principal after applying a schedule of varying interest rates. Microsoft describes it as a function for variable or adjustable rates, which makes it the natural alternative to FV when one constant rate is not realistic.

FVSCHEDULE is useful when a worksheet needs to model growth across several different periods with different returns. Instead of forcing the model into one average rate, it applies the rates one after another in sequence.

That sequence matters. Reordering the schedule changes the compounding path, so the worksheet should treat the schedule as a chronological series rather than as an unordered set of rates.

Syntax

=FVSCHEDULE(principal, schedule)

principal is the starting amount, and schedule is the array or range of interest rates to apply in order. Microsoft notes that the entries in the schedule can be numbers or blank cells, and blank cells are treated as zero-rate periods.

Arguments

• principal - The starting value or present amount.
• schedule - The array or range of rates applied in sequence.

Because the schedule is sequential, the worksheet should make the time order clear. A rate list such as 5%, 4%, 6% is not just a set of assumptions; it is a specific three-step growth path.

FVSCHEDULE vs Related Functions

FVSCHEDULE and FV both produce future value, but they assume different rate structures.

Use FVSCHEDULE when the model needs the actual path of varying rates. Use FV when one stable rate is a deliberate assumption.

Using the FVSCHEDULE Function

FVSCHEDULE is often used in planning and performance review when annual or period-specific returns are known individually. The function compounds the principal through the rate sequence directly, which makes the effect of good and weak periods easier to trace than with a single average rate.

It is also useful when the worksheet needs to show what portion of the ending balance came from growth rather than from the starting principal. That distinction becomes clearer once the ending value is compared with the opening amount.

• Use FVSCHEDULE for variable-rate growth paths.
• Keep the rate schedule in chronological order.
• Use a benchmark or growth-versus-principal view so the ending balance is easier to interpret.

Example 1 - Variable Growth (3 Years)

This example applies three different annual rates in sequence to a $1,000 principal. Each year compounds the ending balance of the previous year, so the order of the rates matters to the calculation path.

=FVSCHEDULE(1000,{0.05,0.04,0.06})

Example 2 - Zero Growth Recovery

A zero-rate year does not break the function. It simply means the balance carries forward unchanged for that period before the later positive rates are applied.

=FVSCHEDULE(1000,{0,0.05,0.06})

Example 3 - Performance Benchmark

This comparison checks whether the variable-rate path produces an ending value above $1,150. It is a practical way to turn the projected balance into a clear performance threshold.

=FVSCHEDULE(1000,{0.05,0.04,0.06})>1150

Example 4 - Net Variable Profit

Subtracting the original principal from the final FVSCHEDULE result isolates the growth component. This helps distinguish investment performance from the funded starting amount.

=FVSCHEDULE(1000,{0.05,0.04,0.06})-1000

Conclusion Recap

• Summary: FVSCHEDULE returns future value under a sequence of varying rates.
• Syntax: =FVSCHEDULE(principal,schedule).
• Core setup: Keep the rate schedule ordered and make sure it reflects the actual growth path being modeled.
• Best use: Variable-rate investing, staged return analysis, and growth-versus-principal comparisons.