Documentation/How Tos/Calc: INTRATE function
From Apache OpenOffice Wiki
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 (un-compounded) interest rate that would have to be paid on an investment of purchasevalue to turn it into salevalue on the date of sale.
- The formula used is:
- (salevalue - purchasevalue)/purchasevalue * (days_in_a_year/days_item_owned)
Example:
INTRATE("2005-02-02"; "2008-12-03"; 1000; 2000)
- returns approximately 0.26, or 26%.
