FVSCHEDULE Function in Google Sheets: Formula, Examples & Troubleshooting
Compound a starting value through changing rates with FVSCHEDULE in Google Sheets. Reconcile period balances, total growth, and a constant-rate equivalent.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: FVSCHEDULE compounds one starting value through a series of rates. With 10,000 initially and successive rates of 5%, 4%, and 3%, the expected final value is 11,247.60.
Verification: NOT_TESTED_IN_GOOGLE_SHEETS. Google documentation was reviewed October 17, 2026. Expected balances are independently calculated from synthetic assumptions and have not been observed in the application.
Syntax and arguments
=FVSCHEDULE(principal, rate_schedule)
Both arguments are required. principal is the starting amount. rate_schedule is a range or array of successive rates, expressed as fractions or percentages rather than whole-number percentage labels. Google documents this specifically for a potentially varying rate sequence. FVSCHEDULE reference.
There is no argument for repeated contributions, withdrawals, or the length of each period. Each supplied rate must already represent the growth factor for its intended period. An annual nominal quote is not automatically converted into a monthly rate.
Build a checkable three-period schedule
Enter A1:C4 and E1:E2:
| Row | A · Period | B · Rate | C · Ending balance |
|---|---|---|---|
| 1 | Period | Rate | Ending balance |
| 2 | 1 | 5% | Formula below |
| 3 | 2 | 4% | Formula below |
| 4 | 3 | 3% | Formula below |
Put Starting value in E1 and 10000 in E2.
- In E4 enter
=FVSCHEDULE(E2,B2:B4). Expected result: 11247.6. - In C2 enter
=$E$2*(1+B2). Expected result: 10500. - In C3 enter
=C2*(1+B3). Expected result: 10920. - Copy C3 to C4. Expected result: 11247.6.
The arithmetic is 10000*1.05*1.04*1.03. The running balances show where each rate acts and provide a transparent independent reconciliation for the final formula.
Adding the rates and applying 12% once would give 11200, which is 47.6 lower. Adding rates omits compounding on the accumulated balance.
Report total growth separately from annualized growth
In E5 enter =E4/E2-1. Expected total growth: 12.476% across all three periods.
If the three rates each represent one year, an equivalent constant annual rate can be calculated as =(E4/E2)^(1/3)-1. Expected result: approximately 3.9967947730%. Compounding that constant rate for three years reproduces the same final-to-initial ratio.
Do not label 12.476% as an annual rate when it covers three years. Conversely, if the schedule represents three months, the constant rate calculated above is per month. Dates and labels in column A document the interpretation; FVSCHEDULE itself has no date argument.
Advanced application: compare order and cash-flow assumptions
On a separate area, put 3%, 4%, 5% in G2:G4. =FVSCHEDULE(E2,G2:G4) has the same independently expected final value 11247.6, because multiplying the same three factors gives the same product. Intermediate balances differ: 10300, 10712, then 11247.6.
This final-value equivalence relies on a single initial amount and no interim flows. Suppose you add 1,000 immediately after the first period in the original schedule. A separate running-balance calculation gives (10000*1.05+1000)*1.04*1.03 = 12318.8. That is a different model; adding 1,000 to FVSCHEDULE’s original final output would give 12247.6 and miss growth on the contribution.
Use an explicit cash-flow ledger when contributions exist. Keep the contribution timing visible instead of forcing cash flows into a rate-schedule column.
Errors, data quality, and practical limits
A cell containing 5 is not the same as 5%. The documented rate input is a decimal or percentage; 5 represents 500%. Check the underlying values before comparing balances.
Do not pass period headings in the numeric rate range. Use B2:B4, not B1:B4. A blank rate should not silently stand for “unknown but probably zero.” Decide how missing assumptions should be treated and validate the schedule before calculating. Google’s specific reference does not establish every blank/text/error coercion rule, so no such native behavior is invented here.
Match the rate to the period length. If an agreement gives varying annual rates but interest is credited monthly, establish the monthly conversion convention before building a monthly schedule. This formula does not choose it, and the simple example does not incorporate fees or taxes.
The result depends on assumptions. Changing a forecast rate is a scenario, not evidence that the future balance is guaranteed. Keep actual realized rates separate from future assumptions in a real workbook.
Availability and references
FVSCHEDULE is documented for current Google Sheets. First introduction and last functioning release are not established by reviewed sources, and no retirement is established. No native import/export compatibility result is claimed.
Related published guides: PRODUCT, POWER, and SUM. The worked comparison explains why summing rates is a different calculation from compounding factors.
First-party documentation reviewed October 17, 2026: Google FVSCHEDULE. The calculations and datasets are original independent examples.