RRI in Collabora Office: Convert Endpoint Growth Into a Constant Periodic Rate

=RRI(P; PV; FV)

P is the number of periods, PV the positive starting value and FV the ending value. All three arguments are required. The Collabora reference explicitly requires a positive, nonzero PV and gives an example using positive starting and ending values.

For the positive-value examples here, the independent model is (FV/PV)^(1/P)-1. RRI takes endpoint values as positive amounts. It is not the same sign convention as RATE’s balancing cash-flow equation, where the initial and terminal flows usually have opposing signs.

The result is a rate for one of the P periods. It is annual only when those periods are years. The function has no dated cash-flow list and cannot account for deposits or withdrawals that occurred between the endpoints.

Enter 5 in B2, 1000 in B3 and 1610.51 in B4. Calculate =RRI(B2;B3;B4) in B6 and format it as a percentage.

The independent target is 10% because 1000×1.1⁵ = 1610.51. An explicit check is =B3*(1+B6)^B2; it should reproduce the ending value within numerical precision.

The total growth is 61.051%, while the constant periodic rate is 10%. Dividing total growth by five gives 12.2102%, which is an arithmetic average of the total change and does not reproduce the same compounded endpoint.

=RRI(4;1000;656.1) has independent expected result −10% because 1000×0.9⁴ = 656.1. Positive endpoint values can therefore produce a negative growth rate when the final value is smaller.

Do not discard the sign or label the result as a positive “loss return.” The sign is essential to reconstructing the endpoint. A rate of +10% would move the starting value in the opposite direction.

A doubling over ten equal periods gives =RRI(10;1000;2000), independently approximately 7.177346254% per period. A doubling over five periods gives approximately 14.869835500% per period.

Both cases have the same total growth, but the shorter horizon requires a larger periodic rate. Comparing endpoint percentage changes without their durations loses this distinction.

Build a small scenario table with period counts in A10:A12 and the same starting and ending values referenced absolutely. This makes horizon assumptions visible instead of burying them in separate formulas.

Suppose an account starts at 1000 and ends at 1500, but 400 was contributed midway. RRI applied only to 1000 and 1500 would attribute the entire endpoint change to compounded growth. It has no argument describing that contribution.

Before using RRI as a growth summary, determine whether the endpoints can reasonably be compared without external additions or removals. If intermediate cash flows matter, use a model that includes their amounts and timing rather than interpreting RRI as a complete investment-performance measure.

The same warning applies to nonfinancial quantities. A starting and ending stock of inventory may change through additions and removals; a compound endpoint rate does not explain those mechanisms.

For positive P and equal positive endpoints, the independent target is zero. P=0 does not define an ordinary per-period growth rate. Keep P positive and PV strictly positive in these examples, and use positive FV for the real-valued model described here.

The reviewed section does not settle every zero-ending-value, negative-value or fractional-period native boundary. No exact error codes are asserted. Use actual numeric inputs and a percentage display; the stored value 0.1 means 10%, not 0.1%.

This guide explains arithmetic under specified endpoints. It does not recommend an investment, forecast a return or validate the quality of the underlying data.

Collabora Office 26.04 desktop help documents RRI. The official snapshot was retrieved on 2026-10-13 and hash-verified for this guide on October 15, 2026. Online/mobile support is not inferred from this desktop documentation.

First introduced release and last functioning version are unknown. No native Collabora execution was performed. Expected outputs are independent arithmetic or equation controls, not captured application results. Exact native error behavior, additional versions and extreme numerical cases remain unverified.

• Collabora Office 26.04: RRI.
• Editorial testing standards.

Formulas use English function names and semicolon separators. The help advises supplying earlier optional arguments when a later optional argument is needed; the worked formulas use explicit values.