Zoho Sheet PV: Present Value and Payment Capacity
Calculate present value in Zoho Sheet with aligned payment periods, clear cash-flow signs, optional future values and an independent discount schedule.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer. =PV(6%/12;36;-350;0;0) gives approximately 11504.86 under the standard annuity model. It is the amount financed today by thirty-six month-end payments of 350 at a constant 6% nominal annual rate divided by twelve.
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 PV reference. Documentation and independent annuity models; no native Zoho Sheet test.
Syntax and required combinations
=PV(rate; nper; [pmt]; [fv]; [type])
Rate is the interest rate per period and nper is the total number of periods. pmt is the fixed payment. Zoho allows pmt to be omitted only when fv is supplied; the examples below use explicit 0 for a lump-sum case rather than assuming empty-placeholder syntax.
The future value fv defaults to zero. Type defaults to 0 for period-end payments; 1 means period-start payments. There is no optional argument that changes a monthly rate into an annual one.
Cash-flow signs describe opposite directions. In the financing example, receiving principal today is positive and making later repayments is negative. For a savings goal received in the future, a positive fv instead produces a negative present deposit. The negative sign is information, not automatically a formula error.
Practice table: payments and terminal amounts
Create a new sheet named PresentValues. Enter Periodic rate, Periods, Payment, Future value, Type and Present value in A1:F1. Fill A2:E7 as follows. Put =PV(A2;B2;C2;D2;E2) in F2 and fill through F7.
| Row | A | B | C | D | E | Expected F, 6 decimals |
|---|---|---|---|---|---|---|
| 2 | 0.5% | 36 | -350 | 0 | 0 | 11504.855684 |
| 3 | 0.5% | 36 | -350 | 0 | 1 | 11562.379962 |
| 4 | 0.5% | 36 | -350 | -2000 | 0 | 13176.145521 |
| 5 | 4% | 5 | 0 | 5000 | 0 | -4109.635534 |
| 6 | 0% | 36 | -350 | 0 | 0 | 12600.000000 |
| 7 | 0.5% | 36 | 350 | 0 | 0 | -11504.855684 |
The first three rows use monthly periods. Row 4 adds a separate 2000 outflow at the end of month 36; it does not replace the final regular 350 payment. Row 5 is a five-year lump-sum example with no recurring payments.
Put =PV(A2;B2;C2) in H2. The default fv and type are zero, so its expected result matches F2. To compare timing, put =F3-F2 in H3; expect approximately 57.524278419. Beginning payments have a higher present value here because each occurs one period earlier.
Keep financing capacity separate from the purchase price
For the row-2 assumptions, put a proposed price of 12500 in H5. In H6 enter =F2-H5; expect approximately -995.144316257. The discounted value of the stated repayment stream is lower than that price by about 995.14.
This is a controlled arithmetic comparison, not a complete financing decision. Fees, deposits, taxes, actual payment dates and contractual rates may change the cash flows. Do not treat PV alone as a quote or a guarantee of affordability.
The zero-rate row totals the thirty-six payments to 12600. It is an independently calculated limiting case of the model. Zoho’s short entry does not provide a full list of exceptional rate domains or error outcomes.
Advanced: discount each of the thirty-six payments
Create a separate sheet named DiscountCheck. Put Period, Payment magnitude and Discounted amount in A1:C1. Put 1 in A2, 350 in B2, and Periodic rate in E1 with 0.5% in F1.
In A3 enter =A2+1 and fill through A37, ending at period 36. Fill B2 through B37 with the constant 350. In C2 enter =B2/(1+$F$1)^A2 and fill through C37. In F3 enter =SUM(C2:C37).
The expected sum is 11504.855683743, matching the positive principal in PresentValues F2. This sheet discounts positive payment magnitudes; the PV call uses negative repayments so its returned initial cash flow is positive.
For a period-start comparison, enter =B2/(1+$F$1)^(A2-1) in D2 and fill through D37. Put =SUM(D2:D37) in F4; expect 11562.379962162. The first payment now has exponent zero and is not discounted. There are still thirty-six payments.
In F5 enter =F4-F3; expect the same 57.524278419 timing difference. This check exposes the dates implicit in type 0 and type 1 instead of relying only on a final number.
Lump-sum check and practical limits
The five-year row can be checked directly with =-5000/(1+4%)^5, approximately -4109.635533797. A future 5000 receipt and an initial deposit have opposite signs. This example assumes annual compounding with no intervening payments.
For monthly models, distinguish a nominal annual rate divided by twelve from an effective annual rate converted by (1+annual_rate)^(1/12)-1. Keep period counts in the same unit. A percentage-formatted cell containing 0.005 means 0.5%, not 0.005%.
Zoho lists general name, type and reference errors but does not fully specify every blank, fractional-period or invalid-type case on this page. Preserve numeric inputs and explicit timing values. SUM supplies the discount-schedule totals; FV solves for the ending amount and PMT for the payment. See the official PV reference for its argument rules.