Zoho Sheet FV: Future Value, Deposits and Payment Timing
Calculate future value in Zoho Sheet with explicit cash-flow signs, monthly rates, beginning/end timing and a complete savings recurrence.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer. =FV(4.8%/12;18;-200;-1500;0) has an independently calculated result of approximately 5336.80. It models an initial 1500 deposit followed by eighteen 200 deposits at month-end, with a constant 4.8% nominal annual rate divided into monthly periods.
Availability and version history
- Introduced: The original introduction release and date are not established by the checked sources.
- Availability: Currently documented in Zoho Sheet’s rolling web-service help; no numbered release or retirement endpoint is established.
- Scope: English-language web-service documentation. Mobile and offline-client parity is outside the verified scope.
- Checked: October 14, 2026, against the official FV reference. Documentation and independent annuity models; no native Zoho Sheet test.
Syntax, optional values and cash-flow signs
=FV(rate; nper; pmt; [pv]; [type])
The rate is per period and nper is the number of those periods. pmt is the constant periodic payment. Although the printed signature does not bracket pmt, Zoho’s description allows it to be omitted when pv is given, with payment defaulting to zero. The examples here use an explicit 0 for a lump sum so no empty-placeholder syntax is assumed.
The initial value pv defaults to zero. Type defaults to 0, meaning period-end payments; 1 means period-start payments, including one at the start of the term. Type changes payment timing, not the number of payments.
Zoho represents amounts paid out as negative and amounts received as positive. From a saver’s viewpoint, deposits are outflows, so pmt and pv are negative; the future amount available to receive is positive. Reversing every cash-flow sign reverses the result.
A six-case worksheet
Create a new sheet named FutureValues. Enter Periodic rate, Periods, Payment, Initial value, Type and Future value in A1:F1. Enter A2:E7 below, then put =FV(A2;B2;C2;D2;E2) in F2 and fill through F7.
| Row | A | B | C | D | E | Expected F, 6 decimals |
|---|---|---|---|---|---|---|
| 2 | 0.4% | 18 | -200 | -1500 | 0 | 5336.802335 |
| 3 | 0.4% | 18 | -200 | -1500 | 1 | 5351.702538 |
| 4 | 0.4% | 18 | -200 | 0 | 0 | 3725.050811 |
| 5 | 4% | 5 | 0 | -5000 | 0 | 6083.264512 |
| 6 | 0% | 18 | -200 | -1500 | 0 | 5100.000000 |
| 7 | 0.4% | 18 | 200 | 1500 | 0 | -5336.802335 |
Rows 2–4 and 6–7 use monthly periods. Row 5 is a separate annual-period example. A rate has no automatic calendar unit inside FV; the input model supplies it.
In H2 enter =FV(A2;B2;C2;D2); omitted type gives the row-2 target. In H4 enter =FV(A4;B4;C4); omitted pv and type give the row-4 target. Do not confuse an omitted argument with a cell that happens to contain blank text.
What the initial example contains
The original contribution is 1500 plus 18×200, or 5100. In H5 enter =F2-5100; the expected modeled growth is 236.802334825. In H6 enter =F3-F2; moving the eighteen payments to the start of each month increases the modeled ending value by approximately 14.900203242.
The initial 1500 is already present at time zero in both cases. Type 1 moves the periodic deposits earlier; it does not add a nineteenth deposit or move the initial value to a different date.
At zero interest, the total is simply 5100. The zero-rate row is an independently calculated limiting case of the annuity model, not an assertion about every rate-domain or coercion boundary in Zoho.
Advanced: rebuild both timing cases month by month
Create a separate sheet named MonthlyCheck. Use A1:C1 for Month, End-payment balance and Start-payment balance. Put 0 in A2 and 1500 in both B2 and C2. Put Monthly rate in E1 and 0.4% in F1.
Enter these formulas in row 3:
- A3:
=A2+1 - B3:
=B2*(1+$F$1)+200 - C3:
=(C2+200)*(1+$F$1)
Fill A3:C3 through row 20, representing months 1 through 18. The balance columns are positive accounting balances; this recurrence adds deposits, while the FV function inputs record those deposits as negative cash flows.
| Month | Expected B, 6 decimals | Expected C, 6 decimals |
|---|---|---|
| 1 | 1706.000000 | 1706.800000 |
| 6 | 2748.426118 | 2753.274375 |
| 12 | 4027.115688 | 4036.929730 |
| 18 | 5336.802335 | 5351.702538 |
The final row reproduces FutureValues rows 2 and 3. Keep full precision in each recurrence step and use number formatting for displayed decimals; rounding each monthly balance introduces a different model.
Rate conventions, errors and related functions
Dividing 4.8% by 12 is appropriate for the explicitly stated nominal annual convention here. An effective annual rate converts differently: (1+annual_rate)^(1/12)-1. FV does not determine which convention a contract uses.
This model assumes a constant rate, equal periods and fixed deposits. It does not incorporate changing rates, fees, taxes or missed payments. Zoho’s short reference lists generic type, name and reference errors but does not enumerate all invalid periods, type values, blanks or rate bounds. Use the documented timing values 0 and 1 and inspect source inputs when diagnosing a result.
The examples follow Zoho’s semicolon syntax. Keep numeric results separate from currency symbols and labels. PV solves for the current value; PMT solves for the periodic payment. The authoritative source is Zoho FV.