Effective Interest Rate with Prepayment
Prepayment is the process of paying down the loan early by increasing principal payments or by selling the home. On average, most homeowners in the United States move every five to seven years. You should know how to calculate your effective interest rate when you plan to prepay the loan (or sell the house) before maturity.
The EIR with prepayment is calculated in a similar manner to the EIR, except you must make an additional calculation for the balloon payment you will make when you pay off the loan.
1. Calculate the payments on the total amount you will be repaying (the amount borrowed). Using your financial calculator, set N = your number of years, I = your interest rate, PV = the loan amount, and solve for your payment, or PMT.
2. Calculate the amount of money you actually received for your loan (the total loan less all costs). Again, assume that all costs for the home come out of the loan. This amount becomes your present value (with a minus sign).
3. Calculate the balance that will remain after you prepay; in other words, calculate your balloon payment. This is the amount that you will need to pay off the remainder of the loan. To calculate the balloon payment, set N to the number of years or periods you will pay off the loan early. If you have a thirty-year loan, and you pay the loan off after twelve years, you want to know the present value of 30 â€“ 12, or eighteen years of payments. Set I to your interest rate, PMT to your monthly or annual payments, and solve for the present value. This balloon payment is the amount of principal that you will still owe after you prepay your loan. This amount becomes your future value.
4. Finally, set the number of years before prepayment as N (twelve years in the above example), the balloon payment or balance remaining as FV, the PMT as monthly or annual payments, the PV as negative the amount you received after paying points and fees, and solve for I to find your effective interest rate.