Difference between revisions of "Documentation/How Tos/Calc: NOMINAL ADD function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m |
||
| Line 20: | Line 20: | ||
<tt>'''NOMINAL_ADD(0.06; 4)'''</tt> | <tt>'''NOMINAL_ADD(0.06; 4)'''</tt> | ||
: returns approximately <tt>'''0.0587'''</tt>, which is the nominal rate for an investment with a effective rate of 6% per annum, compounded quarterly. | : returns approximately <tt>'''0.0587'''</tt>, which is the nominal rate for an investment with a effective rate of 6% per annum, compounded quarterly. | ||
| + | |||
| + | === Issues: === | ||
| + | * The calculation assumes that interest is credited at the end of exactly equal periods. In reality different quarter-years, for example, have different numbers of days. | ||
{{Documentation/SeeAlso| | {{Documentation/SeeAlso| | ||
| Line 32: | Line 35: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
| − | |||
| − | |||
| − | |||
Revision as of 16:23, 2 March 2009
NOMINAL_ADD
Returns a nominal interest rate given the effective compounded interest rate.
Syntax:
NOMINAL_ADD(eff_rate; num)
- eff_rate: the effective interest rate.
- num: the number of times interest is credited / compounded during the period that the nominal rate applies to.
- If an investment has a nominal rate, say for a year, but interest is paid and credited say each quarter, the interest paid each quarter will itself start earning interest. This increases the effective value. The effective rate is the rate that would have to be paid at the end of the (say) year to give the same return.
- Given an effective rate, this function returns the appropriate nominal rate.
- The formula used is:
- nom_rate = num[(1 + eff_rate)1/num - 1]
Example:
NOMINAL_ADD(0.06; 4)
- returns approximately 0.0587, which is the nominal rate for an investment with a effective rate of 6% per annum, compounded quarterly.
Issues:
- The calculation assumes that interest is credited at the end of exactly equal periods. In reality different quarter-years, for example, have different numbers of days.
