2
$\begingroup$

This example comes from used car software that is approved in Texas, a state which calculates interest using a true daily earnings method (definition below):

The terms are:

  • Amount financed: 5,000
  • Interest rate: 15%
  • Number of payments: 24
  • Frequency: monthly
  • Loan starts: 01/01/2012

Here are the terms that are generated:

  • APR: 15.0065%
  • 23 payments of: 242.64
  • 1 final payment of: 237.32
  • Finance charge: 818.04
  • Total payments: 5,818.04

Here is the amortization table.

https://lh4.googleusercontent.com/-NyKZZ2QWaQA/UKqxs4aS8qI/AAAAAAAAB-I/iPjWqL_fykI/s784/amortized-sched-2.jpg

Texas defines true daily earnings as such:

(20) True daily earnings method--The true daily earnings method is a method to compute the finance charge by applying a daily rate to the unpaid principal balance. The daily rate is 1/365th of the equivalent contract rate. The earned finance charge is computed by multiplying the daily rate of the finance charge by the number of days the actual unpaid principal balance is outstanding.

My question is how are they getting the APR of 15.0065%?

  • 0
    You s$h$ould add (if true) that the loan starts on 01/01/2012.2012-11-19

2 Answers 2

1

The APR seems to me to be closer to 16.1%, at least in the natural British definition.

I will assume there are 365.25 days in a year [other assumptions from 365 to 366 make a very small difference to the numbers] and that $d$ is the number of days since 01/01/2012 when the 5000 is borrowed. Each payment $P_j$ is made on day $d_j$.

You are looking for the value of $i$ which makes $\sum_j P_j / (1+i)^{d_j/365.25} = 5000.$ I make $i \approx 0.1608753866$, i.e. about 16.1%.

This is not 15%. But if you change it to the confusing "continuously compounding rate" using the transformation $\log_e(1+i)$ you get approximately $0.149174364$ which although it is not a percentage might be described as about 14.9%. Closer, but not on the button. So instead, let's try a daily rate, by taking $365.25 \times ((1+i)^{1/365.25}-1)$ which might confusingly be called an annualised daily compounding rate. This is approximately $0.149204831$ and so still too low.

If you think that is absurd, see what may actually have happened in the calculation. Assume the 12 months of the year are equally long, measure months from 01/01/2012 and each payment $P_j$ is made on month $m_j$. Solve $\sum_j P_j / (1+i)^{m_j/12} = 5000.$ I make $i \approx 0.16082846598$, i.e. still about 16.1%.

The "continuously compounding rate" is still about 14.9%. But now the annualised monthly compounding rate $12 \times ((1+i)^{1/12}-1)$ is approximately $0.1500645$, very close to your 15.0065%. This is not an annual rate; nor is a daily rate used in the calculations.

  • 0
    @Christian: I doubt there is a closed form expression. Nor, with spreadsheets or other computer tools, does there need to be.2012-11-20
1

You can see here for APR calculation method they are most probably using:

http://www.fdic.gov/regulations/laws/rules/6500-1950.html#fdic6500appendixjtopart226

It is very much like what Henry said. Basically they take the present value formula and do interpolation on the APR (using monthly - not daily).

What I cannot understand is how they come up with the payment amount of 242.64. By my calculations, the standard payment would be 242.43 with last payment being 242.95. 242.45 would be closest to equal payments with last payment being 242.40. I have no idea how they got to 242.64. Maybe they were trying to minimize total interest by some criteria but I can't figure it out.

  • 0
    awesome.. thank you for the clarification..2012-12-02