Difference between revisions of "Documentation/How Tos/Calc: INTRATE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
Line 28: | Line 28: | ||
=== See also: === | === See also: === | ||
[[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']] | [[Documentation/How_Tos/Calc: RECEIVED function|'''RECEIVED''']] | ||
+ | |||
+ | [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|'''Financial date systems''']] | ||
'''[[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]''' | '''[[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]]''' | ||
[[Documentation/How_Tos/Calc: Financial functions|'''Financial functions''']] | [[Documentation/How_Tos/Calc: Financial functions|'''Financial functions''']] |
Revision as of 17:10, 17 July 2008
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%.