Formula
For each offer: monthly payment = amount × r ÷ (1 − (1 + r)^−m), where r = rate ÷ 12 and m = term in months.
Total cost of borrowing = monthly payment × m + fees − amount. This is every dollar you pay beyond what you borrowed.
APR including fees is the annualized rate at which (amount − fees) received today equals the present value of the m payments; it is the internal rate of return of the offer, times 12.
Lowest total cost is the offer with the smallest total cost of borrowing; lowest monthly payment is the offer with the smallest payment.
Worked examples
Example 1: three $100,000 offers at 9, 14 and 24 percent (the defaults)
Offer A: $100,000 at 9 percent for 60 months with $2,000 fees. r = 0.0075; (1.0075)^−60 = 0.6387; payment = $750 ÷ 0.3613 = $2,075.84. Total of payments = $124,550. Total cost = $124,550 + $2,000 − $100,000 = $26,550. APR on $98,000 net = 9.87 percent. Offer B: 14 percent for 36 months, $1,000 fees. r = 0.011667; (1.011667)^−36 = 0.6587; payment = $1,166.67 ÷ 0.3413 = $3,417.76. Total of payments = $123,039; total cost = $123,039 + $1,000 − $100,000 = $24,039; APR = 14.71 percent. Offer C: 24 percent for 18 months, $3,000 fees. r = 0.02; (1.02)^−18 = 0.7002; payment = $2,000 ÷ 0.2998 = $6,670.21. Total of payments = $120,064; total cost = $23,064; APR = 28.19 percent. Lowest total cost: Offer C at $23,064. Lowest payment: Offer A at $2,075.84. The most expensive money by APR is the cheapest in dollars because it is held for the shortest time.
Example 2: $50,000 offers where the lowest rate is not the cheapest
Offer A: $50,000 at 12 percent for 24 months, no fees. r = 0.01; (1.01)^−24 = 0.7876; payment = $500 ÷ 0.2124 = $2,353.67. Total of payments = $56,488; total cost = $6,488; APR = 12.00 percent (no fees, so APR equals the rate). Offer B: 10 percent for 48 months, $2,500 fees. r = 0.008333; (1.008333)^−48 = 0.6712; payment = $416.67 ÷ 0.3288 = $1,268.13. Total of payments = $60,870; total cost = $60,870 + $2,500 − $50,000 = $13,370; APR on $47,500 net = 12.74 percent. Offer C: 30 percent for 12 months, $500 fees. r = 0.025; (1.025)^−12 = 0.7436; payment = $1,250 ÷ 0.2564 = $4,874.36. Total = $58,492; total cost = $8,992; APR = 32.00 percent. Lowest cost: A at $6,488. Lowest payment: B at $1,268.13. Offer B has the lowest rate on paper and the highest cost in dollars: twice the term and a $2,500 fee more than double the interest.