 |
| 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:
- Personnel and non-personnel costs incurred in the planning and development phase of the QEI
- Personnel and non-personnel costs incurred to support the on-going operation of the QEI
- Paid claims for the intervention group at baseline (pre-intervention) and post-intervention, expressed on a per-member, per-month basis
- Number of member months per year for the intervention group
- 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:
Post a Comment