pls help asap, thank you!
1. Create an excel spreadsheet (Table 1) and fill in your estimates of the salary rates you have for each position. That is what should the CEO be paid? What about a VP? A manager? An associate who reports to a manager? Your salary amounts for each position might change over the 7 years depending on startup's success? Table 1 Year 3 Year 5 Year Year 2 Startup raised Startup raised Series A- Seed=52M SZOM Revs S500.000 Revs $2.5M Year 4 Startup raised Series 3 = $40M Year 6 Year 7 Startup raised Startup raised IPO Series C=SSOM - $200M Revs $270M Revs - $540M Revs = STOM Revs S30M Revs SOOM I CEO Salary LVP Salary 1 Manager Salary | Associate Salary 2. Create an excel spreadsheet (Table 2) and use Table I's salary rates and the startup's assumed growing organization (below) to find the startup's total salaries for each year over the 7 years. Table 2 Year Seed - 2M Revs = $500,000 Year 2 Year 3 Year 4 Years Year 6 Year 7 Series A= Series B - SOM Series C-SOM IPO-5200M SZOM Revs = $2.5M Revs=STOM Revs = $30M Revs = $90M Revs = $270M Revs = $540M | CEO 1 CEO | CEO 1 CEO I CEO | CEO EV. - VPS S VPS 6 VPS - VPS 6 VPS 6 Managers 12 Managers 18 Managers 24 Managers 30 Managers 36 Managers 36 Associates 72 Associates 108 Associates 144 Associates 210 Associates 252 Associates Size of I CEO Organization I VP manager 6 Associates Total Company Salaries Paid 3. Create an excel spreadsheet (Table 3) and use your estimates of the salary rates in Table 1, but his time, to conserve cash, suppose you pay each position 75 of their Table 1 rate in cash, and pay them.25 of that rate in stock. To determine how many shares of stock you would award assume that the value of each share is given by the amounts below. (Note if you were going to pay a person $30,000 in stock and the stock was worth $5/sh, you would award them 6,000 shares (30,000/5). Assume the stock values below. Table fear 1 Seed-S2M Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Series A-520M Series B - 540M Series C-SOMIPO-S200M Revs = $2.5M Revs=SIOM Revs = $30M Revs = $90M Revs = $270M Revs = $540M Revs S500,000 Stock- Stock-$2.50 3.50 Stock - Ss/sh Stock - 58/shStock - $10h Stock - $18/h Stock = sl 50s I CEO.75 in cash CEO.25 in Stock CEON shares stock I VP.75 in cash VP 25 in Stock VP shares stock Manager.75 cash Manager 25 Stock Manager shares stock I Associate 75 cash Associate 25 Stock Associate shares stock 4. Create an excel spreadsheet (Table 4) and use your estimates of the cash salaries paid in Table 3, and the number of shares of company stock granted each year. Table 4 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 1 Number of CEOS Total Cash Salary for CEO annually Total Stock granted for CEO annually Number of VP's Total Cash Salary for all VPS Total Stock granted for all VI'S Number of Managers Total Cash Salary for all MGRS Total Stock granted for all MGRS Number of Associates Total Cash Salary for all Assoc's Total Stock granted for all Assoc's Total Cash Salary for all Employees by Year Total Stock granted for all Employees by Year Grand total of shares granted to employees over years 1-7
