Fillable Printable Cost and Benefit Analysis Template
Fillable Printable Cost and Benefit Analysis Template
Cost and Benefit Analysis Template
Business Case Cost-Benet Template
Examples that are included in the table are not comprehensive. Add to / remove items from the table
as required.
Ministry:(insert ministry name here)
Initiative:(insert name of initiative here)
QUANTITATIVE COSTS
Non-Recurring Costs
Hardware
Servers
Peripherals/Data centre equipment
Desktop (incremental due to project)
Telecommunication equipment
Software (packaged or custom)
Purchase
Facilities
Computer room upgrades
Furniture and fixtures
Other
Project organizational/support costs
Planning (upon approval)
Procurement
Contract negotiations
Labour
Infrastructure
Development
Business Process owners (users)
Management
Other labour
Other
Transition costs (parallel systems)
Post implementation reviews
Total Non-Recurring Costs
00000
Recurring Costs
Year 1
($000s)
Year 2
($000s)
Year 3
($000s)
Year 4
($000s)
Year 5
($000s)
Training of employees (pre-
implementation)
Hardware/Software
Software maintenance and upgrades
Computer supplies
Desktops (incremental to the project)
Help Desk support
Ongoing Additional Labour
IT staff costs (incl. benefits)
User training
Other
Telecommunications
Office leases
Total Recurring Costs
00000
Total Costs
00000
QUANTITATIVE BENEFITS
Revenues
(Enter revenue here)
Total Revenues
00000
Cost Savings
Decreased cost of services provided
Productivity gains
Savings from structural changes
Decreased information publishing cost
Reduced staffing cost (incl. overtime)
Reduced staff turnover costs
Total Cost Savings
00000
Cost Avoidance
(Enter Cost Avoidance Here)
Total Cost Avoidance
00000
Year 1
($000s)
Year 2
($000s)
Year 3
($000s)
Year 4
($000s)
Year 5
($000s)
Savings from Business process
improvements
Savings from optimized information (or
flow)
Other Benefits
(Enter Other Benefits Here)
Total Other Benefits
00000
Total Benefits
00000
Net Present Value (automatically calculated):
Discount Rate:5.00%(Do not change)
Present Value of Benefits:$0.00 ($000s)
Present Value of Costs:$0.00 ($000s)
Net Present Value (NPV):$0.00 ($000s)
Examples that are included in the table are not comprehensive. Add to / remove items from the table
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Total
($000s)
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Total
($000s)
0
0
0
0
0
This table will be filled in automatically from the data on Tab 1 - 'Cost-Benefit Template'.
Copy the data from this table into your business case in the 'Cost-Benefit Analysis' section.
BENEFITS
Cost Savings000000
Cost Avoidance000000
Revenue000000
Other 000000
Total Benets000000
COSTS
Non-Recurring000000
Recurring000000
Total Costs000000
Net Benet or Cost000000
Present Value of Total Benets: $0.00
Present Value of Total Costs:$0.00
Net Present Value$0.00
Quantitative
Analysis
Year 1
($000s)
Year 2
($000s)
Year 3
($000s)
Year 4
($000s)
Year 5
($000s)
Total
($000s)
