Formula
Monthly payment = P × r ÷ (1 − (1 + r)^−n), where P is the loan amount, r is the annual interest rate ÷ 12 and n is the term in years × 12.
Total repayment = monthly payment × n. Total interest = total repayment − P.
Net proceeds after fee = P × (1 − origination fee). The fee is deducted from what you receive, not added to what you repay.
APR including fee is the annual rate at which the net proceeds, paid back by the same n monthly payments, come out exactly even. It is found by solving for the periodic rate (an internal rate of return) and multiplying by 12, the way Regulation Z defines APR for consumer loans.
Worked examples
Example 1: $100,000 at 11 percent for 5 years with a 2 percent fee (the tool's defaults)
Loan amount P = $100,000. Annual interest rate 11 percent, so r = 0.11 ÷ 12 = 0.0091667. Term 5 years, so n = 60 payments. Step 1: (1 + r)^−60 = 1.0091667^−60 = 0.5784. Step 2: 1 − 0.5784 = 0.4216. Step 3: P × r = $100,000 × 0.0091667 = $916.67. Step 4: $916.67 ÷ 0.4216 = $2,174.24 per month. Total repayment = $2,174.24 × 60 = $130,455. Total interest = $130,455 − $100,000 = $30,455. Origination fee 2 percent: net proceeds = $100,000 × 0.98 = $98,000. The APR including the fee asks: what annual rate makes $98,000 today equal to 60 payments of $2,174.24? The answer is 11.88 percent, about 0.9 points above the 11 percent note rate. Enter these defaults in the tool and you should see $2,174.24, $30,455, $130,455, $98,000, 11.88 percent and 60 payments.
Example 2: a $40,000 two-year loan at 18 percent with a 3 percent fee
P = $40,000, r = 0.18 ÷ 12 = 0.015, n = 24. Step 1: 1.015^−24 = 0.6995. Step 2: 1 − 0.6995 = 0.3005. Step 3: P × r = $40,000 × 0.015 = $600. Step 4: $600 ÷ 0.3005 = $1,996.96 per month. Total repayment = $1,996.96 × 24 = $47,927, so total interest is $7,927. Net proceeds after a 3 percent fee = $40,000 × 0.97 = $38,800. Solving for the rate that equates $38,800 received now with 24 payments of $1,996.96 gives an APR of 21.17 percent. Notice the gap between note rate and APR is wider here (3.2 points) than in Example 1 (0.9 points), even though the fee is only one point higher. A fee is spread over fewer months on a short loan, so each month carries more of it. Short-term loans with up-front fees are where the APR line earns its place.
Example 3: $250,000 at 8.5 percent over 10 years with a 1 percent fee
P = $250,000, r = 0.085 ÷ 12 = 0.0070833, n = 120. Step 1: 1.0070833^−120 = 0.4287. Step 2: 1 − 0.4287 = 0.5713. Step 3: P × r = $1,770.83. Step 4: $1,770.83 ÷ 0.5713 = $3,099.64 per month. Total repayment = $3,099.64 × 120 = $371,957; total interest = $121,957. Net proceeds = $250,000 × 0.99 = $247,500. APR including the fee = 8.73 percent. Two things stand out. First, interest over ten years is almost half the principal even at a single-digit rate, because the balance stays high for years. Second, the 1 percent fee moves the APR by only about a quarter point because it is spread over 120 payments. Longer terms make fees matter less and total interest matter more, which is exactly the trade-off the next sections walk through.