Exhibit 7: Hard ROI Template Instructions: Enter data into the blank cells to calculate an ROI. Site Name: Finance Support Name & Phone: Date Prepared: Current Fiscal Year $K's USD: Q1 Q2 Q3 Q4 Total FY Operating Expense Impact Site Expense -$ -$ -$ -$ -$ Incremental Operating Expenses -$ -$ -$ -$ -$ subtract: Operating Expense Savings -$ -$ -$ -$ -$ Total Oper Expense Impact -$ -$ -$ -$ -$ Cash Flows Incremental Capital Investment -$ -$ -$ -$ -$ Other Working Capital Outflows or (Inflows) -$ -$ -$ -$ -$ Total Site Cash Flow Projection -$ -$ -$ -$ -$ Cumulative Cash Flow Projection -$ -$ -$ -$ Total Investment -$ -$ -$ -$ -$ Cost of Debt /Hurdle Rate 0.0% ROI Metrics NPV of Site Cash Flow $0 NPV of Investment $0 Return (CF /Investment) 0% Assumptions & Data Sources Please provide a brief description of overall assumptions and data sources Show how both financial benefits were quantified Most Likely CaseFY + 1 FY +2 FY +3 Total Curr FY FY + 1 FY +2 FY +3 -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 0.0% $0 $0 0% Most Likely Case Downside CaseTotal Curr FY FY + 1 FY +2 FY +3 Total -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 0.0% 0.0% $0 $0 $0 $0 0% 0% Upside CaseExhibit 8: Reverse ROI Template Instructions: Complete the blue cells, enter an incremental percentage that totals 100% in the green, yellow, and blue cells. Site Name: Finance Support Name & Phone: Date Prepared: NPV desired at end of Current Fiscal Year $100,000 Enter the NPV you want to achieve at year end Cost of Debt /Hurdle Rate 4.00% Enter the hurdle rate Total Operating Expense Impact (%) 0.00% Site Expense (as % of total impact) 0.00% These cells Incremental Operating Expense (as % of total impact) 0.00% must total Operational Benefits (as % of total impact) 0.00% 100% Total Project Cash Flow Projection (%) 0.00% Incremental Capital Investment (as % of total cash flow) 0.00% These cells Other Capital Outflows (as % of total cash flow) 0.00% must total 100% Exhibit 2: Reverse ROI Template Example (cont'd) Curr FY Operating Expense ImpactSite Expense -$ Incremental Operating Expenses -$ subtract: Operational Benefits -$ Total Operational Ben Impact -$ Cash Flows Incremental Capital Investment -$ Other Working Capital Outflows or (Inflows) ** -$ Total Site Cash Flow Projection -$ Total Investment -$ Assumptions & Data Sources Please provide a brief description of overall assumptions and data sources Show how both financial benefits were quantifiedExhibit 9: Hard ROI Template Example Instructions: Enter data into the blank cells to calculate an ROI. Site Name: Finance Support Name & Phone: Date Prepared: Current Fiscal Year $K's USD: Q1 Q2 Q3 Q4 Total FY FY + 1 FY +2 FY +3 Total Operating Expense Impact Site Expense 25,000 $ 25,000 $ 25,000 $ 25,000 $ 100,000 $ -$ -$ -$ 100,000 $ Incremental Operating Expenses 112,000 $ 112,000 $ 112,000 $ 112,000 $ 448,000 $ -$ -$ -$ 448,000 $ subtract: Operating Expense Savings 56,000 $ 56,000 $ 56,000 $ 56,000 $ 224,000 $ -$ -$ -$ 224,000 $ Total Oper Expense Impact 81,000 $ 81,000 $ 81,000 $ 81,000 $ 324,000 $ -$ -$ -$ 324,000 $ Cash Flows Incremental Capital Investment 45,000 $ 45,000 $ 45,000 $ 45,000 $ 180,000 $ -$ -$ -$ 180,000 $ Other Working Capital Outflows or (Inflows) 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ -$ -$ -$ 30,000 $ Total Site Cash Flow Projection 75,000 $ 75,000 $ 75,000 $ 75,000 $ 210,000 $ -$ -$ -$ 210,000 $ Cumulative Cash Flow Projection 75,000 $ 150,000 $ 225,000 $ 300,000 $ -$ -$ -$ Total Investment 212,000 $ 212,000 $ 212,000 $ 212,000 $ 758,000 $ -$ -$ -$ 758,000 $ Cost of Debt /Hurdle Rate 4.0% 4.0% ROI Metrics NPV of Site Cash Flow $201,923 $201,923 NPV of Investment $728,846 $728,846 Return (CF /Investment) 28% 28% Assumptions & Data Sources Please provide a brief description of overall assumptions and data sources Show how both financial benefits were quantified Most Likely Case Curr FY FY + 1 FY +2 FY +3 Total Curr FY FY + 1 FY +2 FY +3 Total -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 4.0% 4.0% $0 $0 $0 $0 0% 0% Downside Case Upside CaseExhibit 10: Reverse ROI Template Example Instructions: Complete the blue cells, enter an incremental percentage that totals 100% in the green, yellow, and blue Site Name: Finance Support Name & Phone: Date Prepared: NPV desired at end of Current Fiscal Year $129,000 Enter the NPV you want to achieve at year end Cost of Debt /Hurdle Rate 4.00% Enter the hurdle rate Total Operating Expense Impact (%) 70.00% Site Expense (as % of total impact) 50.00% These cells Incremental Operating Expense (as % of total impact) 30.00% must total Operational Benefits (as % of total impact) 20.00% 100% Total Site Cash Flow Projection (%) 30.00% Incremental Capital Investment (as % of total cash flow) 80.00% These cells Other Capital Outflows (as % of total cash flow) 20.00% must total 100% Exhibit 4: Reverse ROI Template Example (cont'd) Curr FY Operating Expense Impact Site Expense 45,150.00 $ Incremental Operating Expenses 27,090.00 $ subtract: Operational Benefits 18,060.00 $ Total Operational Ben Impact 90,300.00 $ Cash Flows Incremental Capital Investment 30,960.00 $ Other Working Capital Outflows or (Inflows) ** 7,740.00 $ Total Project Cash Flow Projection 38,700.00 $ Total Investment 110,940.00 $ Assumptions & Data Sources Please provide a brief description of overall assumptions and data sources Show how both financial benefits were quantifiedthe green, yellow, and blue cells. want to achieve at year end