Question: D. Based on Brian's tutorial video of spreadsheet models, develop a basic but reasonable spreadsheet model of Amazon.com, assuming that it operates to 3 business

D. Based on Brian's tutorial video of spreadsheet models, develop a basic but reasonable spreadsheet model of Amazon.com, assuming that it operates to 3 business models: (1) Sales of new products. (2) Sales of used products from Amazon.com members. (3) Paid subscription of Amazon Prime members. For the sake of the exercise, assume that Amazon.com's operations are organized into 5 redundant regions. D1: Show your spreadsheet model, including a description of each numbered cell. D2: Estimate Amazon.com's profitability based on your spreadsheet model. D3: Assuming that an initial startup investment is 53 billion. What is the company's breakeven point based on your spreadsheet model. D4: What additional single piece of information that you would like to receive from Amazon.com that would help your spreadsheet model be more accurate? D. Based on Brian's tutorial video of spreadsheet models, develop a basic but reasonable spreadsheet model of Amazon.com, assuming that it operates to 3 business models: (1) Sales of new products. (2) Sales of used products from Amazon.com members. (3) Paid subscription of Amazon Prime members. For the sake of the exercise, assume that Amazon.com's operations are organized into 5 redundant regions. D1: Show your spreadsheet model, including a description of each numbered cell. D2: Estimate Amazon.com's profitability based on your spreadsheet model. D3: Assuming that an initial startup investment is 53 billion. What is the company's breakeven point based on your spreadsheet model. D4: What additional single piece of information that you would like to receive from Amazon.com that would help your spreadsheet model be more accurate

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 General Management Questions!

Based on Brian's tutorial video of spreadsheet models, develop a basic but reasonable spreadsheet model of Amazon.com, assuming that it operates to 3 business models: (1) Sales of new products. (2)...

D. Based on Brian's tutorial video of spreadsheet models, develop a basic but reasonable spreadsheet model of Amazon.com, assuming that it operates to 3 business models: (1) Sales of new products....

A. Suppose that you have a $1000 budget with which you can spend on employee training (T) and marketing (M). Assume that your company has a limited number of employees so that it only has capacity...

Please read the give cases and provide your reviews on it. will identify these components through case studies of Wal-Mart and Amazon.com to understand how their supply chains reinforce their...

1. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on...

Company Chosen is Amazon. Section 3, Materiality and Risk The senior partner wants to confirm your understanding of key concepts. Summarize each concept 90-175-words each. Materiality Misstatement...

Could I get the cost of capital calculation (WACC) broken out in excel for Amazon based on FY2015 financials? \fTo our shareowners: This year, Amazon became the fastest company ever to reach $100...

Hi, I have areport due in nine hours. I need to find the following list of things on Amazon.com....

. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on a...

Please answer the below questions about Amazon . I have attached their 10-K which you should be able to find all this information. For each question, please write 2-3 paragraphs. If you use any other...

Suppose a random sample of 137 households in Detroit was taken as part of a study on annual household spending for food at home. The sample data are contained in the file Detroit Eats. a. For the...

A plane wall of thickness 0.1 m and thermal conductivity 25 W/m K having uniform volumetric heat generation of 0.3 MW/m3 is insulated on one side, while the other side is exposed to a fluid at 92C....

Which of the following is NOT necessary for a will to be valid? A ) All heirs must agree to the terms of the will. B ) The will must be dated. C ) The will must be signed.

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...