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