(17BII) TVM with introductory interest rate

07072015, 01:20 PM
(This post was last modified: 06152017 01:23 PM by Gene.)
Post: #1




(17BII) TVM with introductory interest rate
fhub provided me with the basic formula that's in use here. This equation lets you solve TVM problems with two separate interest rates: i%1 for the first n1 periods, and i%2 for the last n2 periods. This can be useful for opening a revolving balance charge account that has a promotional introductory rate, and you'd like to calculate a uniform payment amount to pay off the balance after a set number of periods. This uses SPFV and USFV extensively, since those calculate (1+i/100)^n and ((1+i/100)^n1)/(i/100) respectively without losing accuracy for very small values of i.
Usage: Pretty much like the builtin TVM solver, except instead of I%YR and N, you've got I%1, N1, I%2, and N2. I%1 is the annual interest rate for the first N1 periods, and I%2 is the annual interest rate for the remaining N2 periods. Make sure you set the PYR variable appropriately (probably 12 or 1). For beginningperiod payments, store 1 in BEG. For endingperiod, store 0. Line breaks added for clarity. Code: 0x(N1+I%1+N2+I%2+PYR+PV+PMT+FV+BEG) 

« Next Oldest  Next Newest »

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