We all have different ways of planning and calculating our adsense earnings, i've added mine below so you can all see, i've calculated a modest CTR of 1.5% with an average CPC of $0.05 for my niche - although the first few months I had a higher CTR and CPC. I'm using modest figures to forecast a 12 month plan, I used the following figures as indication for 12 months whilst I build quality traffic to my website. I'll post my earnings very shortly... How do you calculate or plan yours? Also, I'd appreciate feedback or constructive criticism.
i use a crystal ball and some tea-leaves... they are probably about as accurate as your spreadsheet will be.. ..the moral of the story is that you can't plan your Adsense earnings..