EFFECT in Collabora Office: Convert a Nominal Rate Into an Effective Annual Rate
Use Collabora EFFECT for periodic compounding, keep nominal and effective rates distinct, and verify the annual accumulation factor.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =EFFECT(12%;12) has independently expected result approximately 12.682503013%. It converts a nominal annual rate of 12%, compounded monthly, into an effective annual rate.
Syntax and compounding convention
=EFFECT(Nom; P)
Nom is the nominal annual interest rate, entered as a fraction such as 0.12 or 12%. P is the number of compounding periods per year. Both arguments are required. For the ordinary examples, use a nonnegative nominal rate and an integer P>=1.
The independent formula is (1+Nom/P)^P-1. The periodic rate is Nom/P; the effective annual rate reflects the compounding over P periods. This is a rate conversion, not a calculation of fees, taxes or cash-flow timing.
The dedicated help describes interest-payment periods. The mathematical interpretation here assumes periodic interest compounds or is reinvested at the stated periodic rate. A cash distribution withdrawn rather than compounded describes a different accumulation model.
Example 1: compare annual, quarterly and monthly compounding
Put 1, 4 and 12 in A2:A4. Put nominal annual rate 12% in F2. Enter =EFFECT($F$2;A2) in B2 and fill down.
Independent effective annual rates are 12%, approximately 12.550881%, and approximately 12.682503013%, respectively. More frequent compounding increases the effective rate for this positive fixed nominal annual rate.
In C2 use =(1+$F$2/A2)^A2-1 and fill down as a transparent mathematical check. Format B and C as percentages; the stored monthly-compounding result is about 0.126825030, not 12.682503030.
Example 2: verify an accumulated amount
For a hypothetical starting amount of 1000, monthly compounding at a nominal 12% gives =1000*(1+12%/12)^12, independently approximately 1126.825030132.
The equivalent expression =1000*(1+EFFECT(12%;12)) should target the same amount. This checks the interpretation of the returned annual rate without introducing new deposits or withdrawals.
The example is a mathematical illustration. It does not compare actual financial offers, include charges or certify a promised return.
Advanced application: reproduce the official example
=EFFECT(9.75%;4) has independently expected value approximately 0.101123125, or 10.112312546%. The dedicated Collabora help rounds this to 10.11%.
Retain the full result for later calculations. Replacing it with the displayed 10.11% before a multiyear projection introduces an additional rounding step. A percentage format can shorten the display while preserving the calculated value.
Advanced application: invert the conversion
=NOMINAL(EFFECT(12%;12);12) has independent target 12%. Use the same compounding count in both directions. If the second function uses four instead of twelve, it asks for a different nominal-rate convention.
A monthly rate can also be recovered from an effective annual rate e as (1+e)^(1/12)-1. Simply dividing the effective annual rate by twelve does not reverse compounding.
Source-level edge cases
The inspected current Collabora core source rejects a negative nominal rate or P<1, returns zero for Nom=0, and approximately floors positive fractional P before the positive-rate calculation. Use an integer period count rather than relying on that conversion.
These observations concern core EFFECT, not a differently named EFFECT_ADD function. They come from a moving-main source snapshot and do not certify a specific installed desktop error message. NOMINAL’s zero-rate guard in the same source is different, so do not generalize one function’s zero handling to the other.
Errors and troubleshooting
Check percentage entry first: 12 means twelve as a rate, or 1200%, whereas 12% means 0.12. Check whether the supplied rate is nominal or already effective, and whether P counts periods within one year.
The function does not infer payment frequency from dates or account for irregular periods. Use a rate and compounding convention matched to the intended model; validate actual-product terms separately. No native Collabora execution occurred for these examples.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help. The snapshot was retrieved on 2026-10-13 and hash-verified on October 15, 2026. Desktop help does not establish Online or mobile support. First introduced release and last functioning version are unknown; the dedicated evidence does not establish them.
No native Collabora or WPS run occurred. Worked values are independent mathematical expectations, not verification of every native error, coercion or numerical limit. Formulas use English names and semicolon separators.
A current Collabora interpreter source snapshot retrieved October 15, 2026 corroborates the stated formula or input handling. It is a moving-main source snapshot rather than a pinned 26.04 binary or native application execution.