ROI Calculator

Purpose: The Return on Investment Calculator is used to evaluate future profitability on different investments.

To open the template, click on the QI Macros menu > Calculators > ROI Calculator:

Calculators Menu


To Complete the ROI Calculator:

  1. Enter data for Lifetime Value of the Customer.
  2. Enter Transaction Costs in cells A13:F21.
  3. Enter Rework Costs in cells A25:F25.
  4. Enter Lost Opportunity Costs per transaction in cell G31.
  5. Enter any Assumptions in cells I26 and I28.
  6. Adjust format and formulas as needed to reflect your situation.

    ROI Calculator Template

Create these charts and diagrams in just seconds using QI Macros for Excel...