I've designed a nice spreadsheet that I use for pay per click campaigns. I use it for affiliate products and physical products as well. It gives you daily, weekly, yearly, monthly and yearly bottom line figures based on a few inputs that relate to your PPC campaigns and business. Don't get burned with PPC. Share your thoughts: www.truewebmoney.com/Downloads/PPC-ROI-Calculator.xls