Question: to prepare for this Assignment, use the Netflix and Amazon Data Spreadsheet, located in the file attached, to generate a pro forma forecast and consider

to prepare for this Assignment, use the Netflix and Amazon Data

to prepare for this Assignment, use the Netflix and Amazon Data Spreadsheet, located in the file attached, to generate a pro forma forecast and consider what this indicates about the future for these two companies.

provide the following:

  • A forecast of Netflix, Inc., and Amazon.com, Inc.'s revenue, costs, and estimated cash flows into the next five years.
  • The appropriatediscount ratefor Netflix, Inc., and Amazon.com, Inc.'s forecasted cash flows.
  • An appropriate risk-adjusted rate of return for use in evaluating an investment in Netflix, Inc., and Amazon.com, Inc.
  • A determination of theestimated fair market valueof 100% of Netflix, Inc., and Amazon.com, Inc.'s equity.

I ATTACHED A OUTLINE WITH FORMULAS FOR THIS ASSIGNMENT (I NEED HELP FILLING IT IN)

I ALSO ATTACHED THE DATASHEET FOR AMAZON AND NETFLIX IN AN EXCEL FILE

Spreadsheet, located in the file attached, to generate a pro forma forecast

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!

Q:

To prepare for this Assignment, use the Netflix and Amazon Data Spreadsheet, located in the file attached to generate a pro forma forecast and consider what this indicates about the future for these...

Q:

Assignment 1: Forecasting Revenue, Costs, and Estimated Cash Flows Imagine that you are a financial advisor for Netflix, Inc., and Amazon.com, Inc. You are tasked with creating a comprehensive...

Q:

Imagine that you are a financial advisor for Netflix, Inc., and Amazon.com, Inc. You are tasked with creating a comprehensive forecast of the revenue, costs, and cash flows of these companies,...

Q:

Assignment 1: Forecasting Revenue, Costs, and Estimated Cash Flows Imagine that you are a financial advisor for Netflix, Inc., and Amazon.com, Inc. You are tasked with creating a comprehensive...

Q:

Assignment 1: Forecasting Revenue, Costs, and Estimated Cash Flows Imagine that you are a financial advisor for Netflix, Inc., and Amazon.com, Inc. You are tasked with creating a comprehensive...

Q:

Imagine that you are a financial advisor for Netflix, Inc., and Amazon.com, Inc. You are tasked with creating a comprehensive forecast of the revenue, costs, and cash flows of these companies,...

Q:

Q Imagine that you are a financial advisor for Netflix, Inc., and Amazon.com, Inc. You are tasked with creating a comprehensive forecast of the revenue, costs, and cash flows of these companies,...

Q:

Assignment 1: Forecasting Revenue, Costs, and Estimated Cash Flows Imagine that you are a financial advisor for Netflix, Inc., and Amazon.com, Inc. You are tasked with creating a comprehensive...

Q:

Imagine that you are a financial advisor for Netflix, Inc., and Amazon.com, Inc. You are tasked with creating a comprehensive forecast of the revenue, costs, and cash flows of these companies,...

Q:

Use the Netflix and Amazon Data Spreadsheet, located in the attached files (pictures) to generate a pro forma forecast and consider what this indicates about the future for these two companies....

Q:

After an organism uses energy, what happens to the energy? Is all the energy captured through gross primary productivity available to organisms higher in a food chain? Explain.

Q:

Distinguish between: a. individual A (a student), who spent the summer painting three houses. The contract for one house provided for a fixed fee; the contracts for the other two provided for a fee...

Q:

16.65 For the RLC circuit shown in Fig. 16.88, find the complete response if v (0) = 2 V when the switch is closed. 2 cos 4t V(+ t=0 602 1H wwm 619 TI 1

Q:

Capital budgeting methods, no income taxes. City Hospital, a non-profit organization, estimates that it can save $28,000 a year in cash operating costs for the next 10 years if it buys a...

Q:

Transfer-pricing methods, goal congruence. British Columbia Lumber has a Raw Lumber Division and a Finished Lumber Division. The variable costs are: Raw Lumber Division: $100 per 100 board-feet of...

Q:

Capital budgeting methods, no income taxes. Riverbend Company runs hardware stores in a tri-state area. Riverbends management estimates that if it invests $160,000 in a new computer system, it can...

Q:

A particle starts from the origin at t = 0 with a velocity of 8.0j m/s and moves in the xy plane with constant acceleration (4.0i + 2.0j) m/s2. When the particle's x coordinate is 29 m, what are its...

Q:

Describe the current convergence efforts of the FASB and IASB in the area of accounting for taxes.

Q:

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

Q:

Webson Manufacturing Company produces component parts for the airline industry and has recently undergone a major computersystem conversion. Michael Darwin, the controller, has established a...

Q:

The Alert Company is a closely held investment service group that has been very success ful over the past five years, consistently providing most members of the top management group with 50 percent...

Q:

The job responsibilities of three employees of Barney Manufacturing are described next. Tyranna Davis, cost accounting manager, is responsible for measuring and collecting costs associated with the...