ROI Calculation in Excel



A quick example of how ROI for a range of marketing campaigns could be calculated in Excel. Important note: "Return" could be calculated using a range of measures, including gross revenue/sales (in this simplistic example), gross margin, etc. It is often times left up to the individual performing the calculation to decide which figures are most prudent to use in calculating the actual return. Want to take your basic Excel skills to the next level? Take our online course and start impressing others: http://www.spreadsheetclinic.com/#!online-training/ce09

Comments

  1. Perfect. Thanks a lot!
  2. This ignores any sales "before" the campaign runs. It assumes that the sales mentioned are 100% because of the campaign which probably is not correct. More accurate will be if instead of Sales, "up lift" in sales is used I.e. New sales - Existing sales
  3. This is so simple and well done, Thanks
  4. What video shows how you created the chart for this example?
  5. thank you!


Additional Information:

Visibility: 68104

Duration: 5m 15s

Rating: 68