Question: 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

pls help, thank you! 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...

pls help, thank you! 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...

Please create an excel spreadsheet with formulas for requirement 5 (pages 24-27)and requirement 6 (pages 28-31)only. Please submit in excel format. Both questions and answers are provided for...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

I need help with this project. I have attached all of the instructions and relevant information. The final draft is due August 20th. Course Project: A Financial Statement Analysis A Comparative...

Can someone help me with the Accounting Course Project. Instructions are there in the Course Project Instruction and the 10k for Nike and UNder Armour attached. I have also attached the Teamplate....

Hello tutor Please find the attached instruction file and use the template for solving this question. If you have any question about the problem please contact me. Thanks Your Course Project...

Part 1 is just the background information that might or might not be necessary for Part 3. Part 3 is what needs completion. Pls help, thank you!! SA CCOUNTING SOCIETY Part One Instructions Record the...

Please show the answers neatly in Microsoft Excel, thank you Question 2 (a) The calculation of present value (PV) or future value (FV) involves specifying the discount rater and the compounding...

THIS IS A COMPANY I AM WORKING ON FOR BUSINESS POLICIES AND NEED HELP GETTING STARTED ESPECIALLY WITH THE EXCEL SPREADSHEET PART!!! THANK YOU!!! TAKE YOUR TIME IF YOU MUST I WANT TO BE ABLE TO...

How can stream analytics be used in e-commerce?

Prairie Eateries Limited (PEL) is considering the following projects. PEL uses straight-line depreciation. Required: Calculate the accounting rate of return for each project. Projects Net profit...

In 2 0 1 5 , Roma carried out a successful Section 3 0 2 ( b ) ( 3 ) ( Complete Termination Of Shareholder's Interest ) Redemption as to stock in Trieste Corporation. In 2 0 2 4 , Roma inherits stock...

Skills necessary for success in marketing include Multiple select question. analytical thinking advertising industry experience infallibility ability to work with others

3. Would you like to work at a Stew Leonards retail store? Develop your rationale for employment or nonemployment.

2. The book encourages readers to pay attention to what is happening around them, anticipate change, and look at the opportunities that exist outside their comfort zones. How does this reflect on...

2. Your goals play a key role in bringing purpose and direction to your life. Identify the short-term goals that are currently influencing your behavior. What long-term goals do you hope to achieve...