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. There are three (okay, four) easy ways to get it:
1. The best way is with our new Instant Download method, provided by a nice handy service from SWREG Digital River. You get to that by clicking the Red White and Blue "Buy Now!" medallion in the left-hand margin of this page, or here: INSTANT DOWNLOAD. Once there, you just pay (with a credit card or PayPal) and you will get an instant download link. Easy as pie!! 2. If for some reason you don't like method #1, you can always send me a payment through PayPal. Just send it to my account, which is my email address: email@example.com. Once PayPal notifies me that you've sent a payment (which only takes a few minutes), I'll email the template to you (which might take a few hours; heck, I might be asleep, especially if you are in the Eastern hemisphere!). So if you want it right now, you're probably better off with method #1.
3. If you're not familiar with PayPal and don't want to be, you'll have to use a credit card. You should really go to method #1 in that case, but you can also do a CC through PayPal. Just click on the "Buy Now" button in the right-hand margin of this page, and it will take you to a standard Credit Card payment screen that we all know and love so well. (You have to click the "continue" link at the bottom of the first page the button takes you to.) When I get your credit card payment, I'll email the template to you toot pronto. But really, method #1 will get it to you even quicker.
4. If you are a VENMO user, you can click on the PayPal link, too. PayPal will recognize you, and offer you the option of paying with Venmo or with PayPal, your choice. Pretty slick, eh?
Remember, you can always download the free version right HERE. Did I mention that this one is free? 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 firstname.lastname@example.org. 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.