Webseries and Internet Television

Forecast the value of your web series, rev. 2

(download)

 

To get the .xls you just have to click on the 'download' link below the Scribd frame. 

I updated the spreadsheet to look a little nicer and have a slightly different default behavior for expected popularity of a web series.
The top part looks more like a dashboard, with a couple of graphics comparing pessimistic, probable and optimistic models. Please feel free to use this new version and tweak it to your satisfaction.

My original post:

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.
To Posterous, Love Metalab