Using the Quantitative Investor ROI Breakeven valuation methodology compute the projected Series A Pre-Money Valuation. Then input ALL provided input variables in the Company LM Case Study into the Company LM Capitalization Table (#17-Assignment (Cap Table Company LM). Make ALL necessary computations and enter into the #17-Assignment (Cap Table- Company LM) Excel template (i.e. fill-in all the gray shaded boxes) in order to construct a COMPLETE Company LM Capitalization Table. Then apply the aggregate projected Exit Value to the Preferred Stock Investor "Preference Rights" and then subsequently allocate/distribute the remaining "Distributable Equity" balance, using the line item ending % Equity for each investor, to all specific Investors. This #17-Assignment attempts to fully integrate multiple lecture content into a fully integrated robust exercise. (Hint: Studying and leveraging the content within the #17-Template (Multiple Funding Rounds & Returns) and utilizing the equations in #15-Handout (Cap Table Formula Summary) should be helpful.) 1 Company LM Series A Preferred "Pre-Money"Valuation 2 Company LM "Exit EBITDA 3 EBITDA Multiple 4 Total Exit Value 5 Rounded Total Exit Value (to Nearest Million) 6 7 Series A Preferred Capital Offering 8 Investor Targeted ROI 9 Investor Total ROI 10 Series A Invester% Equity 11 12 Pre-Money Valuation 13 Capital Investment Series A l'referred 14 Post Money Valuation 15 16 17 Capitalization Table - Company ti A Total Founding Shares B00,000 Pre-Money Common Pre-Money Valuation Series A Pre-Money Valuation Stock Options Common Stock Raised Series A Capital Raised 20 Pool Common Post Money Valuation Post Money Valuation 21 Common Investor (8) % Equity Series A Investor(8) % Equity 22 Common Investor per Share Price Series A Investors) per Share Price 23 Initia! Total Total Total Common Common Total Series A Series A 24 Shareholders: Shares % Equity Shares % Equity Investment # Shares Total Shares % Equity S Investment # Shares Total Shares 25 Founder: 560,000 70.0% 560,000 26 Founder 2 100.000 20.0% 160,000 27 Founder 1 80,000 10.0% 80,000 28 Option Pool Pre-Money Valuation Series B Capital Raised Post Money Valuation Series B Investor(s) % Equity Series B Investors) per Share Price Total Series B Series 1 % Equity S Investment Shares Total Shares Total % Equity $1,000,000 $1,500,000 100.0% $1,500,000 1,333,333 100.0% $1,000,000 0 0 0 100.0% 90 Common Stock Investors) Angel-Individual 41 S25,000 2 Angel-Individual #2 $25,000 33 Angel Individual S25,000 34 Mid America Angel Group $175.000 35 36 Series A Investor) 37 Series Investo) 38 Total 800,000 100.0% 1,000,000 0.0% S250.000 333,333 39 40 #1 42 Patental Exit Value 13 Liquidation Preference Structure: Non-Participating - 0 & Full Participation - 1 Dividend Years Liquidation Total 45 Liquidation Preferences: Rate To Exit Multiple S Preference 46 Series A Investors 47 Series A Accrued Dividend 48 Series A Liquidation-Non Participating 49 Series A Liquidation - Full Participation o Series B Investors 51 Series B Accrued Dividend 52 Series Liquidation-Non Participating 53 Series Liquidation-Full Particpation Totally % Common Preferences Equivalent Investor Return ROI Multiple Shareholder Equity Distributions & Returns: Common Stock Investors Angel-Individual Angel-Individunlu2 Angel-Individual 03 Mid-America Angel Group Series A Preferred Investors Series B Preferred Investors Founder #1 Founder 2 Founder 13 Option Pool SO SO SO SO SO 50 SO SO SO SU 55 Distributable Equity Value (balance) to Common Equivalent 56 57 SY Using the Quantitative Investor ROI Breakeven valuation methodology compute the projected Series A Pre-Money Valuation. Then input ALL provided input variables in the Company LM Case Study into the Company LM Capitalization Table (#17-Assignment (Cap Table Company LM). Make ALL necessary computations and enter into the #17-Assignment (Cap Table- Company LM) Excel template (i.e. fill-in all the gray shaded boxes) in order to construct a COMPLETE Company LM Capitalization Table. Then apply the aggregate projected Exit Value to the Preferred Stock Investor "Preference Rights" and then subsequently allocate/distribute the remaining "Distributable Equity" balance, using the line item ending % Equity for each investor, to all specific Investors. This #17-Assignment attempts to fully integrate multiple lecture content into a fully integrated robust exercise. (Hint: Studying and leveraging the content within the #17-Template (Multiple Funding Rounds & Returns) and utilizing the equations in #15-Handout (Cap Table Formula Summary) should be helpful.) 1 Company LM Series A Preferred "Pre-Money"Valuation 2 Company LM "Exit EBITDA 3 EBITDA Multiple 4 Total Exit Value 5 Rounded Total Exit Value (to Nearest Million) 6 7 Series A Preferred Capital Offering 8 Investor Targeted ROI 9 Investor Total ROI 10 Series A Invester% Equity 11 12 Pre-Money Valuation 13 Capital Investment Series A l'referred 14 Post Money Valuation 15 16 17 Capitalization Table - Company ti A Total Founding Shares B00,000 Pre-Money Common Pre-Money Valuation Series A Pre-Money Valuation Stock Options Common Stock Raised Series A Capital Raised 20 Pool Common Post Money Valuation Post Money Valuation 21 Common Investor (8) % Equity Series A Investor(8) % Equity 22 Common Investor per Share Price Series A Investors) per Share Price 23 Initia! Total Total Total Common Common Total Series A Series A 24 Shareholders: Shares % Equity Shares % Equity Investment # Shares Total Shares % Equity S Investment # Shares Total Shares 25 Founder: 560,000 70.0% 560,000 26 Founder 2 100.000 20.0% 160,000 27 Founder 1 80,000 10.0% 80,000 28 Option Pool Pre-Money Valuation Series B Capital Raised Post Money Valuation Series B Investor(s) % Equity Series B Investors) per Share Price Total Series B Series 1 % Equity S Investment Shares Total Shares Total % Equity $1,000,000 $1,500,000 100.0% $1,500,000 1,333,333 100.0% $1,000,000 0 0 0 100.0% 90 Common Stock Investors) Angel-Individual 41 S25,000 2 Angel-Individual #2 $25,000 33 Angel Individual S25,000 34 Mid America Angel Group $175.000 35 36 Series A Investor) 37 Series Investo) 38 Total 800,000 100.0% 1,000,000 0.0% S250.000 333,333 39 40 #1 42 Patental Exit Value 13 Liquidation Preference Structure: Non-Participating - 0 & Full Participation - 1 Dividend Years Liquidation Total 45 Liquidation Preferences: Rate To Exit Multiple S Preference 46 Series A Investors 47 Series A Accrued Dividend 48 Series A Liquidation-Non Participating 49 Series A Liquidation - Full Participation o Series B Investors 51 Series B Accrued Dividend 52 Series Liquidation-Non Participating 53 Series Liquidation-Full Particpation Totally % Common Preferences Equivalent Investor Return ROI Multiple Shareholder Equity Distributions & Returns: Common Stock Investors Angel-Individual Angel-Individunlu2 Angel-Individual 03 Mid-America Angel Group Series A Preferred Investors Series B Preferred Investors Founder #1 Founder 2 Founder 13 Option Pool SO SO SO SO SO 50 SO SO SO SU 55 Distributable Equity Value (balance) to Common Equivalent 56 57 SY