Docstoc

spreadsheet.)

Document Sample
spreadsheet.) Powered By Docstoc
					Assumptions Table Item Rev proj 60 months EBIT PROJ 60 months EBIT % COMP EBIT NOW EBIT MULT COMPS NOW Amount to be invested Investor Required Return (IRR) Years until Company Harvest Investor IRR Multiple Cash Result Reqd at this IRR Range of EBIT Results Plan reduced to Plan reduced to Plan reduced to Range of Harvest Multiples (Consider reducing multiple as EBIT declines) EBIT DECLINES TO EBIT DECLINES TO EBIT DECLINES TO valuations at each multiple range (reduced multiple times reduced EBIT)

Source Result $91,200,000 $ 15,504,000.00 17% 16% 7.65 $2,000,000 50% 5.00 7.59 $ 15,187,500 from plan from plan from plan from market from market from plan from Investor from plan derived from IRR Calc derived from IRR Calc Resulting EBIT $ 15,504,000.00 $ 13,178,400.00 $ 7,907,040.00 $ 2,372,112.00

2500000

From plan 85% 60% 30%

85% 60% 30%

Estimate of Reduced Multiple-not mathematically calcualted 6.50 5.50 4.50

7.65 6.50 5.50 4.50

$ $ $ $

118,605,600 85,659,600 51,163,200 20,930,400

(Calculate percent ownership required in each case for Investor to meet IRR target) $ $ $ $ Average ownership required Resultant pre money Value Consider the market using current comps, adjust to net after options

Valuation 118,605,600 85,659,600 51,163,200 20,930,400

Ownership Required for IRR Target 12.8% 17.7% 29.7% 72.6% 33.2%

$4,024,938

$3,500,000

Term-sheet calculations January, 2010 PART TWO: Consider the effect of terms at various sale scenarios Assumptions Post money valn Investor ownership Founder ownership Dividend non cum Liquidn Preference Participation Years to sale Source derived derived derived from terms- assume annual from terms from terms - ratable after preference from prior assumptions

$5,500,000 36.4% 63.6% 8% 1 1 5

Result (no additional financing or debt) Sell at ######## from C27:C30 on prior page Investor 800,000 $2,000,000 $2,000,000 $ 4,800,000 ####### Founder $0 $0 $0 ### ####### 63.6%

Dividend non cum Preference Participation Subtotal Balance of Proceeds Investor Multiple Investor IRR

$

######## 20.69 144%

(c) Tim Keane

Term-sheet calculations January, 2010 IRR Calculation 0 1 2 3 4 5 ($2,000,000) 0 0 0 0 ########

(c) Tim Keane