No Image Available

Seb Anthony

Read more from Seb Anthony

googletag.cmd.push(function() { googletag.display(‘div-gpt-ad-1705321608055-0’); });

Calculating ROI



2009 - £52865.50
2010 - £58152.05
2011 - £64000.25

Outlay costs
option (a) £200,000
option (b) £100,000

I am using the formula

(benefits - costs)/costs x 100

resulting in a) -12.48% and b) 75.01%

Addtionally, I'm looking at payback time using the formuala

costs / benefits

For the benefits should I be using the total benefits over the 3 year period?

Does anyone know an easy way to turn this figure into years / months?

Thank you for any guidance from a frazzled brain

Elizabeth Turpin

2 Responses

  1. RoI calculation
    As your figures are forward projections I am assuming that this is in fact investment appraisal (IA) rather than RoI. I’m an advocate of IA but am skeptical about translating predictive benefits to the penny three years ahead. Even predicting costs over that period can only be an estimate.
    But, to answer your questions, if the investment delivers a benefit over three years, and that benefit can be confidently predicted, and the costs are also the three year costs, then all that is fine.
    A lot can happen over three years – for example, staff turnover may mean you lose some benefits and need to incur further costs to train their replacements. Proceedures can change, work performance can go up or down due to other factors, and the value of the benefits can change depending on how critical they are to the business and how you calculated them.
    In most businesses it would be sufficient to make the case that the initial outlay is £100k and the likely payback is around two years. Benefits are likely to be ongoing, so that investment will keep adding value for at least three years to be worth about 50% more than the initial outlay.
    If this is an academic exercise (it looks like it might be, and if so it is poorly conceived), payback on option b, in theory, is 0.9 of a year or 47 weeks if the costs and benefits are evenly distributed throughout the year.
    What a brain frazzlinly pointless exercise!


Get the latest from TrainingZone.

Elevate your L&D expertise by subscribing to TrainingZone’s newsletter! Get curated insights, premium reports, and event updates from industry leaders.


Thank you!