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:
To Complete the ROI Calculator:
- Enter data for Lifetime Value of the Customer.
- Enter Transaction Costs in cells A13:F21.
- Enter Rework Costs in cells A25:F25.
- Enter Lost Opportunity Costs per transaction in cell G31.
- Enter any Assumptions in cells I26 and I28.
Adjust format and formulas as needed to reflect your situation.