professional documents
home
Profile
Upload
docsters
Blogs
Upload
about me
contact me
user photo
submit clear
Excel Spreadsheet

ROI Template center doc

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
rate this doc
email this doc
embed this doc
add to folder
digg reddit stumble delicious
flag this doc
347
56
not rated
0
1/28/2008
English
search termpage on Googletimes searched
Preview

Template Project Scale[1]

ocak 1/28/2008 | 1811 | 1644 | 2 |
Preview

Strategic Asset Plans[1]

ocak 1/28/2008 | 1066 | 363 | 2 | business
Preview

Steering Committee Charter template[1]

ocak 1/28/2008 | 2254 | 421 | 3 | business
Preview

Status Report Management Process Flow example[1]

ocak 1/28/2008 | 2201 | 692 | 1 | business
Preview

Status Report example[1]

ocak 1/28/2008 | 2563 | 913 | 2 | business
Preview

Software Requirement Specifications Document Template[1]

ocak 1/28/2008 | 1826 | 326 | 1 | business
Preview

Scope Statement Development Instructions[1]

ocak 1/28/2008 | 740 | 41 | 0 | business
Preview

Schedule Of Excess Risks[1]

ocak 1/28/2008 | 421 | 22 | 0 | business
Preview

Sample Performance Based Requirement Template for use with Task Orders[1]

ocak 1/28/2008 | 1043 | 25 | 0 | business
Preview

Risk Value Assessment Tool

ocak 1/28/2008 | 687 | 85 | 1 | business
roi template12
sample roi template21
capital roi template11
financial statement npv,roi11
roi metrics templates11
pro forma roi templates11
 
review this doc