A Forrester Total Economic Impact™ Study Commissioned By Celigo, August 2024
One-third of developers in Forrester’s Developer Survey, 2022, looked for architecture strategies and designs that foster business agility.1 However, integrating applications and data with hand-coding is a significant barrier to achieving that agility. As such, an integration platform as a service (iPaaS) appeals to teams that want to solve integration challenges rapidly with easy maintenance and operations.2 The Celigo integration platform, as a unified low-code integration and automation solution, houses these capabilities. The Celigo platform enables organizations to increase user productivity, data accuracy, and connectivity while reducing operational costs and promoting business growth.
The Celigo integration platform is an AI-enabled cloud-native iPaaS that allows its users to automate their business processes across the entire enterprise. It does this by enabling IT development and line-of-business teams alike to build, maintain, and manage integrations across their organization’s software-as-a-service (SaaS) and legacy on-premises applications, which are critical to automating these processes end to end.
Celigo commissioned Forrester Consulting to conduct a Total Economic Impact™ (TEI) study and examine the potential return on investment (ROI) enterprises may realize by deploying the Celigo integration platform.3 The purpose of this study is to provide readers with a framework to evaluate the potential financial impact of the Celigo integration platform on their organizations.
To better understand the benefits, costs, and risks associated with this investment, Forrester interviewed five representatives with experience using the Celigo platform. For the purposes of this study, Forrester aggregated the interviewees’ experiences and combined the results into a single composite organization.
Interviewees said that prior to using the Celigo integration platform, their organizations’ business processes and integrations were manual or only partially automated with antiquated point-to-point (P2P) or other iPaaS solutions. As such, their existing processes were prone to errors as data scaled, which negatively affected end-user, customer, and partner experiences. There was high demand to improve business process efficiencies as the organizations grew, but they faced technical limitations with their existing technologies and setups. Additionally, IT teams were strapped for time and lacked the capacity to fulfill the integration and automation needs of the business with the complex integration solutions they currently had in place.
With the investment in the Celigo platform, the interviewees’ organizations had access to a centralized integration and automation solution with an interface that catered to both technical and business users. Key results from the investment include improved IT and business user productivity, a reduction in errors, and cost savings related to legacy integration and automation solutions. Process efficiencies also translated to improved end-user, customer, and partner experiences and business growth.
Quantified benefits. Three-year, risk-adjusted present value (PV) quantified benefits for the composite organization include:
For , incremental profit contribution might be worth over three years.
For , a reduction in development timelines for integrations and flow projects might be worth over three years.
For , a reduction in the cost of resolving data errors might be worth over three years.
For , business user productivity improvements might be worth over three years.
For , tool replacement cost savings might be worth over three years.
Unquantified benefits. Benefits that provide value for the composite organization but are not quantified for this study include:
Costs. Three-year, risk-adjusted PV costs for the composite organization include:
For , fees to Celigo over three years might total .
For , implementation and ongoing management costs over three years might total .
For , internal costs over three years might total .
The representative interviews and financial analysis found that the composite organization experiences benefits of $1.4 million over three years versus costs of $287,000, adding up to a net present value (NPV) of $1.1 million and an ROI of 383%.
might experience benefits of over three years versus costs of and an ROI of .
Return on investment (ROI)
Benefits PV
Net present value (NPV)
From the information provided in the interviews, Forrester constructed a Total Economic Impact™ framework for those organizations considering an investment in the Celigo integration platform.
The objective of the framework is to identify the cost, benefit, flexibility, and risk factors that affect the investment decision. Forrester took a multistep approach to evaluate the impact that the Celigo integration platform can have on an organization.
Interviewed Celigo stakeholders and Forrester analysts to gather data relative to the Celigo integration platform.
Interviewed five representatives at four organizations using the Celigo integration platform to obtain data about costs, benefits, and risks.
Designed a composite organization based on characteristics of the interviewees’ organizations.
Constructed a financial model representative of the interviews using the TEI methodology and risk-adjusted the financial model based on issues and concerns of the interviewees.
Employed four fundamental elements of TEI in modeling the investment impact: benefits, costs, flexibility, and risks. Given the increasing sophistication of ROI analyses related to IT investments, Forrester’s TEI methodology provides a complete picture of the total economic impact of purchase decisions. Please see Appendix A for additional information on the TEI methodology.
Readers should be aware of the following:
This study is commissioned by Celigo and delivered by Forrester Consulting. It is not meant to be used as a competitive analysis.
Forrester makes no assumptions as to the potential ROI that other organizations will receive. Forrester strongly advises that readers use their own estimates within the framework provided in the study to determine the appropriateness of an investment in the Celigo integration platform. For the interactive functionality using Configure Data/Custom Data, the intent is for the questions to solicit inputs specific to a prospect’s business. Forrester believes that this analysis is representative of what companies may achieve with the Celigo integration platform based on the inputs provided and any assumptions made. Forrester does not endorse Celigo or its offerings. Although great care has been taken to ensure the accuracy and completeness of this model, Celigo and Forrester Research are unable to accept any legal responsibility for any actions taken on the basis of the information contained herein. The interactive tool is provided ‘AS IS,’ and Forrester and Celigo make no warranties of any kind.
Celigo reviewed and provided feedback to Forrester, but Forrester maintains editorial control over the study and its findings and does not accept changes to the study that contradict Forrester’s findings or obscure the meaning of the study.
Celigo provided the customer names for the interviews but did not participate in the interviews.
Consulting Team:
Sanitra Desai
Zahra Azzaoui
| Role | Industry | Revenue | Celigo usage |
|---|---|---|---|
|
CTO Executive vice president (EVP) |
Technology | $400 million | Number of
integration flows: 185 Number of endpoints: >10 |
| VP of IT | Pharmaceuticals | $200 million | Number of
integration flows: 30 Number of endpoints: 8 |
| IT director | Retail | N/A | Number of
integration flows: 50 Number of endpoints: 6 |
| Director of enterprise applications | Retail | $100 million | Number of
integration flows: 20 Number of endpoints: 9 |
Prior to the investment in the Celigo integration platform, interviewees said their organizations’ business processes and integrations were either fully manual or partially automated using antiquated P2P solutions. For some, their organizations had also implemented another iPaaS solution for specific integration use cases. The interviewees noted how their organizations struggled with common challenges, including:
The interviewees’ organizations searched for a solution that could:
Based on the interviews, Forrester constructed a TEI framework, a composite company, and an ROI analysis that illustrates the areas financially affected. The composite organization is representative of the five interviewees, and it is used to present the aggregate financial analysis in the next section. The composite organization has the following characteristics:
Description of composite. The global enterprise has $200 million in annual revenue and 500 employees. It serves both business and individual customers. The organization identifies weaknesses in its current integration and automation strategy and seeks out a more centralized and governed approach. The composite organization is looking to transform into a modern digital enterprise by streamlining the integration process and introducing automation into its workflows to build efficient operations, improve internal agility, and better engage with customers and partners.
Deployment characteristics. The organization uses the Celigo platform for integration and automation in both back-office and business-facing operations/applications. It implements the Celigo platform as a strategic initiative with a clear view of which business processes it initially hopes to analyze and optimize with the solution. In Year 1, the organization creates 20 integrations/flows between three endpoints. The automation within these flows affects the efficiency of 20 business users.
Following the success of early flows, the composite organization expands its deployment of the Celigo platform to include 75 integrations/flows between 12 endpoints over three years. The integrations affect 100 business users by Year 3 of implementation. Over time, more business users are onboarded onto the platform to create integrations/flows, and there is an increase in reusable components. As such, development timelines and the cost associated with development shrink. Four IT and two business users create integrations using the Celigo platform by Year 3.
| Ref. | Benefit | Year 1 | Year 2 | Year 3 | Total | Present Value |
|---|---|---|---|---|---|---|
| Atr | Incremental profit contribution | $51,000 $51,000 | $102,000 $102,000 | $153,000 $153,000 | $306,000 $306,000 | $245,612 $245,612 |
| Btr | Integration development cost avoidance | $146,253 $146,253 | $186,791 $186,791 | $226,760 $226,760 | $559,804 $559,804 | $457,698 $457,698 |
| Ctr | Reduction in cost of resolving data errors | $39,933 $39,933 | $42,930 $42,930 | $44,280 $44,280 | $127,143 $127,143 | $105,050 $105,050 |
| Dtr | Business user productivity improvement | $37,440 $37,440 | $93,600 $93,600 | $187,200 $187,200 | $318,240 $318,240 | $252,038 $252,038 |
| Etr | Cost savings from retired integration technologies | $90,000 $90,000 | $135,000 $135,000 | $180,000 $180,000 | $405,000 $405,000 | $328,625 $328,625 |
| Total benefits (risk-adjusted) | $364,626 $364,626 | $560,321 $560,321 | $791,240 $791,240 | $1,716,187 $1,716,187 | $1,389,023 $1,389,023 | |
Evidence and data. Interviewees’ organizations used the Celigo integration platform to improve both business operations and the ways in which their organizations serve their customers through new integrations for internal systems, improved data exchange with partners, new workflow automations, and improved access to data and insights. For interviewees, these improvements — targeted to better meet the needs of their internal and external customers — resulted in incremental revenue for their organizations.
Modeling and assumptions. For the composite organization, Forrester assumes:
generates $0 in revenue annually.
might see 0% of its revenue affected as a result of using the Celigo platform in Year 1. This might grow to 0% by Year 3 as adoption and usage of the Celigo platform expands throughout the organization.
might realize a 3% increase in revenue within these revenue streams attributable to the Celigo platform.
might have a 10% operating margin.
Risks. Incremental profit contribution may vary depending on the following:
Results. To account for these risks, Forrester adjusted this benefit downward by 15%, yielding a three-year, risk-adjusted total PV (discounted at 10%) of $246,000.
For , this benefit might have a three-year, risk-adjusted total PV of .
| Ref. | Metric | Source | Year 1 | Year 2 | Year 3 | |
|---|---|---|---|---|---|---|
| A1 | Annual revenue | CompositeComposite | $200,000,000 $200,000,000 | $200,000,000 $200,000,000 | $200,000,000 $200,000,000 | |
| A2 | Percent of revenue affected by Celigo | InterviewsScaled for | 10%10% | 20%20% | 30%30% | |
| A3 | Additional revenue secured as a result of integration initiatives with Celigo | Interviews | 3%3% | 3%3% | 3%3% | |
| A4 | Operating margin | CompositeTEI case study | 10%10% | 10%10% | 10%10% | |
| At | Incremental profit contribution | A1*A2*A3*A4 | $60,000 $60,000 | $120,000 $120,000 | $180,000 $180,000 | |
| Risk adjustment | ↓15% | |||||
| Atr | Incremental profit contribution (risk-adjusted) | $51,000 $51,000 | $102,000 $102,000 | $153,000 $153,000 | ||
| Three-year total: $306,000 $306,000 | Three-year present value: $245,612 $245,612 | |||||
Evidence and data. Interviewees’ organizations experienced both faster delivery timelines and reductions in the cost of resources needed to deploy integrations and BPA flow projects. Interviewees attributed this to the low-code development environment of the Celigo platform, which enables both technical and business users to perform integrations and BPA flows; Celigo’s library of prebuilt processes; and the reusability of developed components.
Modeling and assumptions. For the composite organization, Forrester assumes:
might implement 0 integration/flow projects in Year 1 of using the Celigo platform, increasing to 0 projects by Year 3.
With the Celigo platform, IT staff at might be able to complete complex projects 50% faster.
With the Celigo platform, might be able to complete a noncomplex project 40% faster in Year 1, and the average project duration might decrease by 70% by Year 3.
Risks. Integration development cost avoidance may vary depending on the following:
Results. To account for these risks, Forrester adjusted this benefit downward by 15%, yielding a three-year, risk-adjusted total PV (discounted at 10%) of $458,000.
For , this benefit might have a three-year, risk-adjusted total PV of .
| Ref. | Metric | Source | Year 1 | Year 2 | Year 3 |
|---|---|---|---|---|---|
| B1 | New integration/platform flow projects with Celigo | CompositeScaled for | 2020 | 2525 | 3030 |
| B2 | Complex integration/platform flow projects with Celigo | B1*60% | 1212 | 1515 | 1818 |
| B3 | IT FTEs required to complete a typical complex integration project | Interviews | 22 | 22 | 22 |
| B4 | Average project duration without Celigo (days) | Interviews | 3030 | 3030 | 3030 |
| B5 | Percent reduction in average project duration with Celigo | Interviews | 50%50% | 50%50% | 50%50% |
| B6 | Fully burdened annual salary for an IT FTE | CompositeTEI case study | $120,000 $120,000 | $120,000 $120,000 | $120,000 $120,000 |
| B7 | Subtotal: Cost avoidance, complex integration/platform flow projects | B2*B3*B4*B5*(B6/260 days) | $166,154 $166,154 | $207,692 $207,692 | $249,231 $249,231 |
| B8 | Noncomplex integration/platform flow projects with Celigo | B1*40% | 88 | 1010 | 1212 |
| B9 | FTEs required to complete a typical noncomplex integration project | Interviews | 11 | 11 | 11 |
| B10 | Average project duration without Celigo (days) | Interviews | 44 | 44 | 44 |
| B11 | Percent reduction in average project duration with Celigo | Interviews | 40%40% | 50%50% | 70%70% |
| B12 | Fully burdened annual salary for an FTE associated with completing a typical noncomplex integration project prior to implementing Celigo | CompositeTEI case study | $120,000 $120,000 | $120,000 $120,000 | $120,000 $120,000 |
| B13 | Fully burdened annual salary for an FTE associated with completing a typical noncomplex integration project after implementing Celigo | CompositeTEI case study | $120,000 $120,000 | $83,200 $83,200 | $83,200 $83,200 |
| B14 | Subtotal: Cost avoidance, noncomplex integration/platform flow projects | (B8*B9*B10*(B12/260 days))-(B8*B9*B10*(1-B11)*(B13/260 days)) | $5,908 $5,908 | $12,062 $12,062 | $17,546 $17,546 |
| Bt | Integration development cost avoidance | B7+B14 | $172,062 $172,062 | $219,754 $219,754 | $266,777 $266,777 |
| Risk adjustment | ↓15% | ||||
| Btr | Integration development cost avoidance (risk-adjusted) | $146,253 $146,253 | $186,791 $186,791 | $226,760 $226,760 | |
| Three-year total: $559,804 $559,804 | Three-year present value: $457,698 $457,698 | ||||
Evidence and data. With the Celigo platform in place, interviewees reported that the rate of errors and mistakes fell as their organizations were able to automate manual processes. This was particularly valuable for repetitive tasks where, over time, mental focus can decrease, and human errors can increase.
Additionally, interviewees lauded the Celigo platform’s AI/ML capabilities that assisted in error management, as well as the consolidated view of all integrations and flows that the Celigo platform provided. This reduced the time spent managing errors and enabled IT resources to hand off flow maintenance to less technical users.
Modeling and assumptions. For the composite organization, Forrester assumes:
experiences 0 data errors per month, or 0 per year. It might take an IT FTE 3 hours to resolve an error.
After implementing the Celigo platform, might see a 0% reduction in the number of errors in Year 1. The number of errors might be reduced by 0% in Year 3 as more integrations and flow projects are implemented.
The time it takes IT staff at to resolve an error might be reduced to 30 minutes with Celigo, and might be able to transition the role of resolving data errors to business users by Year 2.
Risks. The reduction in cost from resolving data errors may vary depending on the following:
Results. To account for these risks, Forrester adjusted this benefit downward by 10%, yielding a three-year, risk-adjusted total PV (discounted at 10%) of $105,000.
For , this benefit might have a three-year, risk-adjusted total PV of .
| Ref. | Metric | Source | Year 1 | Year 2 | Year 3 |
|---|---|---|---|---|---|
| C1 | Errors per month before Celigo | CompositeComposite | 300300 | 300300 | 300300 |
| C2 | Average time spent to resolve an error (hours) | Interviews | 33 | 33 | 33 |
| C3 | Fully burdened hourly rate for an IT FTE | CompositeTEI case study | $58 $58 | $58 $58 | $58 $58 |
| C4 | Subtotal: Cost of resolving errors in legacy environment | C1*C2*C3 | $52,200 $52,200 | $52,200 $52,200 | $52,200 $52,200 |
| C5 | Reduction in the number of errors with Celigo | InterviewsScaled for | 10%10% | 25%25% | 50%50% |
| C6 | Average time spent to resolve an error (hours) | Interviews | 0.50.5 | 0.50.5 | 0.50.5 |
| C7 | Fully burdened hourly rate for an IT FTE | CompositeTEI case study | $58 $58 | $40 $40 | $40 $40 |
| C8 | Subtotal: Cost of resolving errors in the Celigo environment | C1*(1-C5)*C6*C7 | $7,830 $7,830 | $4,500 $4,500 | $3,000 $3,000 |
| Ct | Reduction in cost of resolving data errors | C4-C8 | $44,370 $44,370 | $47,700 $47,700 | $49,200 $49,200 |
| Risk adjustment | ↓10% | ||||
| Ctr | Reduction in cost of resolving data errors (risk-adjusted) | $39,933 $39,933 | $42,930 $42,930 | $44,280 $44,280 | |
| Three-year total: $127,143 $127,143 | Three-year present value: $105,050 $105,050 | ||||
Evidence and data. The low-code capabilities of the Celigo platform made it easier and faster for interviewees’ organizations to build integrations and automations. The organizations used the Celigo platform to automate numerous business processes and improve business user productivity throughout the organization.
Modeling and assumptions. For the composite organization, Forrester assumes:
In the first year, 0 business users might be affected by automations created using the Celigo platform. This number might grow to 0 users by Year 3.
Business users at might see a 5% efficiency improvement with the introduction of automation into their workflows using the Celigo platform.
Risks. Business user productivity improvements may vary depending on the following:
Results. To account for these risks, Forrester adjusted this benefit downward by 10%, yielding a three-year, risk-adjusted total PV (discounted at 10%) of $252,000.
For , this benefit might have a three-year, risk-adjusted total PV of .
| Ref. | Metric | Source | Year 1 | Year 2 | Year 3 |
|---|---|---|---|---|---|
| D1 | Business users affected by Celigo | CompositeScaled for | 2020 | 5050 | 100100 |
| D2 | Operational efficiency improvement due to automations with Celigo | Interviews | 5%5% | 5%5% | 5%5% |
| D3 | Fully burdened annual salary for a business user FTE | CompositeTEI case study | $83,200 $83,200 | $83,200 $83,200 | $83,200 $83,200 |
| D4 | Productivity recapture | TEI methodology | 50%50% | 50%50% | 50%50% |
| Dt | Business user productivity improvement | D1*D2*D3*D4 | $41,600 $41,600 | $104,000 $104,000 | $208,000 $208,000 |
| Risk adjustment | ↓10% | ||||
| Dtr | Business user productivity improvement (risk-adjusted) | $37,440 $37,440 | $93,600 $93,600 | $187,200 $187,200 | |
| Three-year total: $318,240 $318,240 | Three-year present value: $252,038 $252,038 | ||||
Evidence and data. In their prior environment, several interviewees had been using multiple integration technologies to build APIs and conduct integrations. However, interviewees told Forrester that most of their organizations’ legacy tools couldn’t handle complex automations or integrations. Instead, these tools were limited to certain coding languages or a narrow group of applications.
After implementing the Celigo platform, interviewees’ organizations consolidated the number of integration technologies in place. Since the Celigo platform supports multiple types of both simple and complex integrations, including application, data, and B2B, organizations were able to sunset other technologies and centralize around Celigo.
Modeling and assumptions. For the composite organization, Forrester assumes:
spends $0 in total annually in license and maintenance costs for its legacy integration technologies.
might gradually sunset integration tools and reallocate the associated management resources as it transitions to the Celigo platform.
Risks. Cost savings from retired integration technologies may vary depending on the following:
Results. To account for these risks, Forrester adjusted this benefit downward by 10%, yielding a three-year, risk-adjusted total PV (discounted at 10%) of $329,000.
For , this benefit might have a three-year, risk-adjusted total PV of .
| Ref. | Metric | Source | Year 1 | Year 2 | Year 3 |
|---|---|---|---|---|---|
| E1 | Total cost of legacy solutions for integrations | InterviewsInterviews | $200,000 $200,000 | $200,000 $200,000 | $200,000 $200,000 |
| E2 | Percentage of legacy solutions retired after implementing Celigo | Interviews | 50%50% | 75%75% | 100%100% |
| Et | Cost savings from retired integration technologies | E1*E2 | $100,000 $100,000 | $150,000 $150,000 | $200,000 $200,000 |
| Risk adjustment | ↓10% | ||||
| Etr | Cost savings from retired integration technologies (risk-adjusted) | $90,000 $90,000 | $135,000 $135,000 | $180,000 $180,000 | |
| Three-year total: $405,000 $405,000 | Three-year present value: $328,625 $328,625 | ||||
Interviewees mentioned the following additional benefits that their organizations experienced but were not able to quantify:
The value of flexibility is unique to each customer. There are multiple scenarios in which a customer might implement the Celigo platform and later realize additional uses and business opportunities, including:
Flexibility would also be quantified when evaluated as part of a specific project (described in more detail in Appendix A).
| Ref. | Cost | Initial | Year 1 | Year 2 | Year 3 | Total | Present Value |
|---|---|---|---|---|---|---|---|
| Ftr | Fees to Celigo | $0 $0 | $77,000 $77,000 | $60,500 $60,500 | $88,000 $88,000 | $225,500 $225,500 | $186,116 $186,116 |
| Gtr | Implementation and ongoing management | $66,000 $66,000 | $13,200 $13,200 | $13,200 $13,200 | $13,200 $13,200 | $105,600 $105,600 | $98,826 $98,826 |
| Htr | Training costs | $0 $0 | $2,436 $2,436 | $210 $210 | $210 $210 | $2,856 $2,856 | $2,546 $2,546 |
| Total costs (risk-adjusted) | $66,000 $66,000 | $92,636 $92,636 | $73,910 $73,910 | $101,410 $101,410 | $333,956 $333,956 | $287,488 $287,488 | |
Evidence and data. The interviewees’ organizations incurred software subscription fees for the Celigo integration platform based on the platform tier in use. Platform tiers — Standard Edition, Professional Edition, and Enterprise Edition — are based on the number of endpoint apps, platform flows, and features needs. Customers can move up editions based on organizational needs.
Modeling and assumptions. For the composite organization, Forrester assumes:
might pay $0 in software subscription fees and $0 in professional services fees to Celigo in Year 1.
As ’s deployment expands to include more integration and flow projects, might pay $0 and $0 in Celigo platform license fees in Years 2 and 3, respectively.
Risks. Fees to Celigo may vary depending on the following:
Results. To account for these risks, Forrester adjusted this cost upward by 10%, yielding a three-year, risk-adjusted total PV (discounted at 10%) of $186,000.
For , this cost might have a three-year, risk-adjusted total PV of .
| Ref. | Metric | Source | Initial | Year 1 | Year 2 | Year 3 | |
|---|---|---|---|---|---|---|---|
| F1 | Subscription fees for Celigo platform | CompositeScaled for | $20,000 $20,000 | $55,000 $55,000 | $80,000 $80,000 | ||
| F2 | Celigo professional services fees | CompositeScaled for | $50,000 $50,000 | ||||
| Ft | Fees to Celigo | F1+F2 | $0 $0 | $70,000 $70,000 | $55,000 $55,000 | $80,000 $80,000 | |
| Risk adjustment | ↑10% | ||||||
| Ftr | Fees to Celigo (risk-adjusted) | $0 $0 | $77,000 $77,000 | $60,500 $60,500 | $88,000 $88,000 | ||
| Three-year total: $225,500 $225,500 | Three-year present value: $186,116 $186,116 | ||||||
Evidence and data. Interviewees described the implementation and ongoing management of the Celigo platform as a simple and relatively minimal time investment.
Modeling and assumptions. For the composite organization, Forrester assumes:
For , 0 IT FTEs might dedicate 50% of their time during the initial four-month implementation process.
For , 0 IT FTEs might dedicate 5% of their year-over-year time managing and maintaining the solution.
Risks. Implementation and ongoing management may vary depending on the following:
Results. To account for these risks, Forrester adjusted this cost upward by 10%, yielding a three-year, risk-adjusted total PV (discounted at 10%) of $99,000.
For , this cost might have a three-year, risk-adjusted total PV of .
| Ref. | Metric | Source | Initial | Year 1 | Year 2 | Year 3 | |
|---|---|---|---|---|---|---|---|
| G1 | IT FTE involved in implementation and ongoing management | CompositeScaled for | 33 | 22 | 22 | 22 | |
| G2 | Time dedicated by IT FTEs (months) | Interviews | 44 | 1212 | 1212 | 1212 | |
| G3 | Percentage of IT FTEs' time dedicated to implementation and ongoing management | Interviews | 50%50% | 5%5% | 5%5% | 5%5% | |
| G4 | Fully burdened annual salary for an IT FTE | CompositeTEI case study | $120,000 $120,000 | $120,000 $120,000 | $120,000 $120,000 | $120,000 $120,000 | |
| Gt | Implementation and ongoing management | G1*G2*G3*(G4/12 months) | $60,000 $60,000 | $12,000 $12,000 | $12,000 $12,000 | $12,000 $12,000 | |
| Risk adjustment | ↑10% | ||||||
| Gtr | Implementation and ongoing management (risk-adjusted) | $66,000 $66,000 | $13,200 $13,200 | $13,200 $13,200 | $13,200 $13,200 | ||
| Three-year total: $105,600 $105,600 | Three-year present value: $98,826 $98,826 | ||||||
Evidence and data. Interviewees’ organizations incurred minimal costs related to training for both IT and business users of the platform. According to the interviewees, it only took hours for users to become proficient using the solution.
Modeling and assumptions. For the composite organization, Forrester assumes:
For , 0 IT FTEs might be onboarded onto the Celigo platform in Year 1. It might take them 10 hours to become proficient in using the solution.
For , 0 business users might be onboarded onto the platform in Year 2 and 0 in Year 3. It might take them 5 hours each to become proficient in using the solution.
Risks. Training costs may vary depending on the following:
Results. To account for these risks, Forrester adjusted this cost upward by 5%, yielding a three-year, risk-adjusted total PV (discounted at 10%) of $2,500.
For , this cost might have a three-year, risk-adjusted total PV of .
| Ref. | Metric | Source | Initial | Year 1 | Year 2 | Year 3 |
|---|---|---|---|---|---|---|
| H1 | New IT FTEs using Celigo | CompositeScaled for | 44 | 00 | 00 | |
| H2 | Hours to proficiency | Interviews | 1010 | 1010 | 1010 | |
| H3 | Fully burdened hourly rate for an IT FTE | CompositeTEI case study | $58 $58 | $58 $58 | $58 $58 | |
| H4 | New business user FTEs using Celigo | CompositeScaled for | 00 | 11 | 11 | |
| H5 | Hours to proficiency | Interviews | 55 | 55 | 55 | |
| H6 | Fully burdened hourly rate for a business user | CompositeTEI case study | $40 $40 | $40 $40 | $40 $40 | |
| Ht | Training costs | (H1*H2*H3)+(H4*H5*H6) | $0 $0 | $2,320 $2,320 | $200 $200 | $200 $200 |
| Risk adjustment | ↑5% | |||||
| Htr | Training costs (risk-adjusted) | $0 $0 | $2,436 $2,436 | $210 $210 | $210 $210 | |
| Three-year total: $2,856 $2,856 | Three-year present value: $2,546 $2,546 | |||||
The financial results calculated in the Benefits and Costs sections can be used to determine the ROI and NPV for the composite organization’s investment. Forrester assumes a yearly discount rate of 10% for this analysis.
These risk-adjusted ROI and NPV values are determined by applying risk-adjustment factors to the unadjusted results in each Benefit and Cost section.
| Initial | Year 1 | Year 2 | Year 3 | Total | Present Value | |
|---|---|---|---|---|---|---|
| Total costs | ($66,000)($66,000) | ($92,636)($92,636) | ($73,910)($73,910) | ($101,410)($101,410) | ($333,956)($333,956) | ($287,488)($287,488) |
| Total benefits | $0 $0 | $364,626 $364,626 | $560,321 $560,321 | $791,240 $791,240 | $1,716,187 $1,716,187 | $1,389,023 $1,389,023 |
| Net benefits | ($66,000)($66,000) | $271,990 $271,990 | $486,411 $486,411 | $689,830 $689,830 | $1,382,231 $1,382,231 | $1,101,535 $1,101,535 |
| ROI | 383%383% | |||||
Total Economic Impact is a methodology developed by Forrester Research that enhances a company’s technology decision-making processes and assists vendors in communicating the value proposition of their products and services to clients. The TEI methodology helps companies demonstrate, justify, and realize the tangible value of IT initiatives to both senior management and other key business stakeholders.
Benefits represent the value delivered to the business by the product. The TEI methodology places equal weight on the measure of benefits and the measure of costs, allowing for a full examination of the effect of the technology on the entire organization.
Costs consider all expenses necessary to deliver the proposed value, or benefits, of the product. The cost category within TEI captures incremental costs over the existing environment for ongoing costs associated with the solution.
Flexibility represents the strategic value that can be obtained for some future additional investment building on top of the initial investment already made. Having the ability to capture that benefit has a PV that can be estimated.
Risks measure the uncertainty of benefit and cost estimates given: 1) the likelihood that estimates will meet original projections and 2) the likelihood that estimates will be tracked over time. TEI risk factors are based on “triangular distribution.”
The initial investment column contains costs incurred at “time 0” or at the beginning of Year 1 that are not discounted. All other cash flows are discounted using the discount rate at the end of the year. PV calculations are calculated for each total cost and benefit estimate. NPV calculations in the summary tables are the sum of the initial investment and the discounted cash flows in each year. Sums and present value calculations of the Total Benefits, Total Costs, and Cash Flow tables may not exactly add up, as some rounding may occur.
Related Forrester Research
“Announcing The Forrester Wave™: iPaaS, Q3 2023,” Forrester Research, Inc., August 22, 2023.
“Breathe New Life Into Legacy Operational Systems With Integration Best Practices,” Forrester Research, Inc., November 16, 2023.
“Integration-Platform-As-A-Service Customer Data Overview, Q4 2023,” Forrester Research, Inc., October 17, 2023.
“Leverage Integration Architecture To Resuscitate Legacy IT Systems,” Forrester Research, Inc., November 16, 2023.
“Take The First Steps Toward An Automation Fabric,” Forrester Research, Inc., May 19, 2022.
1 Source: Forrester’s Developer Survey, 2022.
2 Source: “The Integration Platform As A Service Landscape, Q2 2023,” Forrester Research, Inc., April 7, 2023.
3 Total Economic Impact is a methodology developed by Forrester Research that enhances a company’s technology decision-making processes and assists vendors in communicating the value proposition of their products and services to clients. The TEI methodology helps companies demonstrate, justify, and realize the tangible value of IT initiatives to both senior management and other key business stakeholders.
Cookie Preferences
Accept Cookies
A cookie is a small text file that a website saves on your computer or mobile
device when you visit the site. It enables the website to remember your actions (data inputs, website
navigation), so you don’t have to re-enter data when you come back to the site or browse from one page to
another.
Behavioral information collected by our web analytics vendor is used to analyze
data pertaining to visitor trends, plan website enhancements, and measure overall website effectiveness. We
may also use cookies or web beacons to help us offer you products, programs, or services that may be of
interest to you and to deliver relevant advertising. We may use third-party advertising companies to help
tailor website content to users or to serve ads on our behalf. These companies may also employ cookies and
web beacons to measure advertising effectiveness.
Please accept cookies and the collection of behavioral information to receive
full functionality and enhance your experience. If you decline cookies, some features of the website may not
function normally.
Please see our
Privacy Policy for more information.
https://mainstayadvisor.com/go/mainstay/gdpr/policy.html