Can someone please list the excel formulas as well as the actual values in the area I have highlighted?

Use the template below to find the Pavout to Preferred for all 9 cases. The payout should work for ANY rational inputs of Exit value, Series A Investment, and Percent equity claim. These inputs are in bold with yellow highlights. Check your results by going through all the cases in the Venture Deals pages 57-60. The Percent Equity Claim is given in the book as the amount the Series A Investors own. To calculate the Value if Not converted use the equations shown in the Convertible Preferred Stock slide. You MUST use the MIN and LEFT functions in this formula. 1 2 3 7 9 1 2 3 The exit value is Series A Investment Percent of equity claim Venture Deals Page 57-60 Scenario: Vdeals Case 1 1 33.33% NO NO Vdeals Case 2 2 33.33% NO NO 3 33.33% NO NO Vdeals Case 3 4 33.33% NO 5 33.33% NO 6 33.33% NO Vdeals Case 4 7 33.33% lx 8 33.33% 9 33.33% Liquidation preference multiple Participating? cap? Value if converted Value if not converted Will the preferred convert (Yes/No)? Payout to preferred