ROI calculator

Enter what you invested and what it returned to see your ROI and the profit it made.

Enter both amounts to see your ROI.

Everything is worked out in your browser, and nothing you type is sent anywhere.

What the result means

ROI is the profit on an investment as a share of what it cost. A 30% ROI means every 100 put in came back as 130. For a marketing campaign, enter the gross profit it brought in as the amount returned. Using revenue makes the campaign look better than it is.

The formula

ROI = (amount returned − amount invested) ÷ amount invested × 100

A worked example

A campaign costs 5,000.00 and brings back 6,500.00. That leaves a profit of 1,500.00, and 1,500.00 ÷ 5,000.00 × 100 gives an ROI of 30.00%.

What ROI is and how to calculate it

Keep your Google Ads, Meta Ads and Shopify figures current in Google Sheets, refreshed on a schedule.

Start free trial

30 days of Plus, free from sign-up. No card needed.

Sign in with Google or a work or school Microsoft account.

Add to Google Sheets

Prefer to stay in Google Sheets? Add the add-on and start from the Extensions menu.