Formula
Secured monthly payment = Loan amount × r ÷ (1 − (1 + r)^−n), with r = Secured rate ÷ 12 and n = Secured term (months); Secured total cost = Payment × n + Appraisal, UCC filing, title and legal − Loan amount
Unsecured monthly payment = same formula at the Unsecured rate and term; Unsecured total cost = Payment × n + Loan amount × Unsecured origination fee ÷ 100 − Loan amount
Cost difference = Unsecured total cost − Secured total cost
Secured APR incl. costs = 12 × the monthly rate that discounts the secured payments to (Loan amount − secured costs); Unsecured APR incl. fee = 12 × the monthly rate that discounts the unsecured payments to Loan amount × (1 − fee)
Collateral at risk per dollar borrowed = Collateral value pledged ÷ Loan amount
Worked examples
Example 1: $150,000 secured at 8.5 percent over 60 months versus unsecured at 16 percent over 36
Use the defaults: Loan amount $150,000, Secured rate 8.5 percent, Secured term 60 months, Appraisal, UCC filing, title and legal $2,500, Collateral value pledged $220,000, Unsecured rate 16 percent, Unsecured term 36 months, Unsecured origination fee 3 percent. Secured: r = 0.085 ÷ 12 = 0.0070833; Payment = $150,000 × 0.0070833 ÷ (1 − 1.0070833^−60) = $3,077.48; payments total $184,649; total cost = $184,649 + $2,500 − $150,000 = $37,149. Unsecured: r = 0.16 ÷ 12 = 0.013333; Payment = $150,000 × 0.013333 ÷ (1 − 1.013333^−36) = $5,273.55; payments total $189,848; fee = $4,500; total cost = $189,848 + $4,500 − $150,000 = $44,348. Cost difference = $44,348 − $37,149 = $7,199. Secured APR including costs: the borrower effectively receives $147,500 and pays $3,077.48 for 60 months, an APR of 9.22 percent. Unsecured APR including fee: receives $145,500, pays $5,273.55 for 36 months, 18.18 percent. Collateral at risk = $220,000 ÷ $150,000 = $1.47 per dollar. The unsecured loan costs $7,199 more and $2,196 more per month, but is repaid two years sooner and pledges nothing beyond a guarantee.
Example 2: $75,000 over shorter terms where the gap narrows
Enter Loan amount $75,000, Secured rate 9 percent, Secured term 48 months, costs $1,500, Collateral $90,000, Unsecured rate 19 percent, Unsecured term 24 months, fee 4 percent. Secured: r = 0.0075; Payment = $75,000 × 0.0075 ÷ (1 − 1.0075^−48) = $1,866.38; payments total $89,586; total cost = $89,586 + $1,500 − $75,000 = $16,086. Unsecured: r = 0.015833; Payment = $75,000 × 0.015833 ÷ (1 − 1.015833^−24) = $3,780.65; payments total $90,736; fee = $3,000; total cost = $90,736 + $3,000 − $75,000 = $18,736. Cost difference = about $2,649 (the tool carries unrounded cents). APRs: secured 10.06 percent on $73,500 received; unsecured 23.27 percent on $72,000 received. Collateral at risk = $90,000 ÷ $75,000 = $1.20 per dollar. The unsecured rate is more than double, but the two-year term means the interest has less time to accumulate, so the dollar gap is only $2,649. The real difference is the payment: $3,781 a month against $1,866, which is a cash-flow question, not a cost question.
Example 3: $400,000 over long terms where the gap is large
Enter Loan amount $400,000, Secured rate 7.5 percent, Secured term 84 months, costs $6,000, Collateral $650,000, Unsecured rate 14 percent, Unsecured term 60 months, fee 2 percent. Secured: r = 0.00625; Payment = $400,000 × 0.00625 ÷ (1 − 1.00625^−84) = $6,135.31; payments total $515,366; total cost = $515,366 + $6,000 − $400,000 = $121,366. Unsecured: r = 0.011667; Payment = $400,000 × 0.011667 ÷ (1 − 1.011667^−60) = $9,307.30; payments total $558,438; fee = $8,000; total cost = $558,438 + $8,000 − $400,000 = $166,438. Cost difference = $45,072. APRs: secured 7.97 percent on $394,000 received; unsecured 14.91 percent on $392,000 received. Collateral at risk = $650,000 ÷ $400,000 = $1.63 per dollar. On a loan this size the lien is worth $45,000 in cost and $3,172 a month in payment, and the secured loan's closing costs are a rounding error against that. The question is whether $650,000 of property should secure a $400,000 obligation, which is an over-collateralization of 63 percent.