Totally with you. Would love to build out several different cost/revenue models including one completely based on web site visits and paid customer conversion rate. Sprinkle in some correlation with marketing spend and you've got something passable for a B2C company.

One of our local tech mentors here in Des Moines released a free Excel file for these sorts of projections (an accompanying book to explain the models, etc is also available from Amazon).

You can download here: http://www.startupmodels.com/download/

I haven't used it myself but I know that it has helped quite a few companies work through their financial projections around here. It's at least a decent starting point.

(More info: http://www.siliconprairienews.com/2011/10/startup-models-see... )

Out of curiosity, what would be the major changes required?

Definitely unit economics and everything that needs to go above the line. Would be KILLER to have those.

If you have an example worksheet I'd love to see it. I've spent my last 7 years in B2B SaaS so have plenty of the tiered SKU models for reference.

Mostly the accounting for COGS