Calculate the fair value of AMAZON and its expected return. ? ? ? ? ? ? ?
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculate the fair value of AMAZON and its expected return.
? ? ? ? ? ? ? ?Calculate the implied return for the AMAZON stock.
? ? ? ? ? ? ? ?Calculate alpha the risk adjusted excess return. ?
State and explain your opinion as to whether or not you should buy or sell the company.
DATA:
?
??
Transcribed Image Text:
Amazon is a conglomerate technology company focusing on e-commerce, digital streaming, cloud computing, and artificial intelligence. The current share value of Amazon is $2,525 per share, and the analysis predicts the target into a median target of $2,730 per share with a high estimate of $3,300 and a low profile share value of $1,840. Company Background 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 All values in USD Millions Sales Sales yoy growth % Earnings Earnings you growth % EPS EPS yoy growth % Dividends Cash Flows Net Operating Cash Flow Net Operating Cash Flow Growth Net Investing Cash Flow Net Investing Cash Flow Growth Net Financing Cash Flow 16 Net Financing Cash Flow Growth Free Cash Flow 17 18 Free Cash Flow Growth 2020 386064 =B2/C2-1 21331 -B4/C4-1 41.83 =B6/C6-1 0 2019 280522 =C2/D2-1 11588 2020 66064 =C4/D4-1 22.99 =C6/D6-1 0 2018 232887 =D2/E2-1 10073 =D4/E4-1 20.15 =D6/E6-1 0 2017 177866 =E2/F2-1 3033 -E4/F4-1 6.15 =E6/F6-1 0 2017 18365 2019 38514 =C11/D11-1 -24281 2018 30723 =D11/E11-1 -12369 =B11/C11-1 =E11/F11-1 -27084 9928 -59611 =(B13/C13-1) =-(C13/D13-1) =-(D13/E13-1) =-(E13/F13-1) -1104 -10066 -7686 =(B15/C15-1) =-(C15/D15-1) =(D15/E15-1) =-(E15/F15-1) 25924 21653 17296 6410 -817/C17-1 -C17/D17-1 -D17/E17-1 -E17/F17-1 2016 135987 2371 4.9 0 2016 16443 -9876 -2911 9706 =(B2/F2)^(1/5)-1 =(B4/F4)^(1/5)-1 =(B6/F6)^(1/5)-1 CAGR -(B11/F11)^(1/5)-1 =(B13/F13)^(1/5)-1 ={B15/F15)^(1/5)-1 -(817/F17)^(1/5)-1 Conclusion 1. Looking at the sales data, the sales data has shown tremendous growth over the past 5 years growing at a CAGR of over 23%. 2. Sames goes with Earnings and EPS as well which have grown at a CAGR of over 50%. This indicates strong fundamentals of the giant. 3. The company has not declared dividends over many many years because Amazon is reinvesting the cash flows into the business. So, Amazon isn't ideal for those investors who seek regular income. 4. Talking about the cash flows, so, all the cash flows have shown positive CAGR except the Financing Cash Flow. Though the Financing cash flow has shown negative CAGR the latest cash flow is positive. 5. The company also has plenty of free cash flows which it can use the repay the debt or invest in Capex or pay dividends. So, that is a very huge plus point. 4 6 9 10 11 12 13 Cash Flows Net Operating Cash Flow Net Operating Cash Flow Growth Net Investing Cash Flow 14 Net Investing Cash Flow Growth 15 Net Financing Cash Flow All values in USD Millions Sales Sales you growth % Earnings Earnings you growth % EPS EPS you growth % Dividends 16 Net Financing Cash Flow Growth 17 Free Cash Flow Free Cash Flow Growth 18 19 20 21 22 23 24 25 2020 $386,064 37.62% $21,331 84.08% $42 81.95% $ 0.00 2019 $280,522 20.45% $11,588 15.04% $23 14.09% $0.00 2018 $232,887 30.93% $ 10,073 232.11% $ 20 227.64% $ 0.00 2018 $ 30,723 67.29% 2017 2016 $177,866 $135,987 30.80% $2,371 $5 $ 0.00 2020 2019 $ 38,514 $ 66,064 71.53% 25.36% 11.69% $ 59,611.00 $ 24,281.00 $ 12,369.00 $ 27,084.00 $9,876.00 $ 3,033 27.92% $6 25.51% $ 0.00 $ 17,296 169.83% 2017 $ 18,365 -145.50% -96.31% 54.33% -174.24% $1,104.00 $10,066.00 $7,686.00 $9,928.00 $2,911.00 89.03% -30.97% -177.42% 441.05% $25,924 $ 21,653 19.72% 25.19% $ 6,410 -33.96% 2016 $16,443 CAGR Formula = (Future Value/Beginning Value)^(1/n)-1 $9,706 CAGR 23.21% 55.17% 53.55% 32.07% 43.27% -17.63% 21.71% Amazon is a conglomerate technology company focusing on e-commerce, digital streaming, cloud computing, and artificial intelligence. The current share value of Amazon is $2,525 per share, and the analysis predicts the target into a median target of $2,730 per share with a high estimate of $3,300 and a low profile share value of $1,840. Company Background 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 All values in USD Millions Sales Sales yoy growth % Earnings Earnings you growth % EPS EPS yoy growth % Dividends Cash Flows Net Operating Cash Flow Net Operating Cash Flow Growth Net Investing Cash Flow Net Investing Cash Flow Growth Net Financing Cash Flow 16 Net Financing Cash Flow Growth Free Cash Flow 17 18 Free Cash Flow Growth 2020 386064 =B2/C2-1 21331 -B4/C4-1 41.83 =B6/C6-1 0 2019 280522 =C2/D2-1 11588 2020 66064 =C4/D4-1 22.99 =C6/D6-1 0 2018 232887 =D2/E2-1 10073 =D4/E4-1 20.15 =D6/E6-1 0 2017 177866 =E2/F2-1 3033 -E4/F4-1 6.15 =E6/F6-1 0 2017 18365 2019 38514 =C11/D11-1 -24281 2018 30723 =D11/E11-1 -12369 =B11/C11-1 =E11/F11-1 -27084 9928 -59611 =(B13/C13-1) =-(C13/D13-1) =-(D13/E13-1) =-(E13/F13-1) -1104 -10066 -7686 =(B15/C15-1) =-(C15/D15-1) =(D15/E15-1) =-(E15/F15-1) 25924 21653 17296 6410 -817/C17-1 -C17/D17-1 -D17/E17-1 -E17/F17-1 2016 135987 2371 4.9 0 2016 16443 -9876 -2911 9706 =(B2/F2)^(1/5)-1 =(B4/F4)^(1/5)-1 =(B6/F6)^(1/5)-1 CAGR -(B11/F11)^(1/5)-1 =(B13/F13)^(1/5)-1 ={B15/F15)^(1/5)-1 -(817/F17)^(1/5)-1 Conclusion 1. Looking at the sales data, the sales data has shown tremendous growth over the past 5 years growing at a CAGR of over 23%. 2. Sames goes with Earnings and EPS as well which have grown at a CAGR of over 50%. This indicates strong fundamentals of the giant. 3. The company has not declared dividends over many many years because Amazon is reinvesting the cash flows into the business. So, Amazon isn't ideal for those investors who seek regular income. 4. Talking about the cash flows, so, all the cash flows have shown positive CAGR except the Financing Cash Flow. Though the Financing cash flow has shown negative CAGR the latest cash flow is positive. 5. The company also has plenty of free cash flows which it can use the repay the debt or invest in Capex or pay dividends. So, that is a very huge plus point. 4 6 9 10 11 12 13 Cash Flows Net Operating Cash Flow Net Operating Cash Flow Growth Net Investing Cash Flow 14 Net Investing Cash Flow Growth 15 Net Financing Cash Flow All values in USD Millions Sales Sales you growth % Earnings Earnings you growth % EPS EPS you growth % Dividends 16 Net Financing Cash Flow Growth 17 Free Cash Flow Free Cash Flow Growth 18 19 20 21 22 23 24 25 2020 $386,064 37.62% $21,331 84.08% $42 81.95% $ 0.00 2019 $280,522 20.45% $11,588 15.04% $23 14.09% $0.00 2018 $232,887 30.93% $ 10,073 232.11% $ 20 227.64% $ 0.00 2018 $ 30,723 67.29% 2017 2016 $177,866 $135,987 30.80% $2,371 $5 $ 0.00 2020 2019 $ 38,514 $ 66,064 71.53% 25.36% 11.69% $ 59,611.00 $ 24,281.00 $ 12,369.00 $ 27,084.00 $9,876.00 $ 3,033 27.92% $6 25.51% $ 0.00 $ 17,296 169.83% 2017 $ 18,365 -145.50% -96.31% 54.33% -174.24% $1,104.00 $10,066.00 $7,686.00 $9,928.00 $2,911.00 89.03% -30.97% -177.42% 441.05% $25,924 $ 21,653 19.72% 25.19% $ 6,410 -33.96% 2016 $16,443 CAGR Formula = (Future Value/Beginning Value)^(1/n)-1 $9,706 CAGR 23.21% 55.17% 53.55% 32.07% 43.27% -17.63% 21.71%
Expert Answer:
Answer rating: 100% (QA)
According to the data O Amazon is a conglomerate technology 801 So we can calculate the fair valuu e... View the full answer
Related Book For
Intermediate Accounting
ISBN: 978-0077400163
6th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson
Posted Date:
Students also viewed these general management questions
-
1. Give your opinion as to whether or not additional laws and harsher penalties on financial fraud can eliminate or mitigate financial fraud. Support the rationale. 2. Suggest three (3) new...
-
Give your opinion as to whether or not the new procedures that the hospital implemented efficiently resolve the issues in this case. Next, suggest an additional procedure that the hospital could...
-
The company began operations on January 1, 2019. Purchases of property, plant, and equipment during 2019 were as follows: Cost Residual Value Jan 1, 2019 Land 1 3,000,000 3,000,000 Building 1...
-
An assistant treasurer is currently reevaluating their firm's banking relationship. The firm's current lender charges an effective borrowing cost of 4.25 percent. A competing lender provides the...
-
Minink Limited (ML) is a subsidiary of a large public company, federally incorporated 50 years ago. Until this year, ML's corporate structure consisted of three operating divisions and a corporate...
-
The Florida panther is an endangered species. Not long ago, one of these animals was hit by a car and seriously injured. He was taken to the state university veterinary medical school, where steel...
-
Explain why a sell-side analyst might be less objective than a buy-side analyst in his/her research reports. If an analyst is working for Merrill Lynch, where should the analysts loyalties liewith...
-
A firm makes two products: frying pans and saucepans. Frying pans sell for $30 each and saucepans sell for $20 each. The variable cost of making a frying pan is $20, and the variable cost of making...
-
The CEO at Stevens Distribution asks the top managers to redesign their organization to reduce the number of managers. This will help Question 2 9 options: centralize authority. create a mechanistic...
-
Bug-Off Exterminators provides pest control services and sells extermination products manufactured by other companies. The following six-column table contains the company's unadjusted trial balance...
-
Good afternoon, I need help with this assignment. Please use the table below. Thank you Adler's Delivery Service completed the following transactions during the month of July: A.Genesis Adler...
-
Joseph owns a lumber yard and is self-employed. He drove the following miles during 2023: 5,000 miles to and from his office located 10 miles from his home 7,400 miles driven from home to various...
-
[10](3) A uniform solid sphere of radius R and mass M = 5.0 kg rolls without slipping down a ramp (as shown in figure). The ramp is inclined at an angle = 30 to the horizontal. [2] (a) On the shown...
-
Situational theory has four leadership styles. List and explain each one. The Vroom-Jago Model had 7 diagnostic Questions. List and explain each one
-
The following information is available for Sandhill Company. Beginning accounts receivable $68,600 Ending accounts receivable 107.800 Net sales 1,323,000 Compute the accounts receivable turnover and...
-
On September 1, 2017, Sheffield Corporation acquired Aumont Enterprises for a cash payment of $1,500,000. At the time of purchase, Aumont's balance sheet showed assets of $580,000, liabilities of...
-
why companies follow residual dividend model policy with logical reason?
-
Would you use the adjacency matrix structure or the adjacency list structure in each of the following cases? Justify your choice. a. The graph has 10,000 vertices and 20,000 edges, and it is...
-
Transit Airlines provides regional jet service in the Mid-South. The following is information on liabilities of Transit at December 31, 2011. Transit's fiscal year ends on December 31. Its annual...
-
Refer to the situation described inBE 11-13. Assume that the fair value of SCC is $44 million instead of $40 million. What amount of impairment loss should WebHelper recognize?
-
Companies have a choice as to where in the financial statements to report comprehensive income. How does that choice differ between U.S. GAAP and IFRS?
-
Show that the BFGS formula (B.23) can be written as: \[ \mathbf{C} \leftarrow\left(\mathbf{I}-v \boldsymbol{g} \boldsymbol{\delta}^{\top} ight)^{\top} \mathbf{C}\left(\mathbf{I}-v \boldsymbol{g}...
-
In Exercise 12 above, we train the multi-logit classifier using a weight matrix \(\mathbf{W}\) \(\in \mathbb{R}^{3 \times 7}\) and bias vector \(\boldsymbol{b} \in \mathbb{R}^{3}\). Repeat the...
-
Derive the formula (B.25) for a diagonal Hessian update in a quasi-Newton method for minimization. In other words, given a current minimizer \(\boldsymbol{x}_{t}\) of \(f(\boldsymbol{x})\), a...
Study smarter with the SolutionInn App