what is the formula for roi in excel?
To calculate ROI you divide the earnings you made from an investment by the amount you invested. For instance, if your company spends $100,000 purchasing a product that earns you an additional $20,000 after a year, your ROI is 0.2 or 20 percent.