IT investments: Calculate the real value

The most common way to measure an IT project's return of investment is the Net Present Value (NPV) calculation. But remember to account for risks when doing such cash flow analyses.

As we approach the fourth quarter, many application development managers are beginning to plan for 2005 projects. The first step in this process is soliciting input from business and IT partners to generate a list of potential project candidates. In most organisations, there is a never-ending reservoir of new ideas for generating value for the organisation.

This usually leads to a wealth of project requests, of which executives will only approve a few.

Which has good ROI?
Determining a project's return on investment can be a daunting task. This process usually considers financial investment and operational costs vs. expected revenues. A key consideration is the analysis of cash flow for the project over time.

There are many formulas to do this, but the most common one is the Net Present Value (NPV) calculation. NPV is the value of future free cash flows discounted back to the present by applying a percentage discount rate. If NPV is positive, then the project will return value. If the NPV is negative, then the project will result in a financial loss.


Project scrubbing
The process of reducing the project wish list begins by performing enough analysis of each candidate to answer at least the following two fundamental questions:

  • Does the project align with strategic or tactical goals?
  • What will be the return on investment?

    Free cash flow is total income minus all outlays to create that income. The discount rate is based on the company's cost of capital and varies depending on risk. Calculating the cost of capital for an organisation is a complex analysis of the organisation's current financial situation, which includes such factors as available funds (i.e., cash), capital commitments, operational costs, overall assets, and outstanding debts.

    The corporation's finance department determines this calculation, but it usually approximates the percent of return the organisation could receive on long-term investments at no risk (e.g., Federal Reserve Notes). Most organisations add a certain value to this rate to determine the organisation's "desired rate of return" for the project investment, or the desired internal rate of return (IRR).

    Then, organisations adjust the rate for risk. Organisations need to consider business and financial risk (both of which raise the discount rate). Business risk includes factors such as technology fit, likelihood of adverse future events, market acceptance, competition, and project complexity. Financial risk includes items such as debt vs. equity financing, shareholder commitments, and prevailing interest rates. The following example illustrates these processes.

    VoIP example
    Consider a new emerging technology project to do voice over IP within your organisation. Your company's finance department determines a minimum discount rate of return of 10 percent. Your organisation's executive committee determines that all projects must return a rate of at least 5 percent above the discount rate. (This is mainly due to a prevailing interest rate of 3.5 percent.)

    The organisation's good financial year allows available equity (i.e., zero debt financing) to fund most project expenses. Additionally, you decide that this project has significant business risks due to the introduction of a new and significant technology. Therefore, you calculate the project discount rate as follows:

    Rate = 15 percent (desired rate of return) + 10 percent (due to high business risk) + 3 percent (due to low financial risk), or 28 percent >

    Next, you calculate that the initial investment is $100K. You calculate a net cash inflow of $20K for each year and do a calculation for five years.

    By using 28 percent as the discount rate and the formula for NPV--NPV = - initial investment + summation of periods 1 thru n of (net cash flow in year i/(1+discount rate) to the ith power), or $640.12--here's the equation you would use:

    NPV = -$50,000 + ($20,000/(1+.28)E1) + ($20,000/(1+.28)E2) +($20,000/(1+.28)E3) +($20,000/(1+.28)E4) +($20,000/(1+.28)E5)

    This project will return a positive return (albeit a very low one) over five years.

    But should your organisation pursue this project?

    Based on the NPV alone, this project appears to be on the border. If risk increases, the project could easily become a monetary loser. Your company's decision would ultimately need to consider other non-tangible values in the project returns.

    biography
    Scott Withrow has more than 20 years of IT experience, including IT management, Web development management, and internal consulting application analysis.

  • Advertisement

    Talkback 0 comments

    Sponsored content

    Power Centre - Content from our premier sponsors

    Blogs

    • Chris Duckett Get extensions going in Firefox, redux
      Previously on Null Pointer we looked at getting extensions working in Firefox betas, and that was great until the fine folks at Firefox changed their minds.
    • Array How reliable is IP telephony?
      Have you ever heard a weird kind of hissing, crackling or popping noise when calling someone on an IP telephony line? How rare is the phenomenon these days?
    • Array Forget the NBN, 100Mbps is already here
      Telstra and TransACT will shortly begin offering 100Mbps broadband to many customers. By moving early, the companies have not only raised the bar for Australia's broadband services, but thrown down a challenge to a government that now faces increased pressure to deliver the NBN as promised.
    • More blogs »

    Tags

    Back to top

    Featured