Sign In
Not register? Register Now!
Pages:
3 pages/≈825 words
Sources:
Check Instructions
Style:
APA
Subject:
Accounting, Finance, SPSS
Type:
Other (Not Listed)
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 14.04
Topic:

Equity Value Per Share for Amazon using FCFF (Free Cash Flow to Equity)

Other (Not Listed) Instructions:

- Excel file + 3 pages write-up file
- All requirement in the word document (total 5 questions to answer)
- have to use the data from excel file "Amazon com Inc Financials (2)"
- I have an example of Disney Land, have to follow that

Mini Project 1

In this project, we will use Free Cash Flow Valuation method to value Amazon.com, Inc. based on the past 10 years financial data.

I have posted financial information of Amazon from 2010 to 2019 on Canvas. Please use the financial information posted and the information below to find the equity value per share for Amazon using FCFF and answer the questions below.

  1. Please follow the steps and method used in the Walt Disney example in handout 4 to find out the equity value per share for Amazon. For cash flow after 2025, you apply multiple stage model based on your own estimation and do not copy Walt Disney example for that part. (calculation: 20 points)
  2. In the financial information “key stats” table, it provides the estimated total revenue growth rates for year 2020-2022. Also, in the Free Cash Flow Valuation model, you need to project the FCFF growth rates after 2025. Please provide an analysis report for Amazon to support your projection of future growth rates, and to justify whether the estimated total revenue growth rates for 2020-2022 are reasonable. Make sure your analysis report to include the impact of Covid-19 and US-China trading war, and any other factors you think may affect Amazon’s future business.  (20 points)
  3. The cost of equity of Amazon is 9.46%.
  4. After you find out the equity value per share for Amazon, please do sensitivity analysis. Increase/decrease your WACC by 1% each time, up to total ±3%. Increase/decrease your long-term growth rate by 0.5% each time, up to total ±2%. Which factor(s) is your equity value most sensitive to?  (5 points
  5. Compare your equity value to the stock price on Dec. 31, 2019, conclude whether Amazon stock is undervalued, fairly valued or overvalued. Do you recommend buying or selling this stock? (2 points)
  6. If you can choose between FCFF and FCFE to value Amazon, which one do you choose and why? (3 points)

  7. All the calculation must be done in the excel file. Please submit your excel file, and a separate write-up file (either .doc or pdf file) via Canvas. Write-up file should be no more than 3 pages (appendix and references are not count as part of the 3-page limits).
Other (Not Listed) Sample Content Preview:

Mini Project 1
Name Course Instructor Date
1 In the financial information “key stats” table, it provides the estimated total revenue growth rates for year 2020-2022. Also, in the Free Cash Flow Valuation model, you need to project the FCFF growth rates after 2025. Please provide an analysis report for Amazon to support your projection of future growth rates, and to justify whether the estimated total revenue growth rates for 2020-2022 are reasonable. Make sure your analysis report to include the impact of Covid-19 and US-China trading war, and any other factors you think may affect Amazon’s future business. (20 points)
Revenue
The revenue growth rates are forecasted as -76.53%, 10.60% and 15.79% in 2020, 2021 and 2022. The average revenue growth rate is -16.71% in the three years partly because of the effect of Covid-19 on the company’s operations. It is estimated that a modest growth of 4% based on growing competition and the demand for American made products that are more expensive, and the company would likely operate on even lower margins. Amazon is one of the biggest players in e-commerce in the US domestic market and international markets and will remain so because it can leverage the economies of scale and wide distribution network. However, in China, Alibaba has realized huge growth in the past few years, and combined with restriction against foreign companies, Alibaba will increase its market share in China and the Asia Pacific region.
In the past 10 years the average growth rate in revenue has been 26.5%, but Amazon reported losses in 2012 and 2014 even when reporting growth in revenue. Amazon has also recorded federal operating loss carryforwards indicating that revenue growth does not always translate to huge profits. Growing competition in China and lawsuits in Europe are likely to slow down some of the company’s operations in Europe and Asia. In the US, there is greater demand for more wages and this would reduce the profitability levels as Amazon maintains a huge workforce across different locations in the US and internationally.
In 2019, the current-dollar GDP increased 4.0 % and 5.5 % in 2018, but this is expected to decline (FRED | St. Louis Fed, 2020). The annual inflation rates in the US were 2.14%, 2.44% and 1.81% in 2017, 2018 and 2019, respectively (FRED | St. Louis Fed, 2020). In 2020, the inflation rate is estimated to be less than 1%. Changes in the interest rates, inflation rates and economic growth will likely affect the company’s growth prospects in the US as macroeconomic variables affect consumer demand, consumer spending.
The Gordon model to determine stock value assumes that the constant growth that is less than the constant growth of equity in a dividend paying company. Amazon’s cost of equity is 9.46%, and as such, Gordon’s model works as the growth is less than 9.46%. However, since Amazon does not pay dividends and this means that the model would be unsuitable for determining the company’s stock value.
Covid-19 and Amazon's future business
In the financial year 2020, there has been increased use in online retail, but Covid-19 has resulted in job losses and reduced consumer expenditure. Covid-19 prevention measures h...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

👀 Other Visitors are Viewing These APA Other (Not Listed) Samples:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!