In 2017 my Website was migrated to
the clouds and reduced in size.
Hence some links below are broken.
One thing to try if a “www” link is broken is to substitute “faculty” for “www”
For example a broken link
http://faculty.trinity.edu/rjensen/Pictures.htm
can be changed to corrected link
http://faculty.trinity.edu/rjensen/Pictures.htm
However in some cases files had to be removed to reduce the size of my Website
Contact me at rjensen@trinity.edu if
you really need to file that is missing
Working Paper 440
Annuities With Unequal Compounding and Payment Periods:
The CFA Deconstruction Analysis
Bob Jensen
at Trinity University
Before reading this you may want to peruse my document on the Wolfram Alpha
Computational and Word Search Engine ---
Some Things You Might Want to Know About the Wolfram Alpha (WA) Search
Engine: The Good and The Evil
as Applied to Learning Curves (Cumulative Average vs. Incremental Unit)
http://faculty.trinity.edu/rjensen/theorylearningcurves.htm
The discussion below is not about learning curves, but I will use the WA search engine.
Financial calculators and Excel financial formulas for computing present value, interim payments, and rates of return assume that p=m where p is the number of equally-spaced payments per year and m is the number equally-spaced interest compoundings per year. Complications introduced by p not being equal to m are not trivial problems. These complications are overlooked in many (probably almost all) mathematics of finance modules in both high school and college courses.
This note will demonstrate how to deal with complications when the number of payments per year is unequal to the number in times interest is compounded per year. This is not a purely academic problem. Companies buying and selling annuities often do not want to change the number of times interest is compounded every time they change the number of payments per year in a contract such as semi-annual payments versus quarterly payments versus monthly payments.
The paper was inspired by the following working paper sent to me by an Australian professor named Chris Deeley. Chris subsequently allowed me to put his paper on one of my Web servers:
"IDENTIFICATION AND CORRECTION OF A COMMON ERROR IN GENERAL ANNUITY CALCULATIONS"
by Chris Deeley,
Working Paper, Charles Sturt University, Australia, September 22, 2010
http://www.cs.trinity.edu/~rjensen/temp/DeeleyAnnuityCorrections.pdf
cdeeley@csu.edu.au
For illustrative purposes I will focus on the following example on Page 11 of Professor Deeley's working paper:
Example 2
A loan of $1million is to be repaid in equal monthly installments over four years. If the annual interest rate is 10% compounded semi-annually, how much is the monthly repayment?
The two solutions given by Professor Deeley for p=12 payments per year and m=2 interest compoundings per year are as follows:
Deeley Solution 1 PMT = $25,265.60 per month which Professor Deeley claims the "conventional solution"
Deeley Solution 2 PMT = $25,260.70 per month which Professor Deeley claims is his "proposed better solution"
I contend that there is a CFA Deconstruction and Rate Equivalence solution that I offer as an "alternate conventional solution" that is used of Certified Financial Analyst (CFA) examinations.
CFA Deconstruction PMT = $25,483 per month which conforms to David Frick's solution tutorial
David R. Frick Tutorials provides some outstanding mathematics of finance tutorials (free) --- http://www.frickcpa.com/
Time Value of Money Tutorials --- http://www.frickcpa.com/tvom/TVOM_Compound.asp
In particular I will focus on the following David Frick tutorial
Present Value of an Annuity Tutorial --- http://www.frickcpa.com/tvom/TVOM_PV_Annuity.asp#periodBefore beginning my analysis below, I might point out that in his own illustration, David Frick has a somewhat misleading formula. The formula in his illustration reads as follows:
The formula of his illustration should read as follows for p=1 in this illustration:
The two formulas are equivalent only in the special case where p=1 is the number of annuity payments per year. In the general case when p>1, the latter formula would put in the correct m and the two formulas would not be equivalent.
For illustrative purposes I will focus on the following example on Page 11 of
Professor Deeley's working paper ---
http://www.cs.trinity.edu/~rjensen/temp/DeeleyAnnuityCorrections.pdf
Example 2
A loan of $1million is to be repaid in equal monthly installments over four years. If the annual interest rate is 10% compounded semi-annually, how much is the monthly repayment?
m=2 interest compoundings per year p=12 monthly payments per year n=48 monthly payments over four years PV=$1,000,000 present value i=0.10 annual interest rate in the annuity contract For the CFA Deconstruction solution we compute an equivalent i' interest rate to use in place of the i=0.10 rate. We get the following:
i' = 0.1025
=(1+0.10/2)^(2) - 1
CFA Deconstruction PMT = $25,483 per month which conforms to David Frick's solution tutorial
=1000000/((1-(1+0.1025/12)^(-48))/(0.1025/12))
The present value of $1,000,000 can be derived using the equivalent 0.1025 interest rate and $25,482.81 monthly annuity payments:
The Excel file below can be downloaded from
http://www.cs.trinity.edu/~rjensen/temp/Annuity01.xlsx
Example 1 from Page 11 of | http://www.cs.trinity.edu/~rjensen/temp/DeeleyAnnuityCorrections.pdf | |||||
CFA Deconstruction Solutions | http://www.frickcpa.com/tvom/TVOM_PV_Annuity.asp#period | |||||
m= | 2 | m= | 12 | m= | Compoundings per year | |
p= | 12 | p= | 1 | p= | Payments per year | |
n= | 48 | n= | 3 | n= | Total payments | |
PV= | $1,000,000 | PV= | $130.67 | |||
i= | 0.10000000 | Check i= | 0.07000000 | |||
I'= | 0.10250000 | Check I'= | 0.07229008 | http://www.frickcpa.com/tvom/TVOM_PV_Annuity.asp#period | ||
PMT= | $25,483 | PMT= | $50.00 | http://www.frickcpa.com/tvom/TVOM_PV_Annuity.asp#period | ||
PV= | $1,000,000 | PV= | $130.67 | http://www.frickcpa.com/tvom/TVOM_PV_Annuity.asp#period | ||
Check PV= | $1,000,000 | Check PV= | $130.67 | |||
Check PMT= | $25,483 | Check PMT= | $50.00 | |||
![]() |
||||||
![]() |
||||||