Mismatch between payment period and compounding period always presents a vexing problem. Simplest solution? Fix it.
Is there a monthly compounding rate that is equivalent to your given annual rate?
Hi There, this is my first post. I am taking a business mathematics course, and the present focus is on amoritization. Thus far I have not run into any major problems, but one has now come along: Compounding annually.
Let me clarify the question, and I'll let you know what I've done so far:
Greg and Terri have just bought a home, mortgaged for $90,000, which is being amortized over twenty years with monthly payments. If the mortage has an interest rate of 23.21 percent, compounded annually, find:
a) The monthly payments.
b) the amount outstanding after the 24th payment.
c) construct a partial amortization table to show the first two payments and the last two payments of the loan.
a) This part I think I did correctly. I'm not sure how to type the formula, but because it was compounded annually, I used "f" where f= (1+i) to the power of c - 1. My answer was a monthly payment of $1603.79.
b) This has completely thrown me for a loop! I understand this process based off a monthly or semi-annual compound period, but I have no idea how to proceed with annual compounding. My textbook only uses monthly, quarterly, semi-annual.
Thank you so much for your help!
Thanks TK Hunny for your help, sorry if I seem not too bright at this: this one particular course is the one thing keeping me away from a BA in English Literature.
I don't have any more info about compounding periods, other than what the question provided. I didn't leave out any information that was part of the question. Can you tell me how I can convert my formula to do what you suggested?
Well, that paobably is very important information. It is then very likely that the massively complicated solutions I was contemplating simply are not applicable.
"Compounded" is a little confusing. Fortunately, Nominal and Effective are the same for periods of exactly one year. This means we can propbably pick how we want to solve this one. The most common information is the NOMINAL interest rate. Change the nominal annual rate to monthly simply by dividing by 12. 0.2321 / 12 = .0193416666...
Having established that, we simply need to know how to calculate the value of remaining payments.
First, a couple of definitions:
i = 0.19341667 = the monthly interest rate.
1+1 = 1.19341667 = monthly accumulation factor
v = 1/(1+i) = 0.98102535
P is the level payment amount
This gives: 90000 = p*(1-v^240)/i and p = $1,758.47 I really can't say how you arrived at your answer.
In any case, the rest is easy. With the payment, we can just blast through it.
What is the remaining balance after the last payment? 1758.47*(1-v^0)/i = 0
What is the remaining balance after the second-to-last payment, just one remaining? 1758.47*(1-v^1)/i = 1,725.10
What is the remaining balance after the third-to-last payment, just two remaining? 1758.47*(1-v^2)/i = 3,417.47
240-24 = 216
Accordingly, we have
Similarly, by deriving the monthly compounding rate j that is equivalent to your given annual rate of 23.21%, we get
and arrive at the same result. Thus
Accordingly, the amount outstanding after the 24th payment (using the prospective method) would be
Using the retrospective method, we have
Check and compare with my attached amortization schedules.