Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial PlanningCar Lease vs Buy Comparison

SpreadsheetFinancial PlanningFree

Car Lease vs Buy Comparison

Total cost of driving the same car three ways: lease, buy with a loan or pay cash, including depreciation and lost interest.

Shown with sample data

Colour

Car Lease vs Buy Comparison

Total cost of driving the same car three ways: lease, buy with a loan or pay cash, including depreciation and lost interest.

Lease: total cost
$22,486
Buy with loan: total cost
$26,035
Buy with cash: total cost
$25,415
Cheapest option
Lease
Loan monthly payment
$655.31
Total loan interest
$5,819
Over the full loan term
Total cost of driving by option
  • Lease$22,486
  • Buy with loan$26,035.16
  • Buy with cash$25,415

How to use it

  1. 1On Inputs, type the negotiated price, sales tax rate and how many years you want to compare.
  2. 2Enter the lease quote: monthly payment (with tax), cash due at signing, term, mileage allowance, excess-mile charge and fees.
  3. 3Enter the loan offer and the share of the price the car is likely to keep after the period (see the notes column).
  4. 4Read the Comparison sheet line by line, then Totals for the cheapest option and the cost per month.
  5. 5Change the number of years: buying usually wins the longer you keep the car.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Comparing a lease payment with a loan payment is misleading: one leaves you with a car and the other does not. This workbook compares the full cost of driving for the same period: up-front cash, monthly payments, fees, excess mileage, maintenance, any loan balance still owed, the interest your cash could have earned, minus what the car is worth at the end.

Who it’s for

  • Deciding between a lease offer and dealer finance
  • Testing how long you need to keep a car for buying to win
  • High-mileage drivers checking lease penalties

What’s included

  • Inputs sheet: The price, lease quote and loan offer.
  • Comparison sheet: Every cost of each option over the same period.
  • Totals sheet: Total and monthly cost of each option.

How to use it

  1. 1On Inputs, type the negotiated price, sales tax rate and how many years you want to compare.
  2. 2Enter the lease quote: monthly payment (with tax), cash due at signing, term, mileage allowance, excess-mile charge and fees.
  3. 3Enter the loan offer and the share of the price the car is likely to keep after the period (see the notes column).
  4. 4Read the Comparison sheet line by line, then Totals for the cheapest option and the cost per month.
  5. 5Change the number of years: buying usually wins the longer you keep the car.

Tips

  • Negotiate the price first, whether you lease or buy. Lease payments are calculated from the price, so a lower price lowers the lease too.
  • Be honest about mileage. At 25 cents a mile, 3,000 extra miles a year adds $2,250 over a three-year lease.
  • A long loan (72–84 months) lowers the payment but can leave you owing more than the car is worth for years.

Questions

Is it better to lease or buy a car?

Leasing usually costs less over two to three years and suits people who want a new car often and drive average miles. Buying usually wins if you keep the car five years or more, because you stop making payments while still owning a car with value.

What does the comparison include?

Up-front cash, monthly payments, fees, excess mileage, maintenance after warranty, loan balance owed at the end, interest your up-front cash could have earned, and the car’s value at the end (subtracted for the buy options).

How do I estimate the car’s value at the end?

Look up the residual value in the lease quote (often 50–60% after three years) or check used prices for the same model at that age. Typical figures: about 60% after 3 years, 45% after 5, 30% after 7.

What if I compare more years than the lease term?

The lease side assumes you lease again on similar terms, paying due-at-signing and fees for each lease.

Related searcheslease vs buy calculatorcar lease vs buyshould i lease or buy a carcar finance comparisontotal cost of ownership carleasing vs financing

Details

Format
Spreadsheet
Category
Financial Planning
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFinancial PlanningFree

Car Lease vs Buy Comparison

Total cost of driving the same car three ways: lease, buy with a loan or pay cash, including depreciation and lost interest.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Financial Planning
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More financial planning templates

View all
FIRE Early Retirement Planner3 sheets

FI number

$1,250,000

Savings rate

43%

Years to FI

15

ABC
1ResultValueWhat it means
2Annual savings40,000Take-home income minus spending
3Savings rate0.43The single biggest driver of how fast you reach FI
4FI number1,250,000Retirement spending ÷ safe withdrawal rate
5Progress to FI0.15Invested assets as a share of your FI number
Results
SpreadsheetFinancial Planning

FIRE Early Retirement Planner

Your FI number, savings rate, years to financial independence, Coast FI and a year-by-year path to retiring early.

10 min setupPreview
Retirement Income and Withdrawal Planner2 sheets

Money lasts to

Age 93

First-year withdrawal rate

7%

Balance at the last age

$0

Portfolio balance by age
SpreadsheetFinancial Planning

Retirement Income and Withdrawal Planner

A year-by-year drawdown plan: spending with inflation, Social Security and pension, tax on withdrawals, growth and whether the money lasts.

10 min setupPreview
College Financial Aid Comparison3 sheets

Lowest 4-year net price

$46,650

Highest 4-year net price

$229,199

Difference

$182,549

ABCD
1CollegeNet price, year 14-year net price4-year borrowing
2State University (in-state)$21,300$92,052$22,000
3Lakeside College (private)$32,200$148,073$54,000
4Bayview University (merit scholarship)$30,200$137,609$22,000
5Northern Tech Institute$24,800$107,530$38,000
Compare
SpreadsheetFinancial Planning

College Financial Aid Comparison

Compare aid offers on what college will really cost: cost of attendance minus grants, loans kept separate, four-year totals and the payment after graduation.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ