INTRATE in Collabora Office: Measure Simple Annualized Investment Gain
Calculate Collabora INTRATE from purchase and sale amounts, audit the documented painting example, and distinguish simple annualization from compounded growth.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =INTRATE(DATE(2026;1;15);DATE(2026;7;15);980;1000;0) has independently expected rate approximately 4.081632653%. It annualizes the gain relative to the initial investment under the chosen day-count convention.
Syntax and cash-flow scope
=INTRATE(Settlement; Maturity; Investment; Redemption [; Basis])
Settlement is the purchase date. Maturity is the sale/redemption date. Investment is the purchase amount, and Redemption is the amount received at sale. All four are required; Basis is optional and defaults to zero.
| Basis | Documented convention |
|---|---|
| 0 or omitted | US NASD, twelve 30-day months |
| 1 | Actual days in months and actual days in the year |
| 2 | Actual days in months, 360-day year |
| 3 | Actual days in months, 365-day year |
| 4 | European method, twelve 30-day months |
Use genuine date values or DATE formulas. The examples below use explicit bases and ordinary dates so the date and year conventions remain visible. A day-count basis is part of the calculation model, not a display preference.
The vendor describes this as a purchase-and-sale calculation with no interest paid during the holding period. Intermediate coupons, deposits, fees, or withdrawals are not separate arguments and must not be silently treated as if the function modeled them.
The result is an annualized decimal rate. Use percentage formatting for interpretation while retaining the numeric rate for later calculations.
Example: a transparent half-year gain
Put =DATE(2026;1;15) in A2, =DATE(2026;7;15) in B2, 980 in C2, 1000 in D2, and 0 in E2. Enter =INTRATE(A2;B2;C2;D2;E2) in F2.
The independent calculation is (1000−980)/980×360/180, giving approximately 0.04081632653, or 4.081632653%. The holding-period gain is 20/980, and the 30/360 half-year factor annualizes it by two.
Doubling both cash amounts to 1960 and 2000 leaves the independent rate unchanged because their ratio is unchanged. Mixing currencies or using purchase and sale amounts on different scales invalidates that comparison.
Reproduce the vendor’s long-holding example
The help describes buying a painting on 1990-01-15 for 1000000, then selling it on 2002-05-05 for 2000000, with basis three. Its formula is:
=INTRATE(DATE(1990;1;15);DATE(2002;5;5);1000000;2000000;3)
The documented result is 8.12%. Independent date arithmetic gives 4493 actual days. The simple annualized gain is (2000000−1000000)/1000000×365/4493, approximately 8.123748053%, consistent with the source’s rounding.
That match also clarifies the model: the function’s documented example uses simple annualization of the total gain, not a compounded annual growth rate.
Advanced comparison: a compounded rate answers another question
For the painting example, the independent compounded annual rate under the same 365-day time convention would be:
=(2000000/1000000)^(365/4493)-1
This gives approximately 5.792509323%, substantially below the simple annualized 8.123748053%. The compounded rate answers what constant annual growth factor would reproduce the observed doubling. INTRATE’s documented result uses the total gain divided across the elapsed-year fraction.
Do not label the function’s result CAGR. A name such as “simple annualized gain, actual/365” makes its meaning more precise.
Advanced application: verify an amount from the rate
For the half-year example, take the independently computed rate r≈0.04081632653 and evaluate =980*(1+r*0.5). The expected redemption is 1000 before rounding effects.
This reverse check shows where the initial investment and time fraction enter. Retain enough precision in r for the audit; ROUND can be applied separately to a displayed percentage or currency amount.
A rate rounded to two percentage decimals may not reconstruct the exact original cash amount, especially for large investments or long holding periods. That is a display-precision issue rather than proof of a different underlying model.
Errors and limitations
Use valid dates with a positive holding interval and consistent positive purchase/redemption amounts. The dedicated section does not give a complete error-code table, invalid-input coercion rules, or every actual/actual and month-end boundary convention.
The calculation does not model interim cash flows, reinvestment, inflation, taxes, or transaction costs. DATE provides unambiguous date inputs. The examples illustrate documented function behavior and independent arithmetic, not a recommendation about any actual asset or transaction.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.
The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.
References
- Collabora Office 26.04: INTRATE (checked October 17, 2026).
- Editorial testing standards.