A resource for the Professional Risk Manager (PRM) exam candidate. Sample PRM exam questions, Excel models, discussion forum and more for the risk professional.
Rates come in two varieties: simple interest, and compound interest. Simple interest means you earn a rate of interest on the principal, and that is it. The principal never increases due to interest being added to it. Compound interest, as we remember from high school, compounds the interest periodically. Continuously compounded interest is an extreme case where the compounding frequency approaches infinity.
We should be able to convert from one rate type to another, as this is often needed for a number of calculations across many subjects. This tutorial in particular looks at continuously compounded rates as
Simple interest calculations are very straightforward, but rarely used in practice in finance. For the rest of this discussion, we use the following notation:
- FV be the future value of a deposit,
- PV its present value (or principal),
- r the nominal annual interest rate,
- t the time
- m the compounding frequency per year and
- n the number of periods (also equal to t*m), then:
Using simple interest, FV = PV x (1 + rt)
When using compound interest, the interest is periodically added to the principal at intervals determined by the compounding frequency. If the compounding frequency is m, then:
So if the frequency of compounding is 2, and the nominal rate is 5%, a deposit of $100 will grow to
As we keep on increasing the compounding frequency, we will find that the future value of the deposit will keep on increasing as interest earned gets to work earlier and the deposit starts earning more money on the interest sooner. But the increase in the final future value is not infinite, no matter how high the compounding frequency is. As the compounding frequency rises to infinity, the FV approaches an amount equal to e^{rt}, where e is the base of the natural logarithm. (What ‘e’ signifies is not relevant for the PRM exam, but what is relevant for us is to remember that e^{rt }can be evaluated in Excel using the function EXP, so e^{rt}= EXP(rt).
FV = e^{rt}
What is the continuously compounded rate of return if we know prices?
Continuously compounded rates of return are also called ‘log returns’. If S_{2} is the price at the end of a period, and S_{1} the price in the beginning, then:
Return based on simple interest = S_{2}/S_{1} – 1
Continuously compounded return = ln(S_{2}/S_{1}), where ln is the logarithmic function.
(In Excel, the function is called exactly that – ie LN, and you can calculate logarithmic returns in Excel using the formula =LN(S_{2}/S_{1}))
Annual effective rate and continuously compounded rates
Annual effective rate, also called the “APY” (annual percentage yield) in the United States, is a standardized way of expressing rates with different nominal rates and compounding frequencies. It is a way of expressing any given interest rate in terms of the equivalent simple interest rate for one year. For example, for a CD paying a rate of 5% annually compounded every six months, the annual effective rate is 5.625%.
If we know the annual effective rate, we can calculate the continuously compounded returns as
Continuously compounded rates are much easier to deal with. For example, if an investment earned 2% in one period and 3% in the next period, the total return is (1 + 2%) x (1 + 3%) – 1. However, if these were continuously compounded rates, we could just add the returns to mean 5%. This follows from the property of logarithmic functions that continuously compounded rates are.
Remember the following with reference to continuously compounded rates:
FV=PV x e^{rt }= exp(rt)
PV=FV x e^{-rt }= exp(-rt). This intuitively follows from the equation for FV because PVs are just the same as FVs with negative time elapsed.
, where FV is future value (for example, a price at the end of a period) and PV is the present value (for example, a current price)