Monday, August 9th, 2010...11:58 pm

Digital Start-Up Pro Forma Financial Model

Jump to Comments

During my senior year of college, I created a college basketball website called Littyhoops.com. This was back in the dark ages before blogs were popular so it took a considerable amount of effort to get the website up and running and then maintain it. I learned a ton about the web from the experience. One thing that quickly became apparent was that it’s damn hard to make money off of a website unless you are super focused on driving revenue.

Recently, I’ve been helping a few friends think through there digital business ideas. One way to more fully comprehend a business opportunity is to create a simple pro forma income statement or business model. It’s practically impossible to predict what is going to happen with a new business so a model is used more for a framework to understand key drivers and help make informed decisions.

Most digital businesses derive revenue through E-Commerce (including affiliate fees), subscription products, or advertising revenue. Each of these revenue streams has a few key metrics that help project revenue. Once these drivers are recognized it helps clarify what exactly needs to happen to be successful. For example, digital advertising revenue is a product of visits, page views and CPM rate. A business model also provides a realistic projection of how long, and how much money, it will take to reach certain milestones (most notable profitable). This allows for better planning and cash flow management which is essential in the early stages before a business is profitable.

I created a very simple financial model template that can be used to project website revenue. While this model might not hold up in a meeting with a venture capitalist, it gets to the fundamentals of any website.

If you are in the process of creating a website, or are even thinking about it, play around with this and hit me up if you want to chat through it.


START UP FINANCIAL MODEL

Right click and “save as” the above link to download the Excel spreadsheet.

  • Mrshafrir

    Yo Litty –

    Two thoughts:

    1) Might be a bit complex for this, but ideally your subscription rates and ecommerce conversion is increasing as you test and optimize marketing channels and landing pages.

    2) Do your marketing costs and site visits match up? Will $200 in spend for month 1 drive the ~12,000 visits you're assuming in your model?

  • http://blog.littyhoops.com Litty

    1) Yeah, i agree. that's why i put the subscription and conversion rate in each month instead of making it a constant. It should improve.

    2) Nah, all numbers are just dummy numbers to make it simply. Formulas work though so easy to switch up.

    Thanks for feedback bud.