How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.