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%?

$\endgroup$
1
  • $\begingroup$ You should add (if true) that the loan starts on 01/01/2012. $\endgroup$
    – Henry
    Nov 19, 2012 at 23:08

2 Answers 2

Reset to default
1
$\begingroup$

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.

$\endgroup$
4
  • $\begingroup$ Henry, forgive my total ignorance but would you provide a more "layman" formula for arriving at "i" (0.1608..) with the exact values plugged in e.g. 5000 * 242.65 / 365 x 1 ^ (2 * 365/365) = i. When I have that I will try different scenarios within the software program to see if the 12 X ((1 + i)^(1/12) - 1) answers the question. Thank you. $\endgroup$
    – Minimul
    Nov 20, 2012 at 11:56
  • $\begingroup$ @Christian: Try $$\frac{242.64}{1.16\ldots^{31/365.25}}+\frac{242.64}{1.16\ldots^{60/365.25}}+ \cdots + \frac{237.32}{1.16\ldots^{731/365.25}}$$ as there are 31 days in January, 29 days in February with a leap day, ..., and 731 days in two years including a leap day. Use $1.1608753866$ instead of $1.16\ldots$ and it should add up to 5000. $\endgroup$
    – Henry
    Nov 20, 2012 at 12:17
  • $\begingroup$ Thanks for your comment. I am trying to write a formula whereby I isolate "i" (i.e. "i" is on the left side of the formula). What would the right side of the formula look like? $\endgroup$
    – Minimul
    Nov 20, 2012 at 20:12
  • $\begingroup$ @Christian: I doubt there is a closed form expression. Nor, with spreadsheets or other computer tools, does there need to be. $\endgroup$
    – Henry
    Nov 20, 2012 at 21:41
1
$\begingroup$

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.

$\endgroup$
2
  • $\begingroup$ Thanks. Looking at the link now. To get the payment of 242.64 you figure the rate in this fashion for daily rate or true daily earnings: (1 + .15/365)^(365/12)-1 . Spreadsheet formula of: =-PMT((1 + .15/365)^(365/12)-1,24,5000) $\endgroup$
    – Minimul
    Nov 26, 2012 at 14:25
  • $\begingroup$ awesome.. thank you for the clarification.. $\endgroup$
    – cagdas
    Dec 2, 2012 at 19:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.