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)...
-
Preparing journal entries for income tax expense. An electric utility reports the following information about its income taxes for three recent years (amount in millions): (a) Give the journal...
-
LeaseAfric Ltd. is considering the purchase of a fleet of cars for $337,500.00. It can borrow at 7.5%. The cars will be used for 4 years. The corporate tax rate is 35% and the cars belong in a 30%...
-
Inventory Turnover Calculate the company's inventory turnover for 2019 and compare the result to the industry average. Use the following financial data for Brenner Instruments Sales revenue.. Cost of...
-
Details about a companys liabilities appear in a number of places in the annual report. Use Amazon.coms financial statements, including Notes 1 and 5, to answer the following questions. Amazons...
-
Assume you are purchasing an income-producing property for $10,000,000. The estimated NOI in the next year is $600,000. A lender is willing to provide a mortgage with an annual interest rate of 4.0%....
-
If the Sommers had chosen the original 15-year, 6.25% mortgage proposal, how much tax shelter would they have lost (over the last five years) as compared to the 30-year, 7.25% mortgage?
-
Please code using JAVA and show screenshots of the program running/working . Need ASAP, Thank you in advance!! Further instructions: Please indicate Design Pattern/s Used (Minimum of 2). The system...
-
Case Study 2a - Who will I be as a leader? In four weeks, Little Catalysts ELC will have a site visit from a consultant to confer with selected staff. Carol, the Director, wants to see if the service...
-
The units of an item available for sale during the year were as follows: Jan. 1 Inventory 40 units at $165 $6,600 Aug. 13 Purchase 200 units at $180 36,000 Nov. 30 Purchase 60 units at $200 12,000...
-
listen to the This American Life audio clips. 1. In the opening clip, reporter Jacob Goldstein is trying to understand where all the lost money went during the financial crisis. He asks his business...
-
1-2 3 3 02 1. Let A = and B = find 2A-3B. 45-6 7 1 8 2 1 [1-2 -5 2. Given A= 1 0 and B find 3 40 3 4 a. AB b. BA
-
Determine a business for the group to start Option. Do a SWOT analysis on the business and the team members Option. Each team member selects two factors that help make up a business plan and explains...
-
Bed & Bath, a retailing company, has two departments-Hardware and Linens. The company's most recent monthly contribution format income statement follows: Sales Variable expenses Contribution margin...
-
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...
-
Fixed costs a. do not vary with the level of output. b. cannot be avoided in the short run without going out of business. c. do not exist in the long run. d. are characterized by all of the above.
-
The change in total cost that results from the production of one additional unit of output is called a. marginal revenue. b. average variable cost. c. marginal cost. d. average total cost. e. average...
-
Which short-run curve typically declines continuously as output expands? a. Average variable cost b. Average total cost c. Average fixed cost d. Marginal cost e. None of the above
Study smarter with the SolutionInn App