Financial calculation question: variable interest rate

07042015, 09:55 PM
Post: #1




Financial calculation question: variable interest rate
Suppose I open a home equity line of credit that has a 1.99% introductory rate for 6 months. Then I immediately finance something for, say $4000. After 6 months, the interest rate increases to 2.99%. How would I go about calculating 12 equal payments to have the financed amount fully paid off at the end of 12 months?
Note I'm assuming such a credit line has beginningperiod payments like a credit card, and the interest will compound at 1.99% APR six times before changing to 2.99%. 

07052015, 10:16 AM
(This post was last modified: 07052015 12:10 PM by fhub.)
Post: #2




RE: Financial calculation question: variable interest rate
(07042015 09:55 PM)Dave Britten Wrote: Suppose I open a home equity line of credit that has a 1.99% introductory rate for 6 months. Then I immediately finance something for, say $4000. After 6 months, the interest rate increases to 2.99%. How would I go about calculating 12 equal payments to have the financed amount fully paid off at the end of 12 months? Well, the TVM equation for this problem is: (it's easy to calculate PMT=... from it) PV*(1+i1)^6*(1+i2)^6 + PMT*((1+i1)^61)/i1*(1+i1)*(1+i2)^6 + PMT*((1+i2)^61)/i2*(1+i2)=0 PV=4000, i1 and i2 are the monthly interest rates of 1.99% and 2.99% (depending on whether APR means nominal or effective annual rate), i.e. either i1=1.99%/12 (for nom. APR) or i1=(1+1.99%)^(1/12)1 (for eff. APR). PS: the result is PMT=$336.728 (for nom. APR) and PMT=$336.689 (for eff. APR). Franz 

07062015, 02:37 PM
(This post was last modified: 07062015 05:20 PM by Dave Britten.)
Post: #3




RE: Financial calculation question: variable interest rate
(07052015 10:16 AM)fhub Wrote:(07042015 09:55 PM)Dave Britten Wrote: Suppose I open a home equity line of credit that has a 1.99% introductory rate for 6 months. Then I immediately finance something for, say $4000. After 6 months, the interest rate increases to 2.99%. How would I go about calculating 12 equal payments to have the financed amount fully paid off at the end of 12 months? Excellent, thanks. Now, if I wanted to generalize this a bit before entering it into my 17BII, would this be the correct way to have optional begin/endperiod payments, and tack on FV (in case it needs to be nonzero)? (B = 1 for beginning, 0 for ending) PV*(1+i1)^n1*(1+i2)^n2 + PMT*((1+i1)^n11)/i1*(1+B*i1)*(1+i2)^n2 + PMT*((1+i2)^n21)/i2*(1+B*i2) + FV = 0 EDIT: That seems to be working, based on the results I'm getting and then comparing to the builtin TVM solver (doing it piecewise, i.e. solve for FV with n=6, change the sign and stuff it back in PV, update the interest rate, and solve for FV again). Error is a good 8 decimal places out, and it's possible that's just because I'm running the solver in Fix 8 mode. Corrections still welcome if anybody finds any problems with it. 

07072015, 08:36 AM
Post: #4




RE: Financial calculation question: variable interest rate  
07072015, 11:12 AM
Post: #5




RE: Financial calculation question: variable interest rate
(07072015 08:36 AM)fhub Wrote:(07062015 02:37 PM)Dave Britten Wrote: Corrections still welcome if anybody finds any problems with it.No corrections necessary, your general formula is perfect! I don't think it's terribly common. Probably just for credit cards, credit lines, and other revolving balance sort of accounts. I was offered a home equity credit line with a promotional introductory rate of 1.99% for 6 months, after which it would go to its normal rate of around 2.742.99%. I wanted to play with a few numbers to get an idea of finance charges over 6 months, 12 months, etc. but didn't know how to calculate a uniform payment for that situation. Thanks for your help! 

« Next Oldest  Next Newest »

User(s) browsing this thread: 1 Guest(s)