Answered step by step
Verified Expert Solution
Link Copied!

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!
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

ISE Financial Institutions Management A Risk Management Approach

Authors: Anthony Saunders Professor, Marcia Millon Cornett, Otgo Erhemjamts

10th International Edition

1260571475, 9781260571479

More Books

Students also viewed these Finance questions