Formula
Monthly payment = loan amount × r ÷ (1 − (1 + r)^−months), where r = annual interest rate ÷ 12. Interest = monthly payment × months − loan amount.
All fees = loan amount × origination fee + closing, legal and appraisal costs + guarantee or packaging fee + monthly servicing fee × months + expected late fees. Total cost of the loan = interest + all fees.
Cost per dollar borrowed = total cost ÷ loan amount. Net proceeds at closing = loan amount − origination fee − closing costs − guarantee or packaging fee.
APR including fees = the annualized rate at which net proceeds equal the present value of months payments of (monthly payment + monthly servicing fee). Late fees are excluded from the APR because they depend on your behaviour, not the contract.
Worked examples
Example 1: $150,000 at 10.5 percent over 60 months with a 2 percent origination fee, $1,800 closing and $25 a month servicing (the defaults)
Payment: r = 0.105 ÷ 12 = 0.00875; (1.00875)^−60 = 0.5929; 1 − 0.5929 = 0.4071; $150,000 × 0.00875 = $1,312.50; $1,312.50 ÷ 0.4071 = $3,224.09. Interest = $3,224.09 × 60 − $150,000 = $193,445 − $150,000 = $43,445. Fees: origination = $150,000 × 0.02 = $3,000; closing $1,800; guarantee $0; servicing = $25 × 60 = $1,500; late fees $0; all fees = $6,300. Total cost = $43,445 + $6,300 = $49,745. Cost per dollar borrowed = $49,745 ÷ $150,000 = $0.332. Net proceeds = $150,000 − $3,000 − $1,800 − $0 = $145,200. APR: the rate at which $145,200 equals 60 payments of $3,224.09 + $25 = $3,249.09 is 12.26 percent, against the 10.5 percent note rate. The tool shows $49,745, $43,445, $6,300, $0.332, $145,200 and 12.26 percent. Fees are 13 percent of the total cost but add 1.76 points to the APR, because they are paid early or monthly rather than spread like interest.
Example 2: a short, high-rate loan with a large origination fee and some late fees
$75,000 at 28 percent over 18 months, 5 percent origination, no closing or guarantee fees, no servicing fee, $300 of expected late fees. Payment: r = 0.023333; (1.023333)^−18 = 0.6603; 1 − 0.6603 = 0.3397; $75,000 × 0.023333 = $1,750; $1,750 ÷ 0.3397 = $5,150.46. Interest = $5,150.46 × 18 − $75,000 = $92,708 − $75,000 = $17,708. Fees: origination $3,750; late $300; all fees = $4,050. Total cost = $21,758. Cost per dollar = $21,758 ÷ $75,000 = $0.290. Net proceeds = $75,000 − $3,750 = $71,250. APR = 35.18 percent. Here is the trap in cost per dollar: $0.290 over 18 months looks cheaper than the default loan's $0.332 over 60 months, yet the APR is nearly three times higher. Cost per dollar is a price; APR is a price per year. Both are needed, and the loan comparison calculator ranks three offers on both.
Example 3: a large SBA-style loan over ten years
$500,000 at 8 percent over 120 months, 1 percent origination, $6,500 of closing, legal and appraisal costs, a $10,000 guarantee fee, no servicing or late fees. Payment: r = 0.0066667; (1.0066667)^−120 = 0.4505; 1 − 0.4505 = 0.5495; $500,000 × 0.0066667 = $3,333.33; $3,333.33 ÷ 0.5495 = $6,066.38. Interest = $6,066.38 × 120 − $500,000 = $727,966 − $500,000 = $227,966. Fees = $5,000 + $6,500 + $10,000 = $21,500. Total cost = $249,466. Cost per dollar = $0.499. Net proceeds = $500,000 − $21,500 = $478,500. APR = 9.02 percent. Half a dollar of cost per dollar borrowed sounds alarming and is simply what ten years of 8 percent money costs; the APR of 9.02 percent is low by any small business standard. Fees add about a point because they are spread over 120 payments. For long loans, the interest line is the whole story and the rate is the lever; for short loans, the fee lines dominate and the fees are the lever.