
Compare buying with a loan and leasing on the same footing: everything you pay over the lease period, minus what the car is worth to you at the end.
Dealers sell cars on the monthly payment, and a lease payment is almost always lower than a loan payment. That comparison is misleading: at the end of a lease you own nothing, while a buyer owns a car that is still worth money and has paid down part of the loan.
This workbook compares the two over the same period, the length of the lease. For buying it counts the down payment, the loan payments, the loan balance still owed at the end, maintenance, minus the resale value you expect; for leasing it counts the amount due at signing, the payments with tax, the fees and any extra-mileage charge.
It also calculates the resale value at which the two options cost the same, so you can see how much the decision depends on that one estimate.
1) On Inputs, enter the purchase price, sales tax, down payment, loan rate and term from the purchase quote. 2) Enter your estimate of the car's resale value at the end of the lease period (check used prices for the same model at that age and mileage). 3) Enter the lease offer: amount due at signing, monthly payment, months, tax on payments, fees, mileage allowance and your expected miles. 4) Read Comparison: total cost of each option over the period, the difference, and the break-even resale value.
Price: $12, one-time. Download: car_buy_vs_lease_calculator.xlsx (Inputs, Comparison) and this guide. Works in Excel 2016 or later, Excel for Mac and Excel on the web; opens in Google Sheets and LibreOffice.
New product, listed 2026-10-24: no sales or reviews yet. Example figures in the workbook are illustrative.
This workbook is a comparison tool, not financial or tax advice. Results depend on the quotes and the resale value you enter; read the lease contract and the loan disclosure before signing, and check business-use tax treatment with an accountant.