Zoho Sheet IRR: Periodic Cash Flows, Zero Periods and Multiple Roots

• 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 IRR reference. Documentation and independent periodic cash-flow models; no native Zoho Sheet test.

=IRR(payments; [guess])

Payments is the required range of amounts paid or received at regular intervals. Guess is an optional estimate near the rate you expect; Zoho documents a default of 0.1, or 10%.

Guess helps identify a numerical solution; it does not change the cash-flow amounts or represent an additional return. The short reference does not state the iteration count, convergence tolerance or which root will be selected for every possible input series.

Use one cash-flow viewpoint: money paid out is negative and money received is positive. The ordinary model below seeks a rate greater than −100% that makes the discounted total zero. All-positive or all-negative nonzero cash flows cannot cancel under that model; mixed signs still do not guarantee a unique root.

Create a new sheet named PeriodicReturn. Use A1:C1 for Period, Cash flow and Discounted cash flow. Enter the first two columns below. Period 0 is the initial outlay; the following periods are equally spaced.

Put IRR in E1 and =IRR(B2:B5;10%) in E2. The independently expected fraction is approximately 0.104915959780829. Format E2 as a percentage, keeping its stored precision.

In C2 enter =B2/(1+$E$2)^A2 and fill through C5. Put =SUM(C2:C5) in E3; the mathematical target is 0, allowing a small numerical residual. At period 0 the initial −6000 is not discounted for an extra period.

Put =IRR(B2:B5) in E4 as the omitted-guess version. The documented 10% default gives the same target equation and expected root for this example. The positive inflows total 7500, but the cash surplus of 1500 alone does not establish a periodic return without its timing.

Create a separate sheet named ZeroPeriod. Enter -1000, 0, 1210 in B2:B4 and period numbers 0, 1, 2 in A2:A4. Put =IRR(B2:B4;10%) in D2. The expected rate is 10% per period, because 1000×1.1²=1210.

For a separate comparison, enter -1000, 1210 in F2:F3 and =IRR(F2:F3;10%) in H2. The expected rate is now 21% per period: the return arrives one interval later rather than two.

The numeric zero preserves the elapsed interval in the cash-flow sequence. Removing that row changes the model. Do not substitute an empty cell or text placeholder and assume it preserves timing; the short Zoho entry does not establish all blank/text range behavior.

Create another sheet named Quarterly. Put -1000, 0, 1102.5 in B2:B4, representing time 0, quarter 1 and quarter 2. Enter =IRR(B2:B4;5%) in D2; the expected result is 5% per quarter.

In D3 enter =(1+D2)^4-1. The expected effective annualized rate is 21.550625%, assuming the same quarterly rate compounds across four quarters. =D2*4 in D4 gives 20%, the distinct nominal annualized figure.

Neither conversion predicts that future quarters will repeat the observed result. If cash flows occur on irregular actual dates, Zoho directs readers to its XIRR reference; IRR does not read dates from a neighboring column.

Create a separate sheet named TwoRoots. Enter -100, 230, -132 in B2:B4. These cash flows change sign twice. Put candidate rates 10% and 20% in E2:E3.

In F2 enter =$B$2+$B$3/(1+E2)+$B$4/(1+E2)^2 and fill to F3. Both independently calculated totals are 0. The exact identities are −100+230/1.1−132/1.1²=0 and −100+230/1.2−132/1.2²=0.

An IRR calculation is therefore not guaranteed to describe a unique economic result merely because it returns one number. You can investigate =IRR(B2:B4;10%) in H2 and =IRR(B2:B4;20%) in H3, but the two candidate roots above do not establish which root every Zoho build will select from each guess.

Use the explicit discounted totals to understand the ambiguity. MIRR supplies a different periodic cash-flow calculation with explicit finance and reinvestment rates; it should not be substituted silently without stating those assumptions.

Check chronological order, equal spacing, signs and numeric data before changing guess. Keep initial and final flows in the intended positions. A zero cash flow is not a missing observation.

Zoho’s short page lists generic name, type and reference errors, but does not specify every invalid-domain or convergence failure. Do not infer exact error tokens from another application’s IRR function. The page’s example results depend on embedded inputs; this guide supplies independent complete datasets.

PV addresses a fixed-payment annuity, while RATE solves an annuity’s constant periodic rate. IRR instead takes a sequence whose amounts can differ. These examples demonstrate arithmetic, not an investment recommendation.