FVSCHEDULE in Excel: Compound a Principal Through Changing Rates

=FVSCHEDULE(principal, schedule)

Both arguments are required. principal is the starting amount. schedule is an array or referenced range containing the interest rates to apply successively. Each rate corresponds to one modeled period.

The independent mathematical calculation is principal multiplied by the product of (1+rate) across the schedule. This function does not take periodic deposits or withdrawals. It also does not accept dates or infer how long a period lasts from a worksheet label.

Unlike FV’s balancing-cash-flow sign convention, a positive principal compounded through positive factors remains positive here. For example, principal one with the documented rate array yields about 1.3309, not its negative. Use the function’s actual multiplicative meaning rather than copying signs from another financial function mechanically.

Enter 9%, 11% and 10% in A2:A4. Put 1000 in C2 and =FVSCHEDULE(C2,A2:A4) in C4.

The independent balances are 1090 after the first rate, 1209.90 after the second and 1330.89 after the third. A separate row-by-row balance column multiplying by 1+the current rate reproduces those amounts.

The overall growth is 33.089%, calculated as =C4/C2-1. Adding the three rates gives 30%, which does not include compounding. Multiplying the rates themselves is also incorrect; multiply their one-plus-rate factors.

Microsoft explicitly permits numeric rates and blank cells in schedule, with a blank cell treated as zero interest. If A2:A4 contains 10%, a physically blank A3 and 5%, then =FVSCHEDULE(1000,A2:A4) has independent target 1155.

That is the same mathematical result as rates 10%, 0% and 5%. It does not mean the missing rate was verified to be zero. If a blank represents unknown data rather than an intended no-interest period, validate completeness before calculating.

A text value in the schedule is not a documented blank. The source states that other values produce #VALUE!. An empty-string formula and every possible text/Boolean coercion were not native-tested, so do not silently treat all visually empty cells as equivalent to true blanks.

A 10% gain followed by a 10% loss changes 1000 to 1000*1.1*0.9, independently 990. The net change is −1%, not zero.

The loss applies to the increased balance. This is a simple audit against adding rates or averaging them arithmetically and assuming the same terminal amount. For the two-period example, an equivalent constant compound rate is SQRT(0.99)-1, approximately −0.5012562893% per period.

The example describes arithmetic only. It does not imply that a variable-rate investment or forecast will realize the entered schedule.

For a principal with no intermediate cash flows, reordering the same rate factors leaves the final mathematical product unchanged. The three-rate example still ends at 1330.89 after any permutation, although intermediate balances differ.

Once deposits or withdrawals occur between periods, order matters and FVSCHEDULE alone is insufficient. Use an explicit balance recurrence that applies each cash flow at its stated time. Do not add all deposits to the initial principal unless they truly occur at inception.

=FVSCHEDULE(1,{0.09,0.11,0.1}) independently equals 1.33089. Microsoft displays 1.3309, a rounded version. Multiplying the exact factor by 1000 gives 1330.89; multiplying the rounded display by 1000 gives 1330.90, a different number.

Retain cell precision when scaling a result. If the schedule uses monthly rates, do not insert annual rates merely because they are quoted in a source table; convert using the intended compounding convention first.

The documented schedule error is #VALUE! for entries other than numbers or blank cells. Check text-formatted percentages and accidental labels inside the referenced range. Blank treatment is a function rule, not evidence that incomplete inputs are acceptable.

A mathematical rate of −100% makes its factor zero and wipes out the modeled principal; subsequent finite factors cannot restore it. More extreme rates and native boundary handling were not tested. Validate that every rate has the intended economic meaning rather than relying on a formula to reject an implausible scenario.

• Current documentation: the dedicated Microsoft reference lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Introduced: the first introduction version/build is not established by the dedicated reference used here.
• Last functioning version: unknown; a current help listing is not a last-working-build test.
• Evidence checked: October 15, 2026. Official documentation was freshly retrieved; examples were independently calculated. No native Excel, Mac or web-client execution was performed.

• Microsoft FVSCHEDULE reference.
• Microsoft function catalog and introduction-marker explanation.
• Editorial testing standards.

Examples use English function names and comma separators. Expected numbers are rounded independent mathematical calculations; documented error expectations are labeled as such. They are not captured Excel output. All illustrative data and policies are fictional.