Difference between revisions of "Documentation/How Tos/Calc: INTRATE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
(→Syntax:) |
||
| Line 17: | Line 17: | ||
:: 4 - European method, 12 months of 30 days each | :: 4 - European method, 12 months of 30 days each | ||
| − | The equivalent interest rate returned is the ( | + | : The equivalent interest rate returned is the (un-compounded) interest rate that would have to be paid on an investment of <tt>'''purchasevalue'''</tt> to turn it into <tt>'''salevalue'''</tt> on the date of sale. |
| + | |||
| + | : The formula used is: | ||
| + | :: (salevalue - purchasevalue)/salevalue * (days_in_a_year/days_item_owned) | ||
=== Example: === | === Example: === | ||
Revision as of 06:52, 12 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)/salevalue * (days_in_a_year/days_item_owned)
Example:
INTRATE("2005-02-02"; "2008-12-03"; 1000; 2000)
- returns approximately 0.26, or 26%.
