Cost Benefit Analysis Template
Before I waste your time with a lot of words, this is probably what you are looking for: the FREE version of our Cost Benefit Analysis Template, right HERE.
Now, on to the words. Engineers, as a group, hate inefficiency. I know I do, don't you? That is why I have developed the Cost Benefit Analysis (also known as Business Case Analysis) template. So many calculations need to be performed, so many times, that it just makes sense to have a re-usable tool that performs the necessary tasks.
Two items are necessary to us, the working engineering professionals: first, the understanding of the theory behind a cost/benefit analysis, and second. the software tools that do the work. If you need a refresher on the understanding of the theory, please read my article on the topic here. But for a software tool, I recommend our Cost Benefit Analysis Template.
What does this template do for you? Well, for starters, it is an Excel file that is completely configurable and re-writable for you Excel jockeys (paid version only). On the other hand, if you are not an Excel expert, you can merely pop in your input values and let it hand you back the output values that you need (free version). Either way, it is meant to skip the first few days worth of effort that most engineers would need to invest in a Cost Benefit Analysis effort.
This template accepts inputs for all the anticipated Costs and Benefits of an anticipated or proposed project. That is, initial investment costs, recurring costs, and close-out costs. Plus all the anticipated benefits, such as recurring benefits, one-time future benefits, and final benefits. In other words, anything that you can anticipate, cost-wise or benefit-wise, you can enter in the appropriate data slot.
The template returns several economic assessments that you might find worthwhile, and that your organization probably requires. Such items as Present Worth of the investment, Internal Rate of Return of the investment, and Payback Period of the investment (in other words, how long until the project returns sufficent profits to pay for itself). There are also several pre-canned graphical plots designed to plop into your report to managment. And since it is all in Excel, you are free to re-format or re-program any or all of the information as you see fit, and to generate any graphs or reports that your company requires (paid version only).
Still not convinced? Well, that's reasonable. Download our free version right now.
If it is all you need, enjoy it with our compliments. If you need to modifiy it, a mere $40 will get you the unlocked version, which you can customize to your heart's content. Payment accepted through PayPal to my email,
jcesarone999@gmail.com.
jcesarone999@gmail.com.
Download the free version right HERE.
As a final plug, I am free for additional consulting, on a daily-rate basis, if you need additional help for your Cost/Benefit Analysis. Just email me at
jcesarone999@gmail.com. Or, you might catch me on the phone at 312.493.0839, if it is a decent hour in Chicago.
jcesarone999@gmail.com. Or, you might catch me on the phone at 312.493.0839, if it is a decent hour in Chicago.
Did I mention our newly-released Unit Conversion template? No? Check it out
here.
here.
