FV Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; this is a verified release, not a final supported version.
• Scope: Desktop Calc, English function names and semicolon-separated formulas.
• Checked: October 14, 2026. Eight ordinary reference formulas were recalculated from generated ODF in 4.1.16 on Linux x86-64, Build 9816. Source and independent mathematics were also checked.

FV solves for the signed value at the end of a constant-rate, equally spaced cash-flow model. A negative deposit or contribution usually produces a positive accumulated value from the saver’s viewpoint. It does not forecast a realized investment return. Release implementation.

=FV(Rate; NPer; Payment [; PresentValue [; Type]])

Rate, NPer and Payment are required. PresentValue defaults to 0; Type defaults to 0 for end-period contributions. Use Type=1 for beginning-period contributions and provide PresentValue explicitly before it. The core source uses a positive-Type branch, rather than validating only 0 and 1.

The native column contains saved 4.1.16 results; the independent column uses high-precision mathematical calculations. Values are displayed to twelve decimal places, so harmless final-place differences remain visible. Rate decimals such as 0.05 represent 5%, not 0.05%.

A hypothetical contribution of 100 at each month end for twelve months, at a fixed 1% monthly rate, uses =FV(0.01;12;-100) and gives about 1268.250301319697. The contributions total 1200; the difference is the model’s accumulated interest under its assumptions. Actual returns, fees and taxes are outside the formula.

Moving the same contributions to each month’s beginning gives about 1280.932804332894 with Type=1. An initial deposit belongs in PresentValue, rather than being added to every monthly payment. The two 24-period examples include both an initial 1000 deposit and recurring 200 contributions.

Let q=(1+r)^n. For end-period payments, FV=−PV×q−p×(q−1)/r. For beginning-period payments, only the payment term receives an additional factor 1+r. At zero rate, the separate source branch is −PV−p×n.

With no recurring payments, =FV(0.05;10;0;-1000) gives approximately 1628.894626777441, independently equal to 1000×1.05^10. The sign of the initial deposit is part of the cash-flow equation, not a formatting trick.

A PV/FV round trip can check consistent signs and timing. If a present value is calculated for a fixed payment stream, substituting that signed present value into FV with the same rate, count and payments recovers the chosen final target within rounding. A round trip verifies consistency of the model, not the plausibility of its assumed return.

The period count need not be an integer for the source’s algebra, but real payment dates still require an explicit schedule. Display rounding does not change accumulated balances or introduce cent-by-cent rounding. Keep currency formatting separate from the actual stored amounts, and reconcile any contractual final installment separately.

NPV, XNPV, power.

• Function-specific release entry
• Calculation helper

The generated ODF input produced the informational load warning “Not all attributes could be read.” After it was acknowledged, the sheet was hard-recalculated and saved separately. All eight ordinary function identities and results were reconciled; a stale SUM cache changed from 999999 to 3 and an uncached SUM returned 7. This establishes the stated formula examples, not every workbook style or every invalid input. The original XLSX was not executed. Other explanatory calculations are independent mathematical checks; this guide does not claim a fully executed amortization schedule, other releases or all boundary cases.