-
Excel workbook preview
Negotiation, Cost Analysis and Savings
Total Cost of Ownership (TCO) Calculator
3 downloads per free account, no card needed.
Who this is for
A buyer or evaluation panel asked by finance to prove that the cheapest quote is not the most expensive option over the asset's life.
What is inside
- Three options compared on 11 sample cost elements, with 8 blank lines
- Cost types: one-off, annual, end of life and residual value credit
- Year-by-year cash flows for up to 10 years with annual cost escalation
- Nominal TCO, present value TCO with NPV(), TCO per year and rank
- Purchase price shown as a share of the total cost of ownership
- Bar chart of nominal and present value TCO by option
How to use it: Name your three options, enter every cost element with its type, and set the life, discount rate and escalation agreed with finance.
Files & formats
- XLSXtotal-cost-of-ownership-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.


