Please provide the workings for the enclosed. Thank you.

CASS BUSINESS SCHOOL MSc Investment Management Programme Alternative Investments - Private Equity Module 2017 Term 2 Problem Set 1 - Valuing and Structuring Venture Capital Investments This problem set is designed to help you understand the way venture capital deals are valued and structured. In addition to the lecture presentation, you will find A Note on Pre-Money and Post-Money Valuation (A&B) helpful in completing the solutions. The last two questions relate to the case study, Centex Telemanagement, Inc (A). The questions relate to typical issues that arise during venture capital financing rounds. In addition to giving you practice with the technical aspects of valuing and structuring venture capital financings, they will give you an appreciation for the issues that arise between entrepreneurial management teams and venture capital funds. Questions 1-15 can be answered using only a simple calculator. Question 16 will require either a financial calculator or a spreadsheet to calculate IRRs. The answers to the questions are simple numbers, percentages, or in one or two cases, very short word answers. Solutions to the problem set will be explained and questions answered at the beginning of Class Session 2 and worked out solutions posted in Moodle. Please submit your answers to Moodle using the Answer Sheet provided in Moodle on or before 2200 Wednesday 8 March. In addition, submit your workings. Please do not feel you must submit typed or particularly neat and tidy workings - a PDF copy of your handwritten workings is perfectly acceptable. If you have any questions or problems understanding the questions, please do not hesitate to email me (em@palladian.co.uk). TARGET RETURN APPROACH Excite Ltd is a new Internet-based company that streams sports films to its customers. Excite has been in business for 20 months and already has paying customers and revenue. Nigel Smith, the founder, has financed Excite so far by using his own financial resources and cash flow from company sales. However, he has run out of personal funds and realises he needs substantial new funding in order to develop the business properly. Nigel has approached your venture capital fund for backing. Based on his new business plan, Nigel believes he needs 5 million, which he thinks will be enough funding to achieve Net Income (profit after taxes) of 5 million by the end of Year 5 in the business plan. He believes comparable companies would be valued at 20x Net Income at that time. Given the investment risk you perceive, you believe your fund must require an internal-rate-of return (IRR) of 50% in order to justify the investment. Excite already has 1,000,000 shares outstanding (all owned by Nigel). Question 1: What share of the company must your fund own in order to achieve a 50% IRR at the end of Year 5? Question 2: How many shares will your fund need to purchase? Question 3: What price per share will your fund have to pay? Question 4: What would be the post-money valuation of Excite for this financing? Question 5: What would be the pre-money valuation of Excite? Nigel confides that he could use as much as 12 million to get Excite to the stage when it could achieve a significant IPO or be sold to a company like Amazon. Based on this investment, Nigel believes he could produce Net Income of 8 million by the end of Year 7. Question 6: How much of Excite must your fund own if you were to fund the entire 12 million up-front, assuming you want to achieve a 50% IRR by the end of Year 7? Question 7: Which of the above investment strategies (investing 5m or 12m) would you choose and why? After considering the pros and cons of investing $12 million up-front, you and Nigel agree your fund should invest only 5 million initially based on meeting the Year 5 target initially established by Nigel, and that a 50% IRR is an appropriate target return. Before offering a Term-Sheet to Nigel, you decide a stock option pool must be created in order to recruit additional senior managers. After some discussion, it is concluded amongst all parties that the senior management team (not including Nigel) should have options ultimately to own 15% of the company. It is agreed the stock options will not vest until the end of Year 3 (ie, the management team will not be able to exercise their options until the end of Year 3. This means they cannot actually own any shares until then). Given this new approach and taking into account the stock-option pool: Question 8: What share of Excite will your fund need to own under the new assumptions in order to achieve its 50% IRR objective by the end of Year 5? Question 9: What would be the pre-money valuation of Excite for this financing During the second year, it becomes apparent - even though Excite is making good progress - the company will require an additional capital injection of 3 million at the beginning of Year 3. The original Year 5 forecasted financial outcome and PEmultiple remain the same. You contact your best friend at Nice Guy Ventures who, after some study, agrees to invest some or all of the required 3 million. They agree that senior managements' option pool should be maintained at 15%. However, they require a target IRR of only 30%, since the risk is now lower than at the time of the first financing round. Question 10: Assuming Nice Guy Ventures puts up the entire 3 million, what ownership percentage of Excite would they need in order to achieve their 30% IRR? Question 11: What percentage of Excite would your fund own at the completion of this financing round, assuming Nice Guy invests all of the required 3 million? Question 12: financing? What would be the pre-money valuation of Excite for this When you and your partners see the dilution in your fund's ownership percentage resulting from Nice Guy taking the entire amount of the second financing round (the answer to Question 11), you decide your fund cannot afford to suffer so much dilution. Therefore, you decide to invest an amount that will allow you to maintain your existing ownership percentage (the answer to Question 8). Question 13: How much money would your fund need to invest in this round in order to maintain its existing ownership percentage? Question 14: Assuming your fund decides to maintain its percentage ownership, what would be the ownership percentages of all the following parties at the completion of the financing at the beginning of Year 3? a. Nigel Smith? b. Senior Management? c. Your Fund? d. Nice Guy Ventures? CENTEX TELECOMMUNICATIONS, INC These questions relate to Centex Telemanagement, Inc (A) - the case study to be discussed in Class Session 2. Any additional information you need to answer the questions is contained in the case. Question 15: What post-money and pre-money valuation is Sierra implicitly placing on Centex in the first financing offer they make in February 1985? Write down how much equity and how much debt you are assuming to be used in the financing. Question 16: Estimate what \"ballpark\" IRR Sierra might potentially achieve over a five-year period using the two scenarios below. Use the same assumptions as in Question 15 for the initial financing: Scenario A. Centex installs only the three switches already ordered and each switch produces steady revenue of $10 million per annum. Because these are the only switches installed, assume Centex does not require any additional financing over the five-year period, other than the amount assumed in Question 15. Consequently, you can assume that Sierra suffers no further dilution in its ownership. Scenario B. Assume Centex installs three switches every year during the five-year period and each of these switches produces steady revenue of $10 million per annum. Assume Sierra is successful in convincing other VC firms to co-invest so that Sierra must invest only an addiotnal $1 million at the end of Year 1 and another $1 million at the end of Year 2. Consequently, assume Sierra's initial ownership is diluted by 25 per cent. Assume in both scenarios that Centex achieves Net Income of 10% of revenue and can be valued using a PE-Ratio of 20x