ROI Template

Document Sample

Shared by: ocak
Stats
views:
2570
posted:
1/28/2008
language:
English
pages:
9
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




Share This Document


Related docs
Other docs by ocak
Strategic Asset Plans[1]
Views: 2597  |  Downloads: 550
Risk Management Toolkit
Views: 904  |  Downloads: 176
Issue Template Document
Views: 452  |  Downloads: 47
Request for Tender template
Views: 4607  |  Downloads: 87
Meeting Agenda
Views: 451  |  Downloads: 27
Project Communication Matrix
Views: 2994  |  Downloads: 175
Municipal Wireless Solutions
Views: 235  |  Downloads: 19
RAM Template
Views: 4455  |  Downloads: 194
job description template notes
Views: 2052  |  Downloads: 85
by registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!