Here is the problem:
L: original loan amount
B: current balance after P periods
P: number of periods that have been paid
A: period payment
**you do not know the number of periods remaining, so you do not know N (the total number of periods for the loan), and you do not know the interest rate (that is what is to be found). Each payment includes both principal and interest.
Example: 56,000 loan, 460.54 period payment, $24,052 current balance, 120 periods have been paid, calculate the interest rate note: the correct answer will result in 5.6% and a total N = 180 periods
Because I do not know the real maturity date, I am getting stuck in the maths on how to calculate the interest rate. All that is known is the original amount, the current amount, period payment, and how many payments have been made. Any suggestions would be great!
There are two ways to solve a loan balance question: The Prospective (looking forward) and the Retrospective (looking backward) approach.
In this case, we do not know the number of periods remaining, so we cannot use the prospective method to solve this problem, as we are unable to determine the present value of the remaining payments. Instead, we should use the retrospective method.In this case, we calculate the loan balance as an accumulated value of the loan at the time of evaluation minus the accumulated value of all the payments made at the time of evaluation.
We can easily see that the accumulated value of the loan at time 120 is
$ B_{120} = 56000(1+i)^{120} $
In addition, the accumulated value of the annuity payments should be equal to
$ As_{120|i} = 460.54 * ((1+i)^{120} - 1)/i $
The first value minus the second value should result in 24,052, the current balance.
Solving using a financial calculator or linear approximation, it seems that $i^{(12)} = 5.6$% as required.
In an exam situation, you would never be asked to solve such a high exponential polynomial. They will more than likely use smaller cash flow periods, or solve using a financial calculator.