Both Sides of the Table

MAY 19, 2018

Or if you’re a VC raising from LPs you have to list all of your deals, your investment value, your carrying value, your multiples, your IRRs, TVPIs, DPIs, etc along with net cashflows plus your previous LPAs. Investors love to be able to see what you told them in forecasts in prior years and then compare with how you actually performed.

Cap Table 336

Cap Table Due Diligence Forecast Churn Rate 336

Tim Keane

JANUARY 12, 2010

If you look at the spreadsheet, you will see that the “Required Rate of Return” is expressed as an IRR.   Internal Rates of Return naturally compound, so a 50% IRR is 7.59   (If you plug in an IRR of 58.5%   Internal Rates of Return naturally compound, so a 50% IRR is 7.59 times at 5 years and 11.39

Term Sheet 68

Term Sheet Valuation Dividend Liquidation Preference 68

Occam's Razor

OCTOBER 14, 2014

If you want to learn about how to do simple forecasting and trend analysis, please see the official forecast function in Excel post on the Microsoft website, and this handy tutorial on trend lines and forecasting in excel. The best way is to segment these metrics and then set individual targets for your most important segments.

Analytics 133

Analytics Vertical Metrics Web 133