| Humana | | | | | | |
| | | | | | |
| | | | | | |
| Discount Rate: | 7.50% | | | | | |
| Net Present Value (NPV): | $14,396,622 | | | | | |
| Annualized ROI: | 114% | | | | | |
| Payback period: | 3.51 | Years | | | | |
| | | | | | |
| | | | | | |
| BENEFITS | Pre-start | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Operational Excellence | $- | $2,510,417 | $5,020,833 | $5,020,833 | $5,020,833 | $5,020,833 |
| Care Optimization | $- | $26,244,900 | $52,489,800 | $52,489,800 | $52,489,800 | $52,489,800 |
| Member Retention Growth | $- | $4,338,000 | $8,676,000 | $8,676,000 | $8,676,000 | $8,676,000 |
| Technology infrastructure debt avoidance | $- | $5,250,000 | $10,500,000 | $10,500,000 | $10,500,000 | $10,500,000 |
| Total per period | $- | $38,343,317 | $76,686,633 | $76,686,633 | $76,686,633 | $76,686,633 |
| | | | | | |
| | | | | | |
| | | | | | |
| COSTS – CAPITALIZED ASSETS | Pre-start | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Sofware | $- | $- | $- | $- | $- | $- |
| Hardware | $- | $- | $- | $- | $- | $- |
| Other | $- | $- | $- | $- | $- | $- |
| Total per period | $- | $- | $- | $- | $- | $- |
| | | | | | |
| | | | | | |
| | | | | | |
| COSTS – DEPRECIATION | Pre-start | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Sofware | $- | $- | $- | $- | $- | $- |
| Hardware | $- | $- | $- | $- | $- | $- |
| Other | $- | $- | $- | $- | $- | $- |
| Total per period | $- | $- | $- | $- | $- | $- |
| | | | | | |
| | | | | | |
| | | | | | |
| COSTS – EXPENSED | Pre-start | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Sofware Licenses – Care Coordination* | $238,950 | $238,950 | $238,950 | $238,950 | $238,950 | $238,950 |
| Field Service Lightening Scheduler | $33,000,000 | $33,000,000 | $33,000,000 | $33,000,000 | $33,000,000 | $33,000,000 |
| Humana branded app | $15,000,000 | $15,000,000 | $15,000,000 | $15,000,000 | $15,000,000 | $15,000,000 |
| Mulesoft | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 |
| Einstein Analytics for healthcare (Tableau) | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 | $90,000 |
| Hardware | $- | $- | $- | $- | $- | $- |
| Consulting | $3,000,000 | $3,000,000 | $1,500,000 | $1,500,000 | $- | $- |
| Personnel | $50,000 | $100,000 | $200,000 | $200,000 | $200,000 | $200,000 |
| Training | $300,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 |
| Other (software add-on, etc.) | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 |
| Total per period | $52,278,950 | $52,058,950 | $50,658,950 | $50,658,950 | $49,158,950 | $49,158,950 |
| | | | | | |
| | | | | | |
| | | | | | |
| Financial Analysis | Pre-start | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| Net cash flow before taxes | $(52,278,950) | $(13,715,633) | $26,027,683 | $26,027,683 | $27,527,683 | $27,527,683 |
| Net cash flow after taxes | $(41,300,371) | $(10,835,350) | $20,561,870 | $20,561,870 | $21,746,870 | $21,746,870 |
| Cumulative Net Cash Flow | | $(52,135,721) | $(31,573,851) | $(11,011,981) | $10,734,889 | $32,481,759 |
| Positive Cash Flow? | | FALSE | FALSE | FALSE | TRUE | TRUE |
| Undiscounted Payback Period | 4 | First Year Positive | | | | |
| Partial Year Payback Period | 3.51 | Actual Number of Years | | | | |
| | | | | | |
| * MA VBC Members only | | | | | | |
| ** Platform flat rate deal | | | | | | |
