Executive Summary Templates

							                                                                    <Company Name>
                                                                    IT (ROI) analysis
                                                                    <Date>


Data cell key
User data entry or item description
Formula cells: Totals are calculated and filled in automatically.


Investment Summary
Project name: <Project name>
Project Senior Executive Sponsor: <Senior Executive Project sponsor>
Date of request: <Date>
General benefits description: <Description of benefits>




IT ROI Statement
                                                                                                   YEAR
                        BENEFIT DRIVERS
                                                                           0                 1               2               3
Greater margin driven by higher production capacity                                       £500,000.00   £1,000,000.00   £1,250,000.00
Improved cycle time benefits:
  Reduced energy cost due to less running time                                               125,000         125,000         125,000
  Reduced labor cost due to less running time                                                500,000         500,000         500,000
Fewer accidents, resulting in less workers' compensation                                     100,000         100,000         100,000
Improved quality benefits:
  Fewer defects, resulting in less rework                                                    255,000         295,000         295,000
  Fewer customer returns, resulting in less reprocessing costs                                46,000          72,000          72,000
  Reduced time spent handling customer complaints                                             46,000          72,000          72,000
<Benefit driver>
<Benefit driver>
<Benefit driver>
<Benefit driver>
Total annual benefits                                                                   £1,572,000.00   £2,164,000.00   £2,414,000.00
Implementation filter              85%             90%             95%
Total benefits realized   £1,336,200.00   £1,947,600.00   £2,293,300.00
Costs                                         Year 0           Year 1          Year 2          Year 3
Total                                       £1,694,000.00     £136,500.00     £136,500.00     £136,500.00

Benefits                                      Year 0           Year 1          Year 2          Year 3
Annual benefit flow                        -£1,694,000.00    £1,199,700.00   £1,811,100.00   £2,156,800.00
Cumulative benefit flow                        (1,694,000)       (494,300)      1,316,800       3,473,600

Discounted benefit flow                       Year 0           Year 1          Year 2          Year 3
Discounted costs                            £1,694,000.00     £124,090.91     £112,809.92     £102,554.47
Discounted benefits                                     0       1,214,727       1,609,587       1,722,990
Total discounted benefit flow                  (1,694,000)      1,090,636       1,496,777       1,620,436
Total cumulative discounted benefit flow       (1,694,000)       (603,364)        893,413       2,513,849

Initial investment                            Year 0           Year 1          Year 2          Year 3
Initial investment                          £1,253,000.00            £0.00           £0.00           £0.00
Implementation costs                             395,000                0               0               0
Ongoing support costs                                   0        112,000         112,000         112,000
Training costs                                    46,000          24,500          24,500          24,500
Other costs                                             0               0               0               0
Total costs                                 £1,694,000.00     £136,500.00     £136,500.00     £136,500.00

ROI measures
Cost of capital                                 10%
Net present value                          £5,443,619.68
Return on investment                                            67%            146%            224%
Payback (in years)                             1.27