Your Privacy

This site uses cookies to enhance your browsing experience and deliver personalized content. By continuing to use this site, you consent to our use of cookies.
COOKIE POLICY

ROI Calculator Excel Template | Business Case for Tech Projects

ROI Calculator Excel Template | Business Case for Tech Projects
Back to insights

Most organizations have extensive technology wish lists for software, but a limited amount of resources to deliver on the wish list. Around every corner lies a new opportunity to rebuild, re-platform, or reinvent the tech stack that’s gotten you this far. But with so many opportunities, it’s often challenging to assess and prioritize which projects to tackle first, particularly since each has a unique risk profile and investment requirement. This post, which includes our free ROI calculator excel template for IT projects, will help you swiftly and effectively evaluate and document the return on investment (ROI) for software. This business case spreadsheet template includes prebuilt formulas in Excel format ready for immediate use to document your ROI.

Evaluating opportunities to decide which ones to pursue is an important task. While there is not a one-size-fits-all approach to making this decision, a consistent approach can be very helpful. Developing a business case to understand both quantitative benefits like the financial return on investment (ROI) of software and qualitative benefits such as employee satisfaction is ideal.

Measuring the ROI of projects is inherently tricky. On one hand, there are simple ways to compare some key performance indicators – errors and speed, for example. However, other metrics – such as employee engagement or customer satisfaction – are often more difficult to quantify. Not surprisingly, your methods for measuring ROI will greatly depend on your particular use cases, so it is critical to begin with your original goals for each project. In short, it’s a straightforward task to measure investment; however, measuring benefits can be more complex. Let’s look at each.

In a hurry to download the ROI Template for IT projects? Fill out the form and get started immediately.

In this article, we will cover:

Investment Inputs for our ROI Excel Calculator for IT Projects

Investment expenses are typically categorized as being either ongoing or variable (one-time). Ongoing expenses refer to both software licenses and maintenance. As platform license costs vary according to usage, understanding the number of licenses required is essential.

One-time expenses refer to single purchases that are not necessarily repeated every year. These could refer to hardware expenses, set-up costs, or even contracted labor. Some one-time expenses are financed through capital budgets rather than operating expenses, as there are different tax implications for each. Our Excel template includes formulas for these key ROI inputs.

Benefit Inputs for our ROI Calculator for IT Projects

ROI calculatorBenefits refer to the expected quantitative and qualitative outcomes of a given initiative. As these projects explicitly lead to new results, such benefits can be tricky to measure, but not impossible. Here are some ways to approach measuring benefits.

  • Reduced overhead. Today, many IT projects aim to reduce manual workload which in turn will reduce company expenses. But how much and from which departments matter if you’re seeking to justify the project expense, so considering the likely results of such initiatives in advance is critical.
  • Reduced errors. Process-heavy organizations generally understand the cost of human errors. In some scenarios, these are negligible. But even simple ecommerce errors add up when coupled with restocking and shipping costs. In compliance-heavy organizations, however, fines often number in the thousands of dollars. In short, the amount your organization stands to save in reduced errors is highly specific to your use case. Error reduction might mean saving a little money every day or it might mean protecting the organization from fewer more significant losses. Your risk reduction tolerance is key when evaluating this component of ROI.
  • Increased revenue/profits. The above two inputs have theoretical ceilings; you can’t save any more money than you are already spending. Conversely, increased revenues and profits represent the additional business opportunities that result from successful IT projects. If throughput is increased through innovation, capture the anticipated amount of increased revenue or profits. This could be from increasing sales of existing products, developing new products, or increasing customer retention and earning more per customer.
  • Qualitative benefits. While your CFO will be thrilled that you’ve approached this project from such a quantitative perspective, the truth is most technology projects go beyond the numbers. In some cases, new technology projects create new opportunities. In other cases, older platforms may no longer be supported, requiring projects to be completed. In short, it’s critical to document benefits that don’t fit as neatly into a calculator.

Consider Time

Few projects provide an immediate, positive ROI. Each company will select its own horizon, based on experience, risk tolerance, etc. Shorter time frames require better execution to generate returns more quickly. Meanwhile, longer-term projections rely on your ability to predict further into the future, a difficult task for anyone to documentROI.

For our ROI calculator for IT projects, our formula in the Excel spreadsheet template assumes a five-year payback period. Your mileage may vary!

It’s All About the Hurdle

ROI calculator - return on investment templateAssuming you’ve filled out the inputs and time horizon in our document, the formulas in our return on investment Excel template have now provided you with a predicted ROI. Still, it is only a number until you consider the “hurdle rate.” In investing, the hurdle rate refers to your company’s established barometer that determines the initiatives worthy of investment.

You’ll want to know this number for your use case, as it can vary. Some companies aggressively pursue market share. (Think GE when Jack Welch took over.) Others are content with slow and steady growth. (Think GE for the sixty years before Jack took over.) Venture capital (VC) funded companies have higher hurdles because they chase higher returns and have higher risk tolerances. In truth, there is no “right” philosophy: there is simply the right one for you. It is likely that your finance team will have an idea of what sort of hurdle to apply to investment decisions.

Putting it All Together & Then Keeping it Going

With all of your inputs in the ROI calculator Excel, you’re ready to juxtapose your expected ROI against your organization’s hurdle rate. If your predicted ROI is greater than the hurdle rate, the formula in our Excel document template has deemed the project worthy of investment. Conversely, if it underperforms, it doesn’t make the cut.

If You Find the Math is Not in Your Favor, Consider the Following:

ROI calculator - business case template excelYour project costs are too high. If your projected ROI is too low, first consider your assumptions for project costs. Have multiple solutions or vendors been considered? Can project timelines be shortened? Are you building features that do not increase benefits?

Did you capture all the benefits? Perhaps you did not canvass widely enough to understand all the parties that will benefit from your improvement. Did you estimate benefits too conservatively? Can you be more aggressive without being reckless?

Start with the projects with the biggest bang for the buck. In agile, the term Weighted Shortest Job First is used to prioritize what delivers the greatest ROI in the least amount of time. Plus, shorter timelines equate to inherently less risk, so you’ll be more confident in your expected ROI.

If necessary, extend the timeline – but be careful. Just as a six-year car loan has smaller payments than a five-year loan, a six-year event horizon will spread your capital expenses over a longer period. That said, be sure to consider how vibrant your industry vertical may be. If the projects you’ve earmarked for replatforming have been in place for a decade or more, you might be safe extending the payback period. But if you’re in an industry that frequently changes, six years can feel like an eternity!

Now you’re ready to start building the business case for your next technology project.

Already downloaded the ROI Calculator Excel template? Watch this video to learn how to best use the return on investment template.

Download the ROI Excel Calculator

*
Required

Digging In

  • Digital Products

    The Growing Importance of Digital Accessibility

    Embracing Digital Accessibility: A Moral and Business Imperative In today’s digital landscape, accessibility has become crucial for businesses and organizations. With increasing awareness and legal requirements, ensuring that digital products are accessible to all users, including those with disabilities, is not just a compliance issue but a moral imperative. At UDig, we champion ADA compliance […]

  • Digital Products

    Unlocking Business Potential: The Power of Custom Application Development

    Like any savvy business leader, you’re likely always on the lookout for tools to give your company a competitive edge. And in doing so, you’ve undoubtedly considered investing in custom application development. But the question is, how do you ensure that such a major investment in a custom web application development provides a strong return on […]

  • Digital Products

    Mastering Legacy Application Modernization: Strategies for Success

    The ironic truth of the business world is that change is the only constant. But this means that failing to keep pace with the competition and its technologies will only end with you falling behind. That’s where legacy application modernization enters the fold. When you modernize legacy applications, your team gains access to new features […]

  • Digital Products

    CTO Confessions Podcast

    In this episode of CTO Confessions, Rob Phillips, the Vice President of Software Engineering at UDig, digs into his journey from a passionate technologist in his youth to a seasoned leader in the tech industry. He shares valuable lessons on transitioning to senior leadership, the importance of understanding and articulating company problems, and the art of empowering teams for high performance.

  • Digital Products

    Navigating the Challenges of On Premise to Cloud Migration

    In today’s rapidly evolving technological landscape, the shift from on premise solutions to cloud-based infrastructure has become a pivotal transformation for organizations seeking to modernize their IT operations. This transition holds the promise of increased agility, cost savings, and enhanced scalability. However, it is not without its set of formidable challenges that organizations must navigate. […]

  • Digital Products

    The Power of Transferrable Skills in Tech Projects

    Every project has its own unique elements that require flexibility to be effective and achieve success. This often requires picking up new pieces of a tech stack, learning a new programming language, or a new project methodology. Fortunately, there are also many transferrable skills that carry over from one project to the next. In my […]