BLANK ROI SPREAD SHEET

 The blank ROI Spread Sheet Calculator can be download here.

 

CUSTOMER PROJECT RETURN ON INVESTMENT CALCULATOR         .
         
<Company Name>        
Capital budgeting—return-on-investment (ROI) analysis      
<Date>        
         
Data cell key        
User data entry or item description        
         
Formula cells: Totals are calculated and filled in automatically.      
Formula cells: Cells are filled in and calculated automatically but feel free to modify    
Formula cells: Totals are calculated automatically.  Do Not Change.      
         
Investment overview        
Project name:    <Project name>        
Project sponsor: <Project sponsor>        
Date of request: <Date>        
General description of benefits: <Description of benefits>    
   
   
   
         
Analysis Inputs        
Equipment Unit Replacement Cost ($) <Primary Driver>      
Equipment Units Not Requiring Replacement (per year) <Primary Driver>      
Cost of Capital <Primary Driver>      
Cost of Replacement Board ($) <Primary Driver>      
Initial Investment (Number of Replacement Boards) <Primary Driver>      
Initial Integration Manpower (Troubleshoot/Debug) <Secondary>      
Initial Integration Material Costs (Troubleshoot/Debug) <Secondary>      
Initial Investment Additional Charge to Meet Minimum [AUTO]      
Total Initial Investment Required ($10K Minimum) [AUTO]      
Annual Cost of Replaced Equipment [AUTO]      
         
ROI measures: Circuit Board Replacement Year 0 Year 1 Year 2 Year 3
Cost of capital [AUTO]      
Net present value (of Year 0 Investment) [AUTO]        
Return on investment   [AUTO] [AUTO] [AUTO]
Payback (in years) [AUTO]      
ROI measures: Equipment Replacement Year 0 Year 1 Year 2 Year 3
  [AUTO]      
Net present value (of Year 0 Investment) [AUTO]        
Return on investment    [AUTO] [AUTO] [AUTO]
Payback (in years) [AUTO]      
        PAGE 1 OF 3
         
Cash flow and ROI statement: Circuit Board Replacement      
BENEFIT DRIVERS  YEAR 
0 1 2 3
Value of  Money Not Spent Replacing Equipment Per Year   [AUTO] [AUTO] [AUTO]
Eliminated Maintenance Personel Cost   <Secondary> <Secondary> <Secondary>
Eliminated Maintenance Supplies/Services Cost   <Secondary> <Secondary> <Secondary>
<Benefit driver>  Money Not Spent Not Replacing Equipment   <Secondary> <Secondary> <Secondary>
<Benefit driver>   <Secondary> <Secondary> <Secondary>
<Benefit driver>   <Secondary> <Secondary> <Secondary>
Total annual benefits   [AUTO] [AUTO] [AUTO]
Implementation filter 85% 90% 95%
Total benefits realized [AUTO] [AUTO] [AUTO]
         
Costs: Circuit Board Replacement Year 0 Year 1 Year 2 Year 3
Total [AUTO] [AUTO] [AUTO] [AUTO]
         
Benefits: Circuit Board Replacement Year 0 Year 1 Year 2 Year 3
Annual benefit flow [AUTO] [AUTO] [AUTO] [AUTO]
Cumulative benefit flow [AUTO] [AUTO] [AUTO] [AUTO]
         
Discounted benefit flow: Circuit Board Replacement Year 0 Year 1 Year 2 Year 3
Discounted costs [AUTO] [AUTO] [AUTO] [AUTO]
Discounted benefits [AUTO] [AUTO] [AUTO] [AUTO]
Total discounted benefit flow [AUTO] [AUTO] [AUTO] [AUTO]
Total cumulative discounted benefit flow [AUTO] [AUTO] [AUTO] [AUTO]
         
Initial investment: Circuit Board Replacement Year 0 Year 1 Year 2 Year 3
Initial investment [AUTO] [AUTO] [AUTO] [AUTO]
<Cost Driver> <Secondary> <Secondary> <Secondary> <Secondary>
<Cost Driver> <Secondary> <Secondary> <Secondary> <Secondary>
<Cost Driver> <Secondary> <Secondary> <Secondary> <Secondary>
Total costs [AUTO] [AUTO] [AUTO] [AUTO]
         
ROI measures: Circuit Board Replacement Year 0 Year 1 Year 2 Year 3
Cost of capital [AUTO]      
Net present value (of Year 0 Investment) [AUTO]        
Return on investment   [AUTO] [AUTO] [AUTO]
Payback (in years) [AUTO]      
        PAGE 2 OF3
         
Cash flow and ROI statement: Equipment Replacement      
BENEFIT DRIVERS  YEAR 
0 1 2 3
<Benefit driver>   <Secondary> <Secondary> <Secondary>
<Benefit driver>   <Secondary> <Secondary> <Secondary>
<Benefit driver>   <Secondary> <Secondary> <Secondary>
<Benefit driver>   <Secondary> <Secondary> <Secondary>
<Benefit driver>   <Secondary> <Secondary> <Secondary>
<Benefit driver>   <Secondary> <Secondary> <Secondary>
Total annual benefits   [AUTO] [AUTO] [AUTO]
Implementation filter 85% 90% 95%
Total benefits realized [AUTO] [AUTO] [AUTO]
         
Costs: Equipment Replacement Year 0 Year 1 Year 2 Year 3
Total [AUTO] [AUTO] [AUTO] [AUTO]
         
Benefits: Equipment Replacement Year 0 Year 1 Year 2 Year 3
Annual benefit flow [AUTO] [AUTO] [AUTO] [AUTO]
Cumulative benefit flow [AUTO] [AUTO] [AUTO] [AUTO]
         
Discounted benefit flow: Equipment Replacement Year 0 Year 1 Year 2 Year 3
Discounted costs [AUTO] [AUTO] [AUTO] [AUTO]
Discounted benefits [AUTO] [AUTO] [AUTO] [AUTO]
Total discounted benefit flow [AUTO] [AUTO] [AUTO] [AUTO]
Total cumulative discounted benefit flow [AUTO] [AUTO] [AUTO] [AUTO]
         
Initial investment: Equipment Replacement Year 0 Year 1 Year 2 Year 3
Initial investment [AUTO] [AUTO] [AUTO] [AUTO]
<Cost Driver> <Secondary> <Secondary> <Secondary> <Secondary>
<Cost Driver> <Secondary> <Secondary> <Secondary> <Secondary>
<Cost Driver> <Secondary> <Secondary> <Secondary> <Secondary>
Total costs [AUTO] [AUTO] [AUTO] [AUTO]
         
ROI measures: Equipment Replacement Year 0 Year 1 Year 2 Year 3
Cost of capital [AUTO]      
Net present value (of Year 0 Investment) [AUTO]        
Return on investment   [AUTO] [AUTO] [AUTO]
Payback (in years) [AUTO]