How to Calculate ROI

Published 16 March 9 11:2 AM | Aaron Stannard

Recently my co-worker Rich asked us all “Why Bother with Return on Investment (ROI)?” As Rich points out, most managers sing the praises of understanding ROI without practicing what they preach. I myself don’t calculate ROI nearly as often as I should, because it’s often difficult to do and sometimes it’s something that falls by the wayside in the midst of the noise and hustle of the workplace.

Return on Investment means a lot of things; it means one thing in the world of accounting, another in the world of financial investments, and it means another in the scope of project management. We’re just managers of one sort or another here at Working Smarter, and we use ROI as a figure to illustrate the costs and benefits of our projects. We find that calculating ROI helps us avoid pitfall projects, helps get our co-workers to buy-in to project ideas, and helps us prioritize how we use our resources.

When I calculate ROI for a project or a new marketing initiative I find that it is extremely helpful for my co-workers, my boss, and the other teams within our organization who might be involved with the project in some way, shape, or form. ROI figures help them buy into the project and help them prioritize their projects accordingly – something with an ostensibly high return on investment will be prioritized ahead of things with uncertain or perceptibly low ROI.

ROI is a simple concept; it’s the total dollar/time return your organization will receive in exchange for undertaking a project or initiative of some sort.

But how do you actually calculate it? How do you accurately calculate the Return on Investment of your projects? Well, I’ll show you – first we need to understand the two dimensions of ROI:

  1. Reduced Costs – The first way a project produces returns is in the form of reduced costs. In this situation you calculate ROI using this formula:
    ROI = Change in Operations Cost / Costs of Project
  2. Increased Revenues – The second way a project produces returns is in the form of increased revenues to the organization. If a company decides to invest a ton of effort into developing a new product, the ROI for that new product will be the additional revenue that the project generates less the costs taken to produce and promote that product. You calculate the formula like this:
    ROI = Change in Revenue / Costs of Project

We know how to calculate the overall ROI figures now, but what we really need to do is determine how to calculate the individual parts for both formulas. There’s a process for doing this, which I have defined below:

Although it looks complicated, it’s actually not too bad once you learn how to use the right tools to do each step. People have written books on this stuff, so I’m not going to go into extensive detail, but I’ll be able to give you enough to get you started with ROI.

Step 1 – Determine how much Work is Needed to Complete the Project

This is a very, very familiar step for long-time Working Smarter readers – to accurately determine how much work is needed to complete a project, simply decompose the project’s tasks into a series of very small, simple tasks using a mind map.

It’s very difficult to accurately determine how much work is needed to complete a large task; therefore the most accurate way to schedule large tasks and projects is to break them down into groups of small tasks. Here’s a relevant passage from the previous article:

Don’t believe me? Let’s [consider a project] that everyone can relate to: moving from one home to another. Consider these two groups of questions:

  1. How long will it take you to pack up all of your belongings, move them into your car, unload them into your new house, and unpack them?
  2. How long will it take you to do the following:
    1. Pack up all of the dishes, silverware and cookware in the kitchen?
    2. Pack up all of the delicate China and glassware?
    3. Pack up the five-piece dining set?
    4. Move the China cabinet into the car and unload it back at the new house?

Most people will find that it is substantially easier to produce more reasonable, reliable figures for the set of questions under item two than under item one. That’s why we strongly recommend using mind maps to leverage this principle.

If you would like to learn more about decomposing projects with mind maps then we highly recommend signing up for How to Manage a Project, our free eCourse which explains the technique in detail.

Step 2 – Determine the Cost of the Work Needed to Complete the Project

You’ve determined all of the tasks and amount of labor needed to complete a project - now you need to calculate the dollar per hour cost of that labor and resources. This part requires some work. Here are components of this step:

  1. Labor wages for new hires / contractors / consultants – Divide the work time between the new hires working on the project, determine the cost per / hour for each employee, and sum all of them up.
  2. Cost of new equipment – If you need to purchase any new equipment for your project, include all of the costs of purchasing that equipment (financing, installation, transportation, etc…) and add that as a cost.
  3. Cost of leases / rentals – If you need to lease equipment for your project, determine the duration of the lease based on your tasks and estimate the cost for that duration. Do this for every rental needed.
  4. Opportunity cost – Many project managers do different things when it comes to opportunity cost, because it’s not a true “dollar cost” that shows up on a financial statement. Opportunity cost is the cost of picking this project over the next best alternative. It’s really an issue that determines your priorities more so than your costs – a project with a high opportunity cost could still produce a positive ROI, but it might be that the next best alternative has a significantly higher ROI. Use this to determine how to use your in-house resources appropriately, such as your employees’ labor and your company-owned equipment.

Step 3Calculate Returns

For projects that don’t produce any new revenue you need to determine the extent of the costs eliminated by your project. You can do this by building a “before” workflow and an “after” workflow – study how your company’s processes change before and after the projects are completed.

This is a concept that requires some additional understanding, so I recommend subscribing to our How to Manage a Process eCourse which explains it at length. Once you’ve determine the change in costs, calculate the ROI:

ROI = Change in Revenue / Costs of Project

For projects that generate revenue, do the following:

  1. Determine your target market / persona – determining your target market isn’t easy, particularly if you’re launching a new business. We outlined a simple thought process for determining a target market, but I suspect that many readers will not be satisfied with that explanation. The fact is that marketers will never have 100% of information needed to make a business decision – they have to cope with a lot of ambiguity, and our process is an acknowledgment of that.
  2. The hard part: estimate the worst, average, and best cases for sales – estimating sales is never easy. Marketing isn’t easy. But it has to be done. Write down your set of assumptions for new sales and new revenues, and based on those assumptions and your target market come up with three cases: the worst case, the average cast, and the best case for sales.
  3. Present the sales cases to your team and come up with the “most reasonable” estimate – unless you’re working by yourself, you should always confer with your team to determine if your assumptions are reasonable or not.
  4. Determine the “likely revenue” based upon the “most reasonable” sales estimate – produce an actual dollar amount for your “new revenue” figure.

Once you have all of this information, you can make your calculation:

ROI = Revenue / Costs of Project

ROI calculations aren’t always easy to do, but I’ve given you a guide here that should help many of you get started on the right foot.

If you have an easier, simpler, or more accurate way to calculate ROI then I would be more than thrilled to read it, so please consider contacting me with that information or leaving it in the comments.

If you liked this post, make sure you subscribe to our RSS feed or follow us on Twitter.



    Comments

    # David Harper said on March 16, 2009 3:09 PM:

    Not to nitpick but your calcs are more like cost/benefit (payback or NPV without time value). ROI is generic term for a flow/stock metric where flow = income/cash flow and stock = investment. So for example, a flavor of ROI is ROIC = EBIT/invested capital or ROE = aftertax income/equity is a flavor of ROI. On a project basis then, ROI = incremental income or cash flow divided by incremental cost/investment (could be risk-adjusted). "Return on" implies divide by. ROI is very generic with many specific flavors.

    # Aaron Stannard said on March 16, 2009 3:44 PM:

    David,

    ROI is indeed a highly nuanced subject and yes I'd admit that my description of ROI reads more like cost/benefits analysis, and I think that's fine in the simple context (using ROI to get team member buy-in and prioritize projects) in which I intended it.

    Your description of project ROI sounds like the accounting valuation method which is a nuance that I didn't do justice in my article, so thank you for pointing that out. I'm sure many other commenters will point this out as well once this article hits the Working Smarter Bulletin later this week ;)

    Thank for your thoughtful comment - I'm going to mull it over and consider revising the tone of my article in order to accommodate for the difference between the traditional use of ROI and the use for which I intended it in this article.

    # Aaron Stannard said on March 16, 2009 4:39 PM:

    Hey David,

    I went through and corrected the article. The definitions should have absolutely been ratios. I have enacted that change in my formulas.

    It's been a couple of years since I did the NPV calculations for valuation :\

    # David Harper said on March 17, 2009 11:05 AM:

    Hey Aaron, Glad it helped, thanks for taking in the spirit intended! David

    # Aaron Stannard said on March 17, 2009 11:51 AM:

    No problem, David. I loved your site by the way. My brother is a budding technical analyst and I forwarded it to him.

    # Wayne Brantley said on March 18, 2009 10:27 AM:

    The calculation would be for BCR.  If you want ROI use:  ROI = Change in Revenue - Cost of Project / Costs of Project  x 100.  This is the one used in Jack Phillip's ROI methodology.

    # Derek Grant said on March 18, 2009 11:54 AM:

    Not to belabor the point, but there usually is a time differential between the time(s) the investments are made and the time(s) the returns are presumed to flow.  It is important to standardize all dollar estimates using their Net Present Value in order to account for the changing value of money.  The discount rate (aka, inflation) can severely reduce the actual benefits of a project whose payback is way off in the future.

    # Richard said on March 18, 2009 4:00 PM:

    Hello Aaron

    I enjoyed your article, however there are many nuances to Return On Investment. Maybe Rich is right why bother to calculate it at all. Lies, damn lies and statistics. One, with judicious selection of data or information can make it bend and twist to support any point of view whether it be accounting, marketing, service provision etc.

    I think in these economic times ROI will have to return to a purely accounting basis but maybe there will be a paradigm shift away from this to inter and intra organisational and community service provision concerns and benefits.

    That is away from management to leadership, maybe

    I am a hopeful cynic.

    Richard

    # Working Smarter said on March 24, 2009 8:48 AM:

    How many teams have you worked with over the course of your life thus far? You’ve probably worked with

    # Jchris said on June 2, 2009 11:45 AM:

    Until I reached the end of your article, I never used to understand the RIO except using the fixed formula.

    Thank you

    Christopher

    (Polytechnic of Namibia)

    # Paul Barkley said on August 13, 2009 3:44 PM:

    I agree with Wayne's formula, except for the missing parentheses.  It can be restated something like this:  ROI = [(Payback - Investment)/Investment)]*100

    All investments start out in the hole because of course they cost money up front and save nothing, so at the beginning, plugging in $0 for the payback and whatever you want for the investment, you have an ROI of -100%.  Not good!  But let's say you invest $100,000 and after you add up all the cash benefits you start saving $10,000 per month.  Obviously in 10 months you'll pay back the investment and after that it will start making you money until it has to be replaced.  Most people who do ROIs to justify their projects assume the project will save money indefinitely, and of course that's ridiculous.

    What's the ROI?  Well, in month 0 it's -100%, and in month 1 it's -90%, and in month 10 it's 0%.  After that it gets better.  In month 11 it's 10%, in month 12 it's 20%, and so forth.  So ROI doesn't make any sense unless you peg it to a time period, like the first year, the first two years, etc.  That's why most ROI calculators show it as two lines on a graph, so you can easily see the breakeven point (10 months in this example).

    But what's the real problem with ROI?  Actually, in many fields most of the benefits are non-financial and are difficult to quantify, meaning people just make up the numbers to suit their argument.

    Let's say you rip out your old corporate web site and put in a new web site.  Computing the cost is easy, but there probably isn't going to be ANY cost savings and therefore no real payback in terms of direct ROI.  Does a nicer looking site run any more cheaply on your servers?  Setting aside some grossly, and I do mean grossly, inefficient old web site that serves up tons of images every time someone surfs around and your ISP charges you up the ying-yang for bandwidth, there are going to be zero savings from a nice new site.

    The actual value of creating the new web site is to retain customers, attract new customers, help customers find information about your organization, and so forth.  If you happen to sell something, then of course you can measure the change in sales, but you won't know that in advance.  In most cases, you're improving various intangibles about your company, factors that really can't be measured.

    ROI Calculators online are really popular with outsourcing, for example, where you actually can measure costs before and after the investment.  If you fire all your support staff and move those services to an offshore outsourcer, you're going to see some spectacular ROI because your costs will go way down.  So why doesn't everyone do this?  Because of course your customer satisfaction will probably go down as well.  (Outsourcers of various kinds, however, may be able to actually provide BETTER support, but that's on a case by case basis.) So while this example should be a no-brainer for ROI, it's the intangible, difficult to quantify costs that are likely to be the problem.

    Just my two cents worth...

    Leave a Comment

    Name:  
    Website:

    Powered by SmartDraw

    Increase your productivity. Be a better manager.

    Request a Demo
    Request a Demo

    Learning Resources


    Foundations of Persuasive Presentations
    Foundations of Persuasive Presentations
    Learn new ways to ensure that your presentation is targeted, compelling, and persuasive.
    Click here to learn more
    How to Optimize a Business Process
    How to Optimize a Business Process
    Learn how to increase the efficiency of and profitability of your business through process optimization.
    Click here to learn more
    How to Manage a Project
    How to Manage a Project
    Learn how to get more done on time and under budget by using mind maps, project charts, and team charts to effectively manage your projects.
    Click here to learn more

    You can find more of these freely available learning materials and eCourses from the Working Smarter Learning Center.