Mathematics Stack Exchange is a question and answer site for people studying math at any level and professionals in related fields. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am creating a spreadsheet to calculate Adword formulas and I am stuck in how to calculate the Monthly Net Income for each keyword. I have created a formula which calculates it but can't figure out how to limit the Monthly Budget.

The formula I've created is this one:

Monthly Net Income = ( DailyClicks x ConversionRate x SaleProfit) - ( CPC x DailyClicks )

There is an example of the formula in the file which is a Google Spreadsheet publicly available here:

(you can create your own copy going to File > Make a copy...)

I am releasing this set of tools as Public Domain so feel free to use it :)

Any help is much appreciated!

share|cite|improve this question
up vote 3 down vote accepted

the formula as presented is not calculating the monthly net income, it is calculating the daily net income

assuming 30 days/month, divide the monthly budget by 30 to get a daily budget

then limit the DailyClicks to be no more than DailyBudget / CPC

share|cite|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.