194
Chapter 9: Financial Features
Conversion functions
11
→
Apr (
→
Apr (effective interest rate, number of settlements)
Convertseffectiveinterestratetonominalinterestrate
Example
If the effective interest rate
is12.55%,howmuchisthe
nominal interest rate for the
quarterly compound interest? If
the monthly compound interest
rateis10.5%,howmuchisthe
nominal interest rate?
12
→
Eff (
→
Eff (nominal interest rate, number of settlements)
Convertsnominalinterestratetoeffectiveinterestrate
Example
If the annual (nominal) interest
rateis8%,howmuchisthe
effective interest rate for monthly
compoundinterest?Howmuch
is it over half a year?
13 days ( days (start month.day year, end month.day year)
days (day month.year, day month.year)
Calculatesthenumberofdaysbetweendatesentered(withinthe
range of 1950 to 2049)
Year,month,anddaymust
beenteredin2-digitform.For
example, enter 02 for 2002.
Calculatethenumberofdays
fromSeptember1,2012to
December 31, 2019.