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

pls help, thank you! pls help, thank you! 2. Create an excel spreadsheet (Table 2) and

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

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! 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...

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...

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....

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...

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...

The instructions are attached in the Division Performance Evaluation Division Performance Evaluation Project Using Excel In this assignment you will analyze the performance of PepsiCo or Marriott's...

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...

Prepare the financial analysis to support your decision between bankruptcy,voluntary reorganization,and Chapter11reorganization.It must be complete and prepared in a professional level,with the...

OL 325: Final Project Guidelines and Rubric Overview Acting as a recently hired compensation consultant, you will assist the burgeoning online music firm e-sonic to develop an internally consistent...

The set {a 1 , a 2, a 3 } will span R 3 unless h = .? (If there are no values of h that make the set fail to span, enter ?NONE?. If the set fails to span for a ?ALL?.) Let a1 = 5 ha2 -2 -19 -15, and...

1. Visit www.sephora.com and browse the online store. How does Sephora use the online environment to promote its products without the advantage of letting customers try before they buy? 2. Sephora is...

Another name for a deductible temporary difference is a favorable difference.

What things have this condition and what things do not, that is , what is the difference between being - for - itself and being - in - itself?

1 Is the need for training equally likely across different sectors? Purbeck Ice Cream is a small company employing eight people. It was set up by dairy farmers to make good use of excess milk and is...

2 What might be distinctive about how companies in different sectors approach the provision of training? Purbeck Ice Cream is a small company employing eight people. It was set up by dairy farmers to...

2 Where might the different approaches be most appropriate in terms of fit with: (a) industry norms; (b) organisational culture; (c) national culture?