Financial
FVSCHEDULE Function in Excel
Returns the future value of an initial principal after applying a series of compound interest rates.
Syntax
- =FVSCHEDULE(principal, schedule)
Arguments
- principal (required): Present value
- schedule (required): Array of interest rates
Examples
- =FVSCHEDULE(1000, {0.09, 0.11, 0.1}) - FV with varying rates - Result: 1335.19
Excel FVSCHEDULE function documentation
- FVSCHEDULE returns future value of an initial principal after applying a schedule of variable interest rates.
- Syntax: =FVSCHEDULE(principal, schedule).
- Use FVSCHEDULE for staged-rate projections where each period has different growth assumptions.
- Related planning tools: [PV](/functions/pv/), [NPV](/functions/npv/), [IRR](/functions/irr/), and [Financial functions](/categories/financial/).
FVSCHEDULE inputs and modeling tips
- principal is the starting investment amount.
- schedule is an array or range of periodic rates applied sequentially.
- Rates are multiplicative over time, so order and period definitions matter.
- Keep schedule frequency consistent with your planning horizon.
Step-by-step: variable annual growth projection
- Step 1 — Enter initial capital in B1.
- Step 2 — List year-by-year rates in C2:C8.
- Step 3 — Compute =FVSCHEDULE(B1, C2:C8).
- Step 4 — Compare with constant-rate [FV](/functions/fv/) as a baseline.
- Step 5 — Build optimistic/base/pessimistic schedules for scenario planning.
FVSCHEDULE vs FV
- FVSCHEDULE supports changing rates each period.
- FV assumes constant periodic rate throughout nper.
- For realistic macro scenarios, FVSCHEDULE often better reflects expected path dependence.
- Use FV when assumptions are intentionally simplified and stable.
Worked examples to copy
- Basic variable path: =FVSCHEDULE(10000,{0.08,0.06,0.04,0.05}).
- Range-driven schedule: =FVSCHEDULE(B1, D2:D13).
- Inflation-adjusted plan: combine nominal growth schedule with real-return analysis.
- Compare plans: calculate multiple FVSCHEDULE outputs side by side.
People also ask
- Can schedule include negatives? — Yes, negative rates reduce value in that period.
- Does FVSCHEDULE include contributions? — No, it applies rates to one starting principal.
- How to add cash contributions? — Build explicit cash-flow model and evaluate with [NPV](/functions/npv/).
- Can I use monthly rates? — Yes, if each schedule entry is one month and consistent.
Common errors
- Schedule must be array
Use cases
- Variable rate investments
- Stepped rates
- Complex growth
Frequently asked questions
- What is FVSCHEDULE used for? FVSCHEDULE calculates future value when interest rates vary over time. Unlike FV which assumes constant rate, FVSCHEDULE handles variable rates - perfect for CDs with stepped rates, adjustable-rate investments, or projecting growth with changing returns.
- How do I calculate growth with varying annual returns? Use =FVSCHEDULE(principal, {rate1, rate2, rate3, ...}). Example: $10,000 with returns of 8%, -5%, 12%: =FVSCHEDULE(10000, {0.08, -0.05, 0.12}) = $11,491.20. Each rate is applied sequentially to the growing balance.
- Can I use FVSCHEDULE for inflation-adjusted projections? Yes! For real (inflation-adjusted) future value, use real returns: =FVSCHEDULE(principal, {nominal1-inflation1, nominal2-inflation2, ...}). Or calculate nominal FV then divide by cumulative inflation factor.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.
When to use FVSCHEDULE
- Variable rate investments — common Financial scenario for FVSCHEDULE.
- Stepped rates — common Financial scenario for FVSCHEDULE.
- Complex growth — common Financial scenario for FVSCHEDULE.
FVSCHEDULE in the Financial category
- Browse all Financial functions at /categories/financial/ for related formulas.
- FVSCHEDULE syntax: =FVSCHEDULE(principal, schedule)
- principal (required): Present value
- schedule (required): Array of interest rates
- Confirm FVSCHEDULE arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
Formula checklist before you copy down
- Confirm FVSCHEDULE arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
- If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
- Spot-check three known input rows manually against expected output.
Related Excel functions
- FV (/functions/fv/): Returns the future value of an investment based on periodic, constant payments and a constant interest rate.
- PV (/functions/pv/): Returns the present value of an investment - the total amount that future payments are worth now.
- NPV (/functions/npv/): Calculates the net present value of an investment based on a discount rate and future cash flows.
Errors to watch for
- Schedule must be array — review causes on linked error pages in the directory.
Copy-paste audit workflow
- Enter FVSCHEDULE on three test rows with known expected output documented on a QA tab.
- Fill down only after absolute references are locked on lookup tables and rate tables.
- Compare against manual calculation or a calculator for financial and statistical functions.
- Search this directory for comparison guides when choosing between similar functions in the same category.
FVSCHEDULE worked examples to copy
- =FVSCHEDULE(1000, {0.09, 0.11, 0.1}) — FV with varying rates. Expected result: 1335.19.
FVSCHEDULE reference summary for crawlers and offline review
- FVSCHEDULE belongs to the Financial category in Excel. Returns the future value of an initial principal after applying a series of compound interest rates.
- Full syntax: =FVSCHEDULE(principal, schedule). Open /functions/fvschedule/ for parameters, FAQs, and related pages.
- Common mistakes: Schedule must be array
- Pair this function with comparison guides when another Excel formula might fit the same task better.
- Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.