Microsoft Excel Business Software -- Advertising Return on Investment Calculator
Determine the ROI of your Internet Advertising
Have your efforts in online advertising been paying off? How well? Can you put a number on that? A good way to determine whether your ads are paying off is by calculating your Return On Investment. This spreadsheet has been designed for use in evaluating the ROI of your ads, one at a time. Using this same Excel program, you can also compare the results of up to five ads, side-by-side.
Differences between the Free and $5 versions of the spreadsheet:
The free download is fully, 100% functional but the cells with the formulas are locked and you can’t change the design or copy the formulas. The paid version does not have these restrictions. Click Pay Now for the unlocked version, or download the free version below.
Buy Now for $5 U.S.
Free Download
System Requirements: Microsoft Excel 97 or later.
To download: Enter your email address to receive the download link. You’ll receive only one email. There are no mailing lists, etc.
What is the Definition of ROI? ROI, or Return On Investment, tells you how much money you’re getting back, as a percentage, based on the amount you’re spending. If, for each dollar of advertising, you sell a product for which there is a $2.00 profit, (before the cost of advertising,) your ROI is 100%.
Instructions
Fill in the Blank (white) Fields. Gross Receipts is the total amount of sales you’ve made based on the ad, including shipping but not including sales tax. Cost of Goods Sold is your cost of providing that product to the customer, including buying the product yourself, shipping and handling costs, etc.
ROI is shown in the bottom cell. The break-even point is 0%. Positive numbers represent a gain, and negative numbers represent a loss.