Ready to Use Financial Models Information Technology Venture Capital Valuations Interactive Excel Spreadsheet Used by Top It Vcs

The Information Technology Venture Capital Financial Model is an interactive Excel spreadsheet that features a user-friendly, step-by-step guide through a technology-focused valuation model. Developed by acclaimed venture capitalists Praveen Gupta of CDIB Ventures and Jon Staenberg of Rustic Canyon Partners, the financial models provide an unprecedented look into the world of IT Venture Capital and the methodologies behind valuation. The Information Technology Venture Capital Financial Model features both an ?ownership? and ?financial ratios? worksheet, which provide color-coded in-depth directions for easy usage. 1) Desired Ownership: This scenario is typically applicable to pre-revenue companies. Many venture capitalists have an internal strategy of owning a certain minimum percentage of a company. Typically, this minimum is 15-20% post-funding in early-stage companies. Once the investor has made the decision to invest, they have estimated the exit potential and returns for their investment. Accordingly, they have also determined the amount of investment to be made initially to achieve the desired returns. The investor will typically use the amount of investment and desired ownership to determine the valuation of a private company in such a scenario. The worksheet titled "Ownership" provides a valuation computation tool for this scenario. Follow the directions within the worksheet. 2) Financial Ratios: This scenario is typically applied to revenue-stage companies. The first scenario outlined above may still be applicable either entirely or partially. A public company is typically valued in multiple ways using various financial ratios. These include Price to Earnings (PE), Price to Sales (PS), Discounted Cash Flow (DCF), Shareholder Equity, or a combination of the four. Many of these ratios are not directly applicable to a private company due to lack of sufficient history and early revenue growth stage. PS and PE are most applicable to companies in the early- revenue growth stage. PE is generally applicable only in very late-stage companies with a significant revenue and profitability history. Private-company investors use the PS ratio as a guide most of the time in valuing a revenue-stage company. The worksheet titled "Financial Ratios" provides a valuation computation tool for this scenario using PS and PE ratios. Simply insert the cd-rom, open the spreadsheet, and input your data. The model will calculate and generate the valuation for you. The model can be modified to incorporate more complicated components if you choose. In addition, a report entitled Valuation and the IT Industry: An Overview, is embedded in the model. This exclusive report shares the best practices of one of IT's most successful venture capitalists with respect to how he calculates information-technology valuations. Within these spreadsheets lies a wealth of critical information which every entrepreneur, venture capitalist, and executive should have at their fingertips.Gupta, Praveen is the author of 'Ready to Use Financial Models Information Technology Venture Capital Valuations Interactive Excel Spreadsheet Used by Top It Vcs', published 2005 under ISBN 9781597010429 and ISBN 1597010421.