How to Use Excel to Calculate the ROI on a Product. ... Allen Bethea has written articles on programming, web design,operating systems and computer hardware since 2002.