How to Compare Leasing and Buying a Car With a Worksheet

What a lease versus buy worksheet does

A lease versus buy worksheet is a side-by-side comparison tool that shows you the actual costs of leasing a car against the actual costs of buying one over the same time period. It takes the numbers you plug in — your down payment, monthly payment, insurance, fuel, maintenance, mileage limits, and end-of-lease fees — and lines them up so you can see which option costs less money and which fits your driving pattern better.

The worksheet does not make the decision for you. It makes the math visible. Most people guess wrong about which option is cheaper because they forget to count insurance, maintenance, or the cost of going over mileage limits. A worksheet forces you to count everything.

Key Takeaways

• A worksheet compares total costs over the same time period — usually three years for a lease or five to seven years for a purchase — so you see the real difference, not just monthly payment.
• You need actual numbers from dealers or lenders before you fill one out: the lease payment, the purchase price, insurance quotes, and your expected maintenance costs.
• The worksheet should include mileage overage fees, disposition fees at lease end, and the car's resale value if you buy, because these hidden costs often flip the decision.
• Worksheets work best when you compare the same car leased versus bought, so the only variable is the financing method, not the vehicle itself.

What numbers you need to gather first

Before you open a worksheet, collect the actual figures from dealers, lenders, and insurance companies. Guessing defeats the purpose. For a lease, you need the monthly payment, the money due at signing (down payment, first month, registration, and acquisition fee), the mileage allowance per year, the cost per mile over the limit, and the disposition fee at the end. For a purchase, you need the purchase price or loan amount, your down payment, the monthly loan payment, the loan term in months, and the interest rate.

You also need insurance quotes for both scenarios — leased and owned cars often have different insurance requirements. Call your insurance company and ask for quotes on the exact car you are considering, both as a lease and as a purchase. Then gather fuel costs (use the EPA estimate for the car's MPG and your local gas price) and maintenance costs. For a lease, maintenance is usually covered, so this number is often zero. For a purchase, research what owners of that car typically spend on repairs and maintenance per year, or ask the dealer for an estimate.

The resale value matters only if you buy. Look up the car's expected value at the end of your ownership period using resources like Kelley Blue Book or NADA Guides. This is the amount you will recover when you sell or trade it in.

How to set up a basic comparison

Organize your worksheet in columns: one for the lease scenario, one for the purchase scenario. Create rows for each cost category: down payment, monthly payment (multiply by the number of months), insurance (annual cost times the number of years), fuel, maintenance, registration and fees, mileage overage charges, and disposition or end-of-lease fees. Add each column to get a total cost for leasing and a total cost for buying.

For the purchase column, subtract the resale value from the total. This gives you the net cost — what you actually paid out of pocket after selling the car. Compare the net cost of buying to the total cost of leasing. The lower number is the cheaper option over that time period.

Use the same time period for both. If you are comparing a three-year lease, calculate the purchase costs for three years of ownership, not five or seven. This keeps the comparison honest.

Why mileage limits and overage fees matter

Lease agreements include a mileage allowance, usually 10,000 to 15,000 miles per year. If you drive more, you pay an overage fee — typically 15 to 30 cents per mile over the limit. A person who drives 18,000 miles per year on a 12,000-mile lease will owe 6,000 miles times the overage rate, which can add $900 to $1,800 to the cost of leasing.

Many people discover this cost only at lease end, when the bill arrives. A worksheet forces you to calculate it upfront. Track your actual annual mileage for the past year or two. If you do not know, estimate conservatively — most people underestimate. If your mileage is consistently above the lease allowance, buying is often cheaper, even if the monthly payment is higher.

Hidden costs that change the outcome

Disposition fees are what you pay to return a leased car at the end of the lease. This is typically $300 to $500, though it varies by manufacturer and lease agreement. Some leases waive this fee if you buy the car at lease end. Check your lease paperwork or ask the dealer.

Acquisition fees are what dealers charge to set up a lease, usually $500 to $1,000. These are due at signing and are separate from your down payment. Registration and title fees vary by state but can range from $100 to $300 per year. If you buy, you pay these once; if you lease, you pay them at the start of each lease.

Wear-and-tear charges are fees the leasing company can charge if the car has damage beyond normal use when you return it. These are unpredictable but can range from a few hundred dollars to several thousand. Some people budget $500 to $1,000 as a rough estimate. If you buy, you do not face this charge, but you do pay for repairs out of your own pocket.

When to use a worksheet and when it will not help

A worksheet works best when you are deciding between leasing and buying the same car, and you have concrete numbers from dealers or lenders. It also works if you are trying to decide whether to lease for three years or buy and keep the car for five years — the worksheet will show you the cost difference clearly.

A worksheet will not help if you do not have real numbers yet. If you are just browsing cars online and have not talked to a dealer, wait until you have actual quotes. It also will not help if you are comparing a luxury car lease to a used economy car purchase — the worksheet will show you the cost difference, but it is not really comparing the same thing.

A worksheet also cannot measure intangibles: whether you like the freedom of a new car every few years, whether you hate the stress of selling a used car, or whether you drive in a way that would rack up mileage overage fees. Those are personal preferences that belong in your decision, but they are not numbers on a worksheet.

Where to find a worksheet template

Many car-buying websites offer free lease versus buy calculators or downloadable worksheets. Edmunds, Kelley Blue Book, and Consumer Reports all have versions. Your bank or credit union may also provide a worksheet if you are financing a purchase through them. Some car manufacturers include a comparison tool on their websites.

You can also build your own in a spreadsheet using the structure described above. The advantage of making your own is that you can customize it for your situation — add rows for registration renewal, include your state's specific taxes, or adjust for your actual insurance rates. A simple spreadsheet with clear labels and formulas is often easier to understand than a third-party tool.

Frequently Asked Questions

Should I include taxes in the worksheet?

Yes. Sales tax on a purchase varies by state, usually 5 to 10 percent of the car's price. Lease payments sometimes include tax and sometimes do not — check your lease quote. If your state taxes lease payments, add that to the monthly payment line. If you buy, add sales tax to the purchase price or loan amount.

What if I do not know my resale value?

Use Kelley Blue Book or NADA Guides to estimate the car's value at the end of your ownership period. Enter the car's make, model, year, and expected mileage. These tools give you a range; use the middle estimate. If you plan to trade it in rather than sell it privately, the trade-in value will be lower — ask the dealer for an estimate.

Do I need to include registration renewal in the worksheet?

If you buy, yes — registration renewal happens every year or every few years depending on your state. If you lease, the dealer usually handles registration, so it is often included in the lease payment or due at signing. Check your lease quote to see what is included.

What if the worksheet shows buying is cheaper but I still want to lease?

The worksheet shows cost, not preference. If leasing fits your lifestyle better — you like a new car every few years, you do not want to worry about repairs, or you drive predictably within mileage limits — that is a valid reason to lease even if buying is cheaper. The worksheet just makes sure you know what the choice costs you.

Can I use the same worksheet to compare two different cars?

You can, but it is less useful. If you are comparing a Honda Civic lease to a Toyota Corolla purchase, the worksheet will show you the cost difference, but you are also comparing different cars, different insurance costs, and different maintenance needs. It is clearer to run two worksheets: Civic lease versus Civic purchase, and Corolla lease versus Corolla purchase. Then you can decide between the two cars separately from the lease versus buy decision.