Answered step by step
Verified Expert Solution
Question
1 Approved Answer
pls help, thank you! 3. Create an excel spreadsheet (Table 3) and use your estimates of the salary rates in Table 1, but his time,
pls help, thank you!
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 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started