FVSCHEDULE in WPS Spreadsheet: Compound a Principal Across Changing Rates
Calculate a future value from explicit period rates and audit every compounding step in a transparent worksheet.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer
For a starting amount of 1000 and two period rates of 10% and 20%, =FVSCHEDULE(1000,B2:B3) has the independently expected result 1320, when B2 and B3 contain those rates. It compounds each period’s rate on the balance carried forward.
Syntax and inputs
FVSCHEDULE(principal, schedule)
Supply both arguments: principal is the initial amount and schedule contains the series of rates, documented as an array or worksheet range. No optional arguments or defaults are shown. This guide uses an explicit numeric range and positive principal. Rates are per period; 10% is stored as 0.10, not 10.
Worked worksheet: two hypothetical periods
| Cell | Entry |
|---|---|
| A1 | Period |
| B1 | Rate |
| A2 | 1 |
| A3 | 2 |
| B2 | 10% |
| B3 | 20% |
| E2 | 1000 |
In E4 enter =FVSCHEDULE(E2,B2:B3). Expected result: 1320. To audit it without FVSCHEDULE, enter =$E$2*(1+B2) in C2 and =C2*(1+B3) in C3. Expected intermediate balances are 1100 and 1320. Net growth is 320, or 32% of the initial principal.
A simple sum of the rates gives 30%, which would incorrectly suggest 1300. The additional 20 comes from applying the second rate to the first period’s growth as well as the original amount.
Advanced check: copy scenarios without shifting the schedule
Put 2000 in E3. In F2 use =FVSCHEDULE(E2,$B$2:$B$3) and copy to F3. Independently expected results are 1320 and 2640. The principal reference moves by row; the schedule stays fixed. Inspect both formulas after copying instead of assuming the dollar signs were placed correctly.
For a second check, put 5% in H2:H4 and use =FVSCHEDULE(1000,H2:H4). Expected result: 1157.625, since 1000 × 1.05 × 1.05 × 1.05 = 1157.625. Displaying two decimal places rounds the view to 1157.63; it does not change the unrounded calculation. Avoid rounding each period unless that is explicitly part of your model.
Troubleshooting and modeling limits
The WPS FAQ recommends checking text, spaces and invalid characters when #VALUE! occurs. This does not establish how every blank or text cell in a schedule is coerced. Use a fully numeric rate range and verify the selected endpoints.
The reviewed material does not settle negative-rate boundaries, empty schedules, mixed-data coercion or maximum schedule length. No exact error mapping is claimed for those cases. Changing a cell’s number format alone does not necessarily convert imported numeric text into a number; correct the underlying data.
This model has a single initial amount and a specified rate for each step. Additional deposits, withdrawals, taxes, charges and payment timing need a different or expanded model. The function does not select plausible rates or promise that an investment will follow a schedule. Keep period definitions consistent and retain the input assumptions next to the formula.
See FV for a separately documented constant-rate financial function.
Availability and verification
The official Windows documentation was checked on October 19, 2026: introduction, entry and syntax guide, and troubleshooting FAQ. These pages carry a July 13, 2026 update date and describe this function as available without membership. That date is not an introduction date; the documentation does not identify an exact minimum build. This guide does not infer support in historical builds, other editions, or Mac, Linux, web and mobile apps. The examples are independently calculated expectations, not observed WPS outputs. Native execution and genuine application screenshots remain unverified.
These are fictional mathematical examples for learning a spreadsheet function, not investment recommendations or forecasts.
Browse the WPS function library.