Formula
Loan: Financed amount = Equipment price × (1 − Loan down payment ÷ 100); Loan monthly payment = Financed × r ÷ (1 − (1 + r)^−n) with r = Loan rate ÷ 12 and n = Loan term (months); Loan total = Down payment + Payment × n; Loan interest = Payment × n − Financed; Loan total cost net of resale = Loan total − Expected resale value
Lease: Lease total cost (incl. buyout) = Monthly lease payment × Lease term + Buyout at end of lease; if the buyout is $1 or less the resale value is subtracted (you own the asset), otherwise it is not
Illustrative tax: Loan tax benefit = (Equipment price + Loan interest) × Marginal tax rate (depreciation plus interest deduction); Lease tax benefit = Lease payment × Lease term × Marginal tax rate (payments deducted as rent); after-tax net cost = net cost − tax benefit
Cheaper after tax and resale = Loan if Loan after-tax net cost ≤ Lease after-tax net cost, otherwise Lease
Implicit lease rate = the annualized monthly IRR that equates (Equipment price − Buyout discounted at 0.5 percent a month over the lease term) with the stream of lease payments
Worked examples
Example 1: $120,000 machine, 9 percent loan with 10 percent down versus a $2,350 lease with a $12,000 buyout
Use the defaults: Equipment price $120,000, Loan rate 9 percent, Loan term 60 months, Loan down payment 10 percent, Monthly lease payment $2,350, Lease term 60 months, Buyout $12,000, Expected resale $30,000, Marginal tax rate 28 percent. Loan: Financed = $120,000 × 0.90 = $108,000. r = 0.09 ÷ 12 = 0.0075. Payment = $108,000 × 0.0075 ÷ (1 − 1.0075^−60) = $2,241.90. Payments total $2,241.90 × 60 = $134,514; interest = $134,514 − $108,000 = $26,514. Loan total = $12,000 down + $134,514 = $146,514; net of resale = $146,514 − $30,000 = $116,514. Loan tax benefit = ($120,000 + $26,514) × 0.28 = $41,024; after-tax net = $75,490. Lease: $2,350 × 60 = $141,000 + $12,000 buyout = $153,000; the buyout is above $1 so no resale credit; net = $153,000. Lease tax benefit = $141,000 × 0.28 = $39,480; after-tax net = $113,520. Loan is cheaper by about $38,000 after tax. Implicit lease rate: discounting the $12,000 buyout at 0.5 percent a month for 60 months gives $8,896, so the lease finances $111,104 for $2,350 a month, an implied rate of about 9.8 percent.
Example 2: $80,000 vehicle, zero-down loan versus a $1-buyout lease
Enter Equipment price $80,000, Loan rate 8.5 percent, Loan term 48 months, Loan down payment 0, Monthly lease payment $1,950, Lease term 48 months, Buyout $1, Expected resale $25,000, Marginal tax rate 24 percent. Loan: Financed = $80,000; r = 0.0070833; Payment = $80,000 × 0.0070833 ÷ (1 − 1.0070833^−48) = $1,971.86; payments total $94,649; interest = $14,649; Loan total = $94,649; net of resale = $69,649. Loan tax benefit = ($80,000 + $14,649) × 0.24 = $22,716; after-tax net = $46,934. Lease: $1,950 × 48 = $93,600 + $1 = $93,601; because the buyout is $1 or less the tool treats the lessee as the owner at the end and subtracts resale: net = $93,601 − $25,000 = $68,601. Lease tax benefit = $93,600 × 0.24 = $22,464; after-tax net = $46,137. Lease is cheaper, by about $800 after tax and about $1,050 before. The implicit lease rate is 7.9 percent, below the 8.5 percent loan, which is the whole reason it wins: a $1-buyout lease is a loan by another name, and here it is the cheaper loan.
Example 3: $250,000 production line, 20 percent down loan versus a lease with a $50,000 buyout
Enter Equipment price $250,000, Loan rate 7.5 percent, Loan term 72 months, Loan down payment 20 percent, Monthly lease payment $3,900, Lease term 72 months, Buyout $50,000, Expected resale $70,000, Marginal tax rate 32 percent. Loan: Down = $50,000; Financed = $200,000; r = 0.00625; Payment = $200,000 × 0.00625 ÷ (1 − 1.00625^−72) = $3,458.02; payments total $248,977; interest = $48,977; Loan total = $298,977; net of resale = $228,978 (the tool carries unrounded cents). Loan tax benefit = ($250,000 + $48,977) × 0.32 = $95,673; after-tax net = $133,305. Lease: $3,900 × 72 = $280,800 + $50,000 = $330,800, no resale credit; tax benefit = $280,800 × 0.32 = $89,856; after-tax net = $240,944. Loan is cheaper by about $108,000 after tax. Implicit lease rate 9.2 percent against a 7.5 percent loan. The lease loses twice: it carries a higher implied rate and, by not conveying ownership, it forfeits $70,000 of resale value while still charging $50,000 to keep the asset.