1) Chris Creech and Andy Messner launched a NewCo. They each issued themselves 1,000,000 common shares and each of them invested $5000 to launch the company. Their friends,Stephanie Seitzinger and Collin OBrien invested $25,000 and received 15% of the total outstanding equity in common stocks. A year later, an Angel Investor, Minzheng invested $300,000 and received 20% of the total outstanding equity in preferred stock. Shortly thereafter, in Series A Tamaskar Ventures invested $5,000,000 at a pre-money valuation of $11,000,000. Two years following AAs investment, Lalwani Ventures invested $10,000,000 at a pre-money valuation of $15,000,000. Create a capitalization table for this company (You can turn in an excel sheet with numbers updated according to the prescribed formula).

2) Consider the cap table in the previous question. When NewCo was launched, Chris was working on a research project and developed a patent that was filed by Technology Commercialization Office (TCO) of The Ohio State University. In order to develop their product, Chris and Andy decided to exclusively license the patent from Ohio State. One of the terms in the licensing agreement, was that the university would hold a 2.5% of common stock in the NewCo. However, it had an anti-dilution provision. The university equity would not be diluted till the NewCo had raised at least $5M in financing. After the $5M threshold, the university equity would be diluted like all the shareholders. Redo the cap table from the previous problem to include this anti-dilution provision. (You can turn in an excel sheet with numbers updated according to the prescribed forumula).