Documentation/How Tos/Calc: INTRATE function
From Apache OpenOffice Wiki
< Documentation | How Tos
INTRATE
Returns the equivalent annual interest rate for an item bought at one price and sold at another.
Syntax:
INTRATE(purchasedate; saledate; purchasevalue; salevalue; basis)
- purchasedate: the date the item was bought.
- saledate: the date the item was sold.
- purchasevalue: the amount paid for the item.
- salevalue: the amount received for the item.
- basis: is chosen from a list of options and indicates how the year is to be calculated. Defaults to 0 if omitted.
- 0 - US method (NASD), 12 months of 30 days each
- 1 - Exact number of days in months, exact number of days in year
- 2 - Exact number of days in month, year has 360 days
- 3 - Exact number of days in month, year has 365 days
- 4 - European method, 12 months of 30 days each
The equivalent interest rate returned is the (annually compounded) interest rate that would have to be paid on an investment of purchasevalue to turn it into salevalue on the date of sale.
Example:
INTRATE("2005-02-02"; "2008-12-03"; 1000; 2000)
- returns approximately 0.26, or 26%.