Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the implied return for the AMAZON stock. Calculate alpha the risk adjusted excess return. Use graphs or plots if needed. Real time current stock

Calculate the implied return for the AMAZON stock. Calculate alpha the risk adjusted excess return. Use graphs or plots if needed.

Real time current stock : 3,223.91 USD May 11, 9:56 PM

image text in transcribed
use real time stock data from amazon 2021
All values in USD Millions Sales Sales yoy growth Earnings Earnings yoy growth EPS EPS yoy growth Dividends 2020 386064 -82/02-1 21331 -84/04-1 41.83 -B6/C6-1 0 2019 280522 -C2/02-1 11588 C4/04-1 22.99 -C6/06-1 0 2018 232887 02/E2-1 10073 04/04-1 20.15 -06/E6-1 0 2017 177866 E2/52-1 3033 4/64-1 6.15 -E6/F6-1 0 2016 CAGR 135987 (82/F2741/5)-1 2371 (84/44771/5)-2 49 (86/F67(1/5)-1 -(811/F117(1/5) Cash Flows 2020 2019 2018 2017 2016 Net Operating Cash Flow 66064 38514 30723 18365 16443 Net Operating Cash Flow Growth-611/011-111/011-1 011/E11-1 E11/F11-1 Net Investing Cash Flow -59611 -24281 -12369 27084 -9876 Net Investing Cash Flow Growth -(813/C13-1) - C13/013-1) -- (013/E13-1) --E13/F13-1) Net Financing Cash Flow 1104 -10066 -7686 9928 2911 Net Financing Cash Flow Growth =-(815/C15-1) =1C15/015-1) 015/E15-1) = {E15/515-1) Free Cash Flow 2592421653 17296 6410 Free Cash Flow Growth -817/017-1C17/017-2017/E17-117/F17-1 (813/513)(1/5) =815/F2SY41/5) (817/F17/11/5H1 9706 inclusion Looking at the sales data, the sales data has shown tremendous growth over the past wears growing at a CAGR of over 23% Sames goes with Earnings and EPS as well which have grown at a CAGR of over 50% is indicates strong fundamentals of the giant. The company has not declared dividends over many many years cause Amazon is reinvesting the cash flows into the business. So, Amazon isn't ideal for those estors who seek regular income. Talking about the cash flows, so, all the cash flows have shown positive CAGR except the ancing Cash Flow. Though the Financing cash flow has shown negative CAGR the latest sh flow is positive. The company also has plenty of free cash flows which it can use the repay the debt or invest in pex or pay dividends. So, that is a very huge plus point. All values in USD Millions Sales Sales yoy growth Earnings Earnings yoy growth EPS EPS yoy growth Dividends 2020 386064 -82/02-1 21331 -84/04-1 41.83 -B6/C6-1 0 2019 280522 -C2/02-1 11588 C4/04-1 22.99 -C6/06-1 0 2018 232887 02/E2-1 10073 04/04-1 20.15 -06/E6-1 0 2017 177866 E2/52-1 3033 4/64-1 6.15 -E6/F6-1 0 2016 CAGR 135987 (82/F2741/5)-1 2371 (84/44771/5)-2 49 (86/F67(1/5)-1 -(811/F117(1/5) Cash Flows 2020 2019 2018 2017 2016 Net Operating Cash Flow 66064 38514 30723 18365 16443 Net Operating Cash Flow Growth-611/011-111/011-1 011/E11-1 E11/F11-1 Net Investing Cash Flow -59611 -24281 -12369 27084 -9876 Net Investing Cash Flow Growth -(813/C13-1) - C13/013-1) -- (013/E13-1) --E13/F13-1) Net Financing Cash Flow 1104 -10066 -7686 9928 2911 Net Financing Cash Flow Growth =-(815/C15-1) =1C15/015-1) 015/E15-1) = {E15/515-1) Free Cash Flow 2592421653 17296 6410 Free Cash Flow Growth -817/017-1C17/017-2017/E17-117/F17-1 (813/513)(1/5) =815/F2SY41/5) (817/F17/11/5H1 9706 inclusion Looking at the sales data, the sales data has shown tremendous growth over the past wears growing at a CAGR of over 23% Sames goes with Earnings and EPS as well which have grown at a CAGR of over 50% is indicates strong fundamentals of the giant. The company has not declared dividends over many many years cause Amazon is reinvesting the cash flows into the business. So, Amazon isn't ideal for those estors who seek regular income. Talking about the cash flows, so, all the cash flows have shown positive CAGR except the ancing Cash Flow. Though the Financing cash flow has shown negative CAGR the latest sh flow is positive. The company also has plenty of free cash flows which it can use the repay the debt or invest in pex or pay dividends. So, that is a very huge plus point

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Reckless The Story Of Cryptocurrency Interest Rates

Authors: Jonathan Bier

1st Edition

979-8354857289

More Books

Students also viewed these Finance questions

Question

Discuss the states of accounting

Answered: 1 week ago