• Preview of Lease vs Buy CalculatorExcel workbook preview

Negotiation, Cost Analysis and Savings

Lease vs Buy Calculator

$17.99 Free XLSX
Excel workbook · 11 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

Who this is for

A buyer or fleet manager asked by finance whether to buy or lease vehicles or equipment before the budget is approved.

What is inside

  • Buy inputs: price, one-off costs, maintenance, resale and disposal
  • Lease inputs: monthly payment, in advance or arrears, maintenance included or not, fees
  • Year-by-year cash flows for terms up to 7 years
  • Total cash cost and present value for both options, per unit and in year 0
  • Break-even resale value at which the two options cost the same
  • Sensitivity at 5 discount rates and a present value chart

How to use it: Enter the common, buy and lease inputs from your quotes, use the discount rate finance gives you, and ask finance to add tax effects before approval.

Files & formats
  • XLSXlease-vs-buy-calculator.xlsx11 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.

Free downloads & full access

Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.

Bought with a different email? Open your account and enter your order number.

Licence

Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.