Publication number: ELQ-70747-1
View all versions & Certificate
Venture Capital Valuation Method Excel Model
A simple excel venture capital valuation model to understand how to value a startup at investment stage.
The Venture Capital Method assumes that a form will undertake an Initial Public Offering (IPO) at some point in the future. The future value of the firm is determined by multiplying the earnings of the firm in the year of the IPO by the expected price/earnings (P/E) ratio that the market will support. (The long-run P/E ration of NYSE stocks is about 15.) This provides the expected future value of the firm.
The present value of the firm is then calculated using a risk adjusted discount rate. Discount rates of 50 to 100% (and more) are frequently used in valuing start-up businesses to capture the inherently risky nature of new ventures. Similarly, venture capitalists frequently demand an Internal Rate of Return (IRR) of 100% (or more) in order to justify investing in a risky startup. (An IRR of 100% is equivalent to doubling an investment every year).
-> Only enter data into green-shaded cells with green type font
-> All valuation calculations fall out from these inputs
by Frank Moyes and Stephen Lawrence
Deming Center for Entrepreneurship
Graduate School fo Business Administration
University of Colorado
This business tool includes
1 Excel Venture Capital Valuation Model
Prof. Stephen Lawrence offers you this business tool for free!
download for free
Add to bookmarks
- No review yet!
People using this tool also downloaded
Startup Valuation VC Method + excel SpreadsheetExcel template made to understand how VCs value the money that will be used to invest in a startupvaluationentrepreneurshipstartupsventure capitalraising capitalinvestingfundingvc4,102 remove_red_eye
The Berkus Method- Valuing the Early Stage InvestmentThe Updated Berkus Method for Early Stage Startup Financial Valuationvaluationstartupventure capitalmethodonlineberkusearlystage277 remove_red_eyefreeby Dave Berkus
How to value a SaaS Business in 2017SaaS is a unique and growing industry and there are special consideration to be made in the valuation process.financevaluationventure capitalsaasinvestingexits126 remove_red_eyefreeby Thomas Smale
Cap Table TemplateThis Cap Table template perfect for first-time entrepreneurs to list a company's securities.financestartupinvestorsventure capitalraising capitalcap tableshareholdersfounderscontrol397 remove_red_eye
Note Discount Cap WorksheetDiscount or cap? A spreadsheet that shows what happens when a note converts.financevaluationdiscountventure capitalraising capitalseries aoption poolcapconvertible noteterms209 remove_red_eyefreeby Raji Bedi
The Best Startup Investor Pitch Deck & How to Present to Angels & Venture CapitalistsThe best guide to creating a pitch deck, with tips and modelsstartupventure capitalraising capitalrevenue modelpitch deckslideshowexpense modelangels319 remove_red_eye
Marketplace KPI Excel DashboardDesigned to evaluate a marketplace organisation's performance.performancestartupventure capitaldashboardkpientrepreneurtemplatevcfreedownloadmarketplace1,850 remove_red_eyefreeby Version One
Internet Business Financial Model SIBM - SpartinaManage your Cash, Increase Startup Revenue & Grow your Profitsrevenuefinancefinancial modelstartupentrepreneurshipventure capitalcashinternetprofitsbusiness modelling973 remove_red_eyefreeby David Hehman
Stock Analysis Excel Model (Ver. 3.0) - Safal NiveshakA 16 tab Stock Analysis Excel Model Template to analyse the past performance of a company and determine its valuation.analysisvaluationinvestingstock analysisperformance analysisfinancial marketsexpected returns934 remove_red_eye
Startup Excel ModelA startup financial model that can be sent to a Venture Capital, Private Equity Firm or Hedge Fund.financecash flowprivate equityfinancial modelstartupfundraisingventure capitalassumptionscapexheadcount9,671 remove_red_eye
Any questions on Venture Capital Valuation Method Excel Model?
The user community and author are here to help. Go ahead!