Return on Investment Template for Excel

Return on Investment Template for Excel

Return on Investment Template for Excel
Return on Investment Template for Excel

Download Free Return on Investment Template for Excel

Proposed Use:
The return on investment (ROI) template was designed to allow payer organizations to retrospectively analyze the ROI on quality enhancing interventions (QEIs).

Data Requirements:
Use of the template requires input of:
  1. Personnel and non-personnel costs incurred in the planning and development phase of the QEI 
  2. Personnel and non-personnel costs incurred to support the on-going operation of the QEI 
  3. Paid claims for the intervention group at baseline (pre-intervention) and post-intervention, expressed on a per-member, per-month basis 
  4. Number of member months per year for the intervention group 
  5. Number of months per year the QEI was operational

Optional Features:
The template allows for: 
  • Entry of paid claims data for a control or comparison group 
  • Discounting of cash flow estimates using the organizational opportunity cost of capital
Data Entry Instructions:
  • Green shaded cells are input cells which allow direct data input by users 
  • Yellow shaded cells are intermediate calculations 
  • Grey shaded cells are key outputs 
Download also:
Previous Post Next Post

Comments