Assignment #2 (8 points) Jim Jacobs is negotiating with a Venture Capital Fund for $4 MIL financing for his new venture. Jim is the sole founder and owns 100% of the company's equity. He is adamant that he must keep a 60% interest in the company after external capital is raised. A VC investor is willing to accept a 40% interest and believes an 8X return in NLT 5 years will generate an appropriate return for the risk associated with this investment. The company has just begun generating revenue, and it does not expect to generate positive Cash Flow (CF) until Year 3. Discreet Cash Flow projections prepared from pro forma financial statements are presented below. After the discreet forecasting period (Yr 4), Jim and the VC expect CFs to grow by 2.5% per year in perpetuity. A. What imputed rate of return demanded by the investor? (1) Imputed Rate of Return =((FinalValue/InitialValue)(1/Numberofyears)1)100% IROR=((8)(1/5)1)100%IROR=51.57% B. Given that required rate of return, what value would the VCs give to the forecasted Discreet Cash Flows above? (1) PV of Yearly Cash Flows = Cash Flow/( 1+51.57%) Year# Year 1=2,800,000/(1+.5157)1 Year 1=1,847,331 Year 2=1,450,000/(1+.5157)2 Year 2=-631,163 Year 3=3.150.000/(1+.5157)3 B. Given that required rate of return, what value would the VCs give to the forecasted Discreet Cash Flows above? (1) PV of Yearly Cash Flows = Cash Flow/(1+51.57\%)^Year# Year 1=2,800,000/(1+.5157)1 Year 1=1,847,331 Year 2=1,450,000/(1+.5157)2 Year 2=-631,163 Year 3=3,150,000/(1+.5157)3 Year 3=904,630 Year 4=10,000,000/(1+.5157)4 Year 4=1,894,729 C. What is the firm's projected Terminal Value (TV)? (2) Terminal Value = Year 5 Cash Flow/(Required Return Perpetual Growth Rate ) Terminal Value = Year 4 Cash Flow* (1+ Perpetual Growth Rate ) Terminal Value =10,000,000(1+2.5%)=$10,250,000 Terminal Value =$10,250,000/(.51570.025) C. What is the firm's projected Terminal Value (TV)? (2) Terminal Value = Year 5 Cash Flow/(Required Return Perpetual Growth Rate ) Terminal Value = Year 4 Cash Flow (1+ Perpetual Growth Rate ) Terminal Value =10,000,000(1+2.5%)=$10,250,000 Terminal Value =$10,250,000/(.51570.025) Terminal Value =$20,888,527 D. What is the Total Present Value of the firm? (1) (be consistent) Total Present Value = Terminal Value + Total Present Value of Discrete Year Cash Flows Total Present Value of Discrete Year Cash Flows =1,847,331+631,163+904,630+ 1,894,729=320,865 Total Present Value =$20,888,527+320,865 Total Present Value =21,209,392 OneDr D. What is the Total Present Value of the firm? (1) (be consistent) Total Present Value = Terminal Value + Total Present Value of Discrete Year Cash Flows Total Present Value of Discrete Year Cash Flows =1,847,331+631,163+904,630+ 1,894,729=320,865 Total Present Value =$20,888,527+320,865 Total Present Value =21,209,392 E. At that valuation; how much equity will Jacobs have to give up to raise $4 million on a post money basis? (1) F. Given these requirements and projections, what must the company be worth in Year (4) not Present Value? (2) Assignment #2 (8 points) Jim Jacobs is negotiating with a Venture Capital Fund for $4 MIL financing for his new venture. Jim is the sole founder and owns 100% of the company's equity. He is adamant that he must keep a 60% interest in the company after external capital is raised. A VC investor is willing to accept a 40% interest and believes an 8X return in NLT 5 years will generate an appropriate return for the risk associated with this investment. The company has just begun generating revenue, and it does not expect to generate positive Cash Flow (CF) until Year 3. Discreet Cash Flow projections prepared from pro forma financial statements are presented below. After the discreet forecasting period (Yr 4), Jim and the VC expect CFs to grow by 2.5% per year in perpetuity. A. What imputed rate of return demanded by the investor? (1) Imputed Rate of Return =((FinalValue/InitialValue)(1/Numberofyears)1)100% IROR=((8)(1/5)1)100%IROR=51.57% B. Given that required rate of return, what value would the VCs give to the forecasted Discreet Cash Flows above? (1) PV of Yearly Cash Flows = Cash Flow/( 1+51.57%) Year# Year 1=2,800,000/(1+.5157)1 Year 1=1,847,331 Year 2=1,450,000/(1+.5157)2 Year 2=-631,163 Year 3=3.150.000/(1+.5157)3 B. Given that required rate of return, what value would the VCs give to the forecasted Discreet Cash Flows above? (1) PV of Yearly Cash Flows = Cash Flow/(1+51.57\%)^Year# Year 1=2,800,000/(1+.5157)1 Year 1=1,847,331 Year 2=1,450,000/(1+.5157)2 Year 2=-631,163 Year 3=3,150,000/(1+.5157)3 Year 3=904,630 Year 4=10,000,000/(1+.5157)4 Year 4=1,894,729 C. What is the firm's projected Terminal Value (TV)? (2) Terminal Value = Year 5 Cash Flow/(Required Return Perpetual Growth Rate ) Terminal Value = Year 4 Cash Flow* (1+ Perpetual Growth Rate ) Terminal Value =10,000,000(1+2.5%)=$10,250,000 Terminal Value =$10,250,000/(.51570.025) C. What is the firm's projected Terminal Value (TV)? (2) Terminal Value = Year 5 Cash Flow/(Required Return Perpetual Growth Rate ) Terminal Value = Year 4 Cash Flow (1+ Perpetual Growth Rate ) Terminal Value =10,000,000(1+2.5%)=$10,250,000 Terminal Value =$10,250,000/(.51570.025) Terminal Value =$20,888,527 D. What is the Total Present Value of the firm? (1) (be consistent) Total Present Value = Terminal Value + Total Present Value of Discrete Year Cash Flows Total Present Value of Discrete Year Cash Flows =1,847,331+631,163+904,630+ 1,894,729=320,865 Total Present Value =$20,888,527+320,865 Total Present Value =21,209,392 OneDr D. What is the Total Present Value of the firm? (1) (be consistent) Total Present Value = Terminal Value + Total Present Value of Discrete Year Cash Flows Total Present Value of Discrete Year Cash Flows =1,847,331+631,163+904,630+ 1,894,729=320,865 Total Present Value =$20,888,527+320,865 Total Present Value =21,209,392 E. At that valuation; how much equity will Jacobs have to give up to raise $4 million on a post money basis? (1) F. Given these requirements and projections, what must the company be worth in Year (4) not Present Value? (2)