I decided to create a quick and easy Pay-per-click calculator.  By experimenting with different variables, you’ll be able to see the range of possible outcomes.  There are several variables you’ll need to input:

Cost per click – this allows you to see different profitibility scenarios based on average CPC.

Total Clicks – adjust this, along with your CPC, and you’ll see a monthly spend.  I need to recreate this spreadsheet with Budget as the input, automatically showing clicks, as another way to use the sheet.

Percentage of Users Buy – Here is another place you’ll just need to make assumptions.

Average Total Purchase Amount – how much does the average user spend on this website.

See the attached Excel spreadsheet:  Pay-per-click estimation worksheet