You are a financial manager of Netflix Inc. (symbol: NFLX). You are considering the purchase of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a financial manager of Netflix Inc. (symbol: NFLX). You are considering the purchase of a promising new software company in California. Your objective is to determine the present value of the future cash flows that this company is expected to generate, thus giving you an approximate idea of the maximum price you would be willing to pay for this company. NFLX has determined that the hypothetical cash flows generated by this company would be of similar riskiness to its own asset cash flows. Therefore, NFLX will use its expected return on assets to discount the future net cash flows from the software company. a) Calculate NFLX's equity beta as follows. First, download monthly price data for NFLX and SPY from the Supplementary Data folder on the Blackboard course site. SPY is an exchange-traded fund that tracks the S&P 500, and thus provides a good representation of the market portfolio. The Supplementary Data folder is found on the Problem Sets page. Second, calculate monthly returns for NFLX and SPY using the following equation: ₁ = (Pt-Pt-1)/Pt-1, where r, is the return in month t, and P, is the adjusted closing price in month t. Convert all of your returns into excess returns (7) by subtracting the monthly risk-free rate, which we will assume is 0.0369/12. You will not have a return observation for the first month of your time series. Third, run a linear regression of NFLX excess returns (your Y variable) on SPY excess returns (your X variable). You can find "Regression" in Microsoft Excel in "Data Analysis" under the "Data" tab.¹ Report the X-variable coefficient and t-statistic (each to three decimal places). The X-variable coefficient is the equity beta for NFLX. A t-statistic above 1.96 indicates that we are 95% confident that NFLX monthly returns are positively correlated with S&P 500 monthly returns. b) Calculate the asset beta for NFLX. Assume that the market value of NFLX equity is $162 billion, the market value of NFLX debt is $28 billion, and the beta of NFLX debt is 0.15. c) Using the CAPM, calculate and report the expected return on assets for NFLX. Assume a market risk premium of 5.0% and a risk-free rate of 3.69% (the approximate yield on 30-year U.S. treasury securities). d) The software company is expected to generate asset cash flows for the next thirty years. Next year, the software company is expected to generate $250 million in asset cash flow, and this cash flow is expected to grow by 2% per year for the life of the software company. What is the present value of the asset cash flows generated by this software company? You are a financial manager of Netflix Inc. (symbol: NFLX). You are considering the purchase of a promising new software company in California. Your objective is to determine the present value of the future cash flows that this company is expected to generate, thus giving you an approximate idea of the maximum price you would be willing to pay for this company. NFLX has determined that the hypothetical cash flows generated by this company would be of similar riskiness to its own asset cash flows. Therefore, NFLX will use its expected return on assets to discount the future net cash flows from the software company. a) Calculate NFLX's equity beta as follows. First, download monthly price data for NFLX and SPY from the Supplementary Data folder on the Blackboard course site. SPY is an exchange-traded fund that tracks the S&P 500, and thus provides a good representation of the market portfolio. The Supplementary Data folder is found on the Problem Sets page. Second, calculate monthly returns for NFLX and SPY using the following equation: ₁ = (Pt-Pt-1)/Pt-1, where r, is the return in month t, and P, is the adjusted closing price in month t. Convert all of your returns into excess returns (7) by subtracting the monthly risk-free rate, which we will assume is 0.0369/12. You will not have a return observation for the first month of your time series. Third, run a linear regression of NFLX excess returns (your Y variable) on SPY excess returns (your X variable). You can find "Regression" in Microsoft Excel in "Data Analysis" under the "Data" tab.¹ Report the X-variable coefficient and t-statistic (each to three decimal places). The X-variable coefficient is the equity beta for NFLX. A t-statistic above 1.96 indicates that we are 95% confident that NFLX monthly returns are positively correlated with S&P 500 monthly returns. b) Calculate the asset beta for NFLX. Assume that the market value of NFLX equity is $162 billion, the market value of NFLX debt is $28 billion, and the beta of NFLX debt is 0.15. c) Using the CAPM, calculate and report the expected return on assets for NFLX. Assume a market risk premium of 5.0% and a risk-free rate of 3.69% (the approximate yield on 30-year U.S. treasury securities). d) The software company is expected to generate asset cash flows for the next thirty years. Next year, the software company is expected to generate $250 million in asset cash flow, and this cash flow is expected to grow by 2% per year for the life of the software company. What is the present value of the asset cash flows generated by this software company?
Expert Answer:
Answer rating: 100% (QA)
lets work through this stepbystep a Calculating NFLXs equity beta 1 Download the monthly price data ... View the full answer
Related Book For
Microeconomics An Intuitive Approach with Calculus
ISBN: 978-0538453257
1st edition
Authors: Thomas Nechyba
Posted Date:
Students also viewed these accounting questions
-
The search objective is to determine the amount generally excludable on the sale of a married couples home. Using Browse, locate the Standard Federal Tax ReporterExplanations library. How many...
-
You are a financial analyst employed at Clarington Quarry Works (CQW). CQW has a December 31 year-end. CQW's board of directors is considering a change to the company's executive compensation plan so...
-
You are a financial manager with a medium-sized company, Kangaroo Express. The company is owned and managed by the Marsupial family. Currently, 60% of the companys financing is composed of long-term...
-
Let R denote the set of continuous functions with domain R (as in calculus). Then R is a commutative ring with identity. The additive identity OR is the zero function (that is, the function h(x)...
-
1. Would registration with the SEC be required for Dakota Gasworks securities? Why or why not? 2. Did Emerson violate Section 10(b) of the Securities Exchange Act of 1934 and SEC Rule 10b-5? Why or...
-
Winter is back and is end of season's sale all over. The City's biggest Housewares and Home Appliances Fair is inaugurated at the Mathura Trade Centre and the show hosted numerous retailers,...
-
A manufacturer of smart phones has the following probability distribution for the number of defects per phone: (a) Determine the probability of 2 or more defects. (b) Is a randomly selected phone...
-
What is the major task of promotion? Do firms ever use promotion to accomplish this task and fail? If so, give several examples.
-
. In each case, determine whether or not the point lies on the line. If it does not, give an equation of a plane containing the point and the line. a. (-7, 10,-3) and r (t) = (1 - 4t, 6t - 5, t5) b....
-
Use PSpice to find V1, V2, and V3 in the network of Fig. 10.128. 8 V. j1012 V, jlOS2 4/0 A
-
If Fr=F1 -F2, Being F1= 10 N, 120 and F2 = 20 N, and 90. what is the graph
-
Programming Exercise 6 in Chapter 2 was the Sales Tax program. For that exercise you were asked to design a program that calculates and displays the county and state sales tax on a purchase. If you...
-
The following data have been reported for equilibrium adsorption of benzene on certain activated carbon at \(306 \mathrm{~K}\). (a) Fit a Langmuir-type isotherm to these data. (b) Fit a...
-
The membrane in Example 9.1 is replaced with another of the same thickness, but with a permeability of 300 barrer for solute A. Calculate the transmembrane flux of solute A if the film coefficients...
-
Take the \(z\)-transform of (6.2.6) and show that \(\mathbf{X}(z)=\mathbf{G}(z) \mathbf{Y}(z)\), where \(\mathbf{G}(z)=(z \mathbf{U}-\mathbf{M})^{-1} \mathbf{D}^{-1}\) and \(\mathbf{U}\) is the unit...
-
When developing a marketing strategy using new digital media, a marketer must be aware of the strengths and weaknesses of these new media. Digital media are relatively new to the field of marketing...
-
You are considering investing on stock A or B both of which are selling for $50. You plan to sell the stock in one year. You believe these two companies will not pay any dividend and the prices one...
-
Doorharmony Company makes doorbells. It has a weighted- average cost of capital of 5% and total assets of $ 5,900,000. Doorharmony has current liabilities of $ 750,000. Its operating income for the...
-
In our development of producer theory, we have found it convenient to assume that the production technology is homothetic. A: In each of the following, assume that the production technology you face...
-
We have illustrated in several settings the role of actuarially fair insurance contracts (b, p) (where b is the insurance benefit in the bad state and p is the insurance premium that has to be paid...
-
Confirmation Bias, Politics, Research and Last-Minute Studying: Individuals have lots of assumptions about the way the world works, assumptions that help frame how they make decisions. These...
-
When a honeybee flies through the air, it develops a charge of +17 pC. How many electrons did it lose in the process of acquiring this charge?
-
Falling raindrops frequently develop electric charges. Does this create noticeable forces between the droplets? Suppose two 1.8 mg drops each have a charge of +25 pC; these are typical values. The...
-
A housefly walking across a surface may develop a significant electric charge through a process similar to frictional charging. Suppose a fly picks up a charge of +52 pC. How many electrons does it...
Study Guide For The PMI Risk Management Professional Exam 1st Edition - ISBN: 1492761176 - Free Book
Study smarter with the SolutionInn App