(27S) Interest Rate Conversions

(27S) Interest Rate Conversions - Printable Version

+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Software Libraries (/forum-10.html)
+--- Forum: General Software Library (/forum-13.html)
+--- Thread: (27S) Interest Rate Conversions (/thread-14008.html)

(27S) Interest Rate Conversions - Dave Britten - 11-18-2019 02:59 PM

This program replicates the nominal/effective interest rate conversions from the 17BII, 19BII, etc. It's implemented as two equations, one for periodic compounding, and one for continuous compounding. Both use the LNP1 and EXPM1 functions to provide accurate results for very large numbers of compounding periods, or very small interest rates.

Periodic compounding

Code:

I%CONV.PER:EFF%=EXPM1(LNP1(NOM%÷100÷P/YR)×P/YR)×100

Continuous compounding

Code:

I%CONV.CONT:EFF%=EXPM1(NOM%÷100)*100

Example:

Convert a nominal rate of 4.75% compounded monthly to an equivalent nominal rate with quarterly compounding.

Select the I%CONV.PER equation, press [CALC].

4.75 [NOM%]
12 [P/YR]
[EFF%] Output: 4.85
4 [P/YR]
[NOM%] Final result: 4.77