Last version published: 06/02/2018 14:27
Publication number: ELQ-91266-2
View all versions & Certificate
Cost Benefit Excel Template
Cost-Benefit Template in Excel to work out your various costs, savings, and revenues.
Calculated for up to 5 years, this spreadsheet presents a business case for calculating your:
1. Total Non-Recurring Costs
2. Total Recurring Costs
3. Total Costs
4. Total Revenues
5. Total Cost Savings
6. Total Cost Avoidance
7. Total Other Benefits
8. Total Benefits
Tab 1: Cost-Benefit Template
-You should endeavor to complete this table in as much detail as you can.
-The examples given are not comprehensive, and you are able to add or remove from the table to suit your needs.
Tab 2: Summarization
-Based on the info entered into Tab 1, this will be filled in automatically.
-The data in this table should be transferred into the Cost-Benefit Analysis table in the business case section.
© 2018, Government of Saskatchewan.
This Best Practice includes
1 Cost Benefit Excel Template
Government of Saskatchewan offers you this Best Practice for free!
download for free
Add to bookmarks
4.5 / 5 (33 votes)
- Rate this Downloadable Best Practice
Write a review
- Παπαζαχαρίου Πέτρος(last updated: 10/12/2020 16:54)
- Balakrishna Gopinath(last updated: 18/06/2020 14:13)
- Sandra Mahoney(last updated: 06/02/2020 21:10)Cost Benefit Analysis
- Abid Fahruddin(last updated: 02/01/2020 15:53)
- thanh lan(last updated: 01/11/2019 08:20)
- Lungi Mabuza CA(SA) 774(last updated: 10/10/2019 12:16)
- Meredith Mannebach(last updated: 03/10/2019 14:50)
- George Lugembe Malyeta(last updated: 12/09/2019 19:02)
- Asshok Sripati(last updated: 08/09/2019 07:37)
- Hae Lai(last updated: 14/07/2019 14:03)
- Pham Tuan(last updated: 10/05/2019 11:51)
- Shreya Verma(last updated: 18/04/2019 06:10)
- Salvador Siegel(last updated: 16/04/2019 20:59)
- 상철 한(last updated: 05/04/2019 13:12)
- Chance-sam Grantham(last updated: 27/02/2019 20:20)
- Paul G. Clements(last updated: 03/02/2019 17:32)
- Sohaib Abbas Qazi(last updated: 24/01/2019 10:45)
- Najam Us Saqib(last updated: 24/12/2018 08:48)
- Dominique Shavonne(last updated: 21/12/2018 23:13)
- TINH Nguyen(last updated: 04/12/2018 15:08)
- Leonard Gojer(last updated: 20/11/2018 12:16)
- Aparna Ravikumar(last updated: 05/11/2018 07:08)
- Mohammed Msingi(last updated: 29/10/2018 08:49)
- mohd najman(last updated: 18/10/2018 04:12)
- Scott Donald(last updated: 15/10/2018 19:10)
- solomon kalega(last updated: 10/10/2018 05:35)
- Jay Bishop, MSHA, CPHQ(last updated: 20/09/2018 17:21)
- Arpan Sarkar(last updated: 09/08/2018 19:25)
- padam Gusain(last updated: 27/07/2018 07:29)
- Piet Potgieter(last updated: 18/06/2018 05:32)
People using this Best Practice also downloaded
Wholesale Price Calculator ExcelThis Excel tool calculates your profitability before submitting customer quotes. Analyse and set prices with ease.businessprofitrevenuestartupcalculator3,566add_shopping_cart
2017 Round 1: Go With the FlowExcel training/competition model from the 2017 Financial Modeling World Championshipsrevenuescostsexcel modelexcel skillsfinancial modeling skills285add_shopping_cart
How to make Financial Models Easier to Understand, Use and Audit (5 tips)A guide with 5 tips to build Financial Models easy to Understand, Use and Audit.guidebest practicetipsfinancial modelingfinancial modelling352add_shopping_cartfreeby Matthew Bernath
Savings Interest Excel CalculatorSavings Interest calculator will identify interest payment growth.interestexcelsavingsinterest calculatorcompound interest1,085add_shopping_cart
Excel Workbook for Calculating Revenues & Costs of Water FabricationThis Excel Workbook provides models to help you calculate revenues and costs of water fabrication.revenuescostsengineeringwater fabrication189add_shopping_cart
SaaS (Software as a Service) Financial Projections Excel Model TemplateThis is an Excel model template to help project the finances for a Software-as-a-service business.businesssaasmodelssoftware as a servicefinancial modeling545add_shopping_cart$49.00by Mahender K. Punhani
Collection of Useful Excel Sheets for EngineersCollection of 28 sheets in one excel file made exclusively for engineers to make their lives easier.excelengineeringspreadsheetsusefulcalculators450add_shopping_cartfreeby Norman May
Six Sigma Templates Tool KitThis Six Sigma Toolkit includes 39 high-quality spreadsheet templates for completing Six Sigma Tasks.project managementexceltoolkitspreadsheetssix sigma469add_shopping_cartfreeby Matt Evans
Margin Excel DashboardSimplified model developed in Excel for contribution margin study demonstration with graphical visualization of results.accountcostsdashboardexcelmargin700add_shopping_cartfreeby Lauro Jorge Prado
Business Excel DashboardEasily updatable Excel Dashboard. Focus on budget goals with live tracking on key accounts and Aged Receivables.businessincome statementgraphsratiosdashboard593add_shopping_cart$10.00by Jacob Ward
Any questions on Cost Benefit Excel Template?
The user community and author are here to help. Go ahead!