FV_ANNUITY Function (Calligra Sheets)

• Introduced: First release not established; the name is present in Calligra 2.4.0 source.
• Supported in: Calligra Sheets 26.08.2, with no retirement established.
• Scope: Desktop Sheets with the Financial module. Examples use English semicolon-separated formulas.
• Checked: October 14, 2026. Selected formulas ran through the official 25.04.2 engine library. Source and independent mathematics were checked. This is engine evidence, with no GUI-cell or import verification; 26.08.2 was source-checked only.

FV_ANNUITY gives the accumulated value of equal payments made at each period end. Its formula is payment×((1+rate)^periods−1)/rate. The sign follows the payment rather than automatically reversing the cash-flow sign. Function-specific official reference.

=FV_ANNUITY(payment;ratePerPeriod;periods)

Exactly three arguments are required: payment amount, rate per payment period, and number of periods. Use matching units and a nonnegative integer period count for an ordinary payment schedule. Rate zero needs separate handling. Registration and implementation.

The engine and mathematical columns are separate. Results are rounded to twelve decimal places, or thirteen significant digits in scientific notation for very small or large values. This is a display choice, not an accuracy guarantee.

Three end-of-period payments of 100 at 10% accumulate to 331 at the end of period three. The first payment earns two periods of interest, the second earns one, and the third earns none: 100*(1.1^2+1.1+1)=331.

At 5%, five payments of 100 give 552.563125. This is the final accumulated amount, not just interest earned. The total payments are 500, so the independent interest calculation is 552.563125−500=52.563125.

For payments at each period beginning instead, the same ordinary cash flows gain one additional period of growth; multiply the ordinary-annuity value by 1+rate. For the three-payment example, the independent annuity-due value is 364.1. There is no Type argument in FV_ANNUITY itself.

At nonzero rate, zero periods returns zero. As rate approaches zero, the mathematical limit is payment×periods, but entering exactly zero reaches the implementation’s division-by-zero branch. For a validated zero-rate model, calculate that product explicitly.

The executed advanced check was:

=FV_ANNUITY(100;.1;3)-100*(1+1.1+1.1^2)

Its engine result was -2.667310816662E-14.

The source does not enforce a nonnegative integer number of periods. Negative and fractional values are evaluated algebraically, so a finite output does not prove there is a realizable payment schedule. Rates below −1 combined with fractional powers can produce numeric NaN without an engine error flag.

Negative payments retain their sign. Numeric payment text is parsed; nonnumeric payment text became zero, while nonnumeric rate text triggered #DIV/0!. Wrong arity gives #VALUE!. The table and source comparison establish these selected cases, without GUI-cell or workbook-import verification.

• Function-specific implementation
• Versioned function help
• Arithmetic helper
• Power helper
• Conversion helper

The financial module and value-calculation helpers are byte-identical between the inspected 25.04.2 and 26.08.2 sources. That comparison supports the source discussion but does not establish later-version execution, GUI-cell behavior or other locales.

PMT, POWER, SUM.