please show work, excel is great too if fromulas are shown

3. ProGame is a seed-stage web-oriented entertainment company with important intellectual property. ProGames founders, all technology experts in the relevant area, are anticipating a quick leap to dot-com fortune and believe that their unique intellectual property will allow them to achieve a subsequent (year 3) S100,000,000 venture value with a one-time initial $2,000,000 in venture financing. In contrast, similar dot-commers in their niche are currently seeking multistage financing amounting to S10,000,000 to achieve comparable results. The founders have organized with 1,000,000 shares and are willing to "grant" venture investors a 100% return on their business plan projections. A. What percent of ownership must be sold to "grant" the 100% three-year return? B. What is the resulting configuration of share ownership (starting from the 1,000,000 founders 'shares? C. Suppose the venture investors dont buy the business plan predictions and want to price the deal assuming a second round in year 2 of $8,000,000 with a 40% return. What changes? D. Suppose the venture investors agree with the founders' assessment, price the deal accordingly (as in Part B) and turn out to be wrong (an additional $8,000,000 at 40% must be injected for the final year). 1. What is the impact on the founders and round one investors "final ownership assuming the second round is funded by outsiders? 2. Compare these to your results for Part C. 3. Who bears the dilution from an anticipated round? 4. Who bears the dilution from an unanticipated round? E. Suppose that the deal is priced assuming the second round (as in Part C) and it turns out to be unnecessary. Comment on the final ownership percentages at exit (year 3). What do you conclude about the impact of anticipated but unrealized subsequent financing rounds