Is my keyword analysis correct or am i way off

I am new (only built two wordpress sites) that use some SEO. But recently I really want to tackle keyword searching. Below are steps i am taking and looking for feedback before I dive into purchasing domain names:

Step:
1. Come up with list of problems that I would like solved or things i am passionate about.
2. Take that list to Market Samurai and plug them in. Take whats left after MS filters and move onto to Google Adwords keyword search tool.
3. Google Adwords Keyword Search Tool - plug in my keywords and select "exact" match on left hand side to get an estimate of how many people are searching for that keyword/phrase.
4. Google insights - plug keyword in again to see what direction the keyword is heading in its cycle (is it mature and declining) or is it "breakingout" and trending up. Also get look at who this target market is (sex, age, location, etc)
5. Excel - plug in the numbers. This is where i might be missing something. Here is what i set up in excel
*Keyword
*Global/local results (from google keyword tool)
* Results (from putting "keyword" to see how many sites link this KW)
* Intitle - determine how many use KW in title of article
* Inurl - determine how many sites have KW in URL
* Cocktail - includes: Intitle, Inurl & anchor text to get picture of seo strength.
* CPC - i am really limited on CPC and PPC termonology but Google gives me CPC so I use it

I then take Global/local results and multiply that by 40% (that represents highest amount of clicks i could get by being number 1 ranked in SERP.

I then take that amount (global x .40) and multiply that number by CPC to get potential money i could make from advertising?

Am i headed in right direction?

Thanks
Carl