FVSCHEDULE Function

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.

The example is useful because it shows what makes FVSCHEDULE different from FV. Instead of assuming one fixed rate, it answers a more realistic question: what happens when returns change from year to year?

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

This helps beginners read the schedule more naturally. A rate of 0 does not mean “skip the year.” It means the money stays flat for that step, then keeps compounding when the next rates arrive.

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

That makes the example useful for planning. A sheet can move from “here is the ending value” to “did this investment path reach the goal?” which is often the real question a user wants answered.

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

So instead of only seeing the final total, the learner can see how much money was actually earned by the changing rate schedule. That makes the result easier to compare with other scenarios that start from different principal amounts.

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

Conclusion Recap

FVSCHEDULE is useful when the growth rate changes from one period to the next and one fixed rate would hide too much detail. In this lesson, that meant applying different yearly returns in order, handling flat years with no growth, testing a target value, and separating growth from the starting principal.

The most important habit is keeping the rate list in real time order. This function applies each rate one after another, so the schedule is not just a list of assumptions. It is the actual growth path the investment goes through.

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