Wednesday, April 28, 2010

updated simple financial template

After 2 terms of using the simple financial template in my undergraduate class on entrepreneurship (STRE2010 at UNSW), I think I have ironed out all the wrinkles, removed unnecessary bells and whistles and kept only the good stuff. HERE IT IS: simple-template.xlsx

The "statements" tab have almost powerpoint-ready overviews of the income statement, balance sheet and cashflow statement. The comments on the margins help guide users through the necessary entries to customize the model.

The "reality check" tab provides some basic ratio analysis to breakdown where the major expenditures are and helps assess if areas of the forecasted growth make sense.

The "valuation" tab helps come up with a valuation that's better than one picked out of thin air. Nonetheless, for start-ups with no running history, this can be a major challenge and point of negotiation when dealing with more financial-return minded investors.

I'll leave it up to you to create visual charts that do a better job of emphasizing the numbers relevant to your opportunity.

No comments:

Post a Comment