Webseries and Internet Television

EDIT: I have updated the spreadsheet. Please read my post here: http://webseries.posterous.com/forecast-the-value-of-your-web-series-rev-2

Have you ever wondered how much your webseries will earn you back? I created a forecast model excel spreadsheet a few months ago to figure out how much we could pay for the license of a particular series. Attached to this post is a simplified version that takes a CPM and the initial views you estimate for the first episode of your show, and then follows a specific model to give you back the net present value. I am releasing it under a creative commons license to encourage tweaking and sharing of communal wisdom.

If you just want to take a peek, you can see it as a website at http://spreadsheets.google.com/pub?key=rdDomqxl-I_SR8enii-GWvw&single=true&gid=0&output=html