 (17BII) TVM with introductory interest rate - Printable Version +- HP Forums (https://www.hpmuseum.org/forum) +-- Forum: HP Software Libraries (/forum-10.html) +--- Forum: General Software Library (/forum-13.html) +--- Thread: (17BII) TVM with introductory interest rate (/thread-4317.html) (17BII) TVM with introductory interest rate - Dave Britten - 07-07-2015 01:20 PM 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)^n-1)/(i/100) respectively without losing accuracy for very small values of i. Usage: Pretty much like the built-in 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 beginning-period payments, store 1 in BEG. For ending-period, store 0. Line breaks added for clarity. Code: ```0x(N1+I%1+N2+I%2+PYR+PV+PMT+FV+BEG) +PV*SPFV(I%1/PYR:N1)*SPFV(I%2/PYR:N2) +PMT*USFV(I%1/PYR:N1)*SPFV(I%1/PYR:BEG)*SPFV(I%2/PYR:N2) +PMT*USFV(I%2/PYR:N2)*SPFV(I%2/PYR:BEG) +FV```