MS Access Databases

ROI (Return on Investment) Calculator

The ROI on Advertising Calculator allows you to compare up to five ads side-by-side. Instructions for use are listed below the calculator. Be sure to print your results before you leave this page. The calculations are performed within your browser and no information is stored on our servers.

Instructions for use

You can perform up to five basic ROI calculations within the calculator for a side-by-side comparison.

Ad Name: The name of your ad (Ad #1, for example).

Gross Receipts: The total amount of money taken in as a result of your advertisement.

Cost of Goods Sold: Your total cost of the product you are selling, including shipping, etc. The cost of your ad is entered below, so don’t include it here.

Gross Profit: This is calculated for you. Does not include ad cost.

Ad Cost: The amount of money you spent on the ad.

Net Profit: Automatically calculated as gross profit minus the ad cost.

ROI: Automatically calculated as follows: ((Gross Profit – Ad Cost) / Ad Cost) * 100.

Please Note: What is being calculated is the ROI for your advertising. Gross receipts and costs of goods sold are used to calculate Gross Profit for the calculation but are not otherwise taken into account. Please refer to the previous post in this series for another example on how to calculate ROI.

Mike

('’)