Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You need to write around 1000 words for this project. Just for Amazon analysis (just this company). I attached the requirement and some data about
You need to write around 1000 words for this project. Just for Amazon analysis (just this company). I attached the requirement and some data about Amazon (source is from Bloomberg). You can find other useful information and data about Amazon from Internet to help you write the paper. Please use APA format. You can add tables, graphs, etc. into the paper. If you have any questions, please feel free to let me know. Thank you.
Amazon.com Inc (AMZN US) - asd In Millions of USD except Per Share 12 Months Ending Basic EPS FCF/share Sales/share Source: Bloomberg Current shares outstanding FY 2004 12/31/2004 1.45 1.18 17.05 FY 2005 12/31/2005 0.87 1.28 20.61 FY 2006 12/31/2006 0.46 1.17 25.75 FY 2007 12/31/2007 1.15 2.86 35.92 408.05 6.9% 414.47 6.2% 411.92 4.5% 415.18 8.0% Sales FCF Shares Outs. FCF/Share FY 2008 12/31/2008 1.52 3.22 45.31 FY 2009 12/31/2009 2.08 6.74 56.60 FY 2010 12/31/2010 2.58 5.63 76.52 FY 2011 12/31/2011 1.39 4.62 106.13 FY 2012 12/31/2012 -0.09 0.87 134.86 FY 2013 12/31/2013 0.60 4.44 162.91 FY 2014 12/31/2014 -0.52 4.22 192.61 428.83 7.1% 432.98 11.9% 448.84 7.4% 454.75 4.4% 452.96 0.6% 457.73 2.7% 463.01 2.2% Average: 5.6% 2016 2017 2018 $ 130,198.30 $ 156,312.30 $ 185,889.20 Used FA to find forecasts of sales $ 7,245.81 $ 8,699.11 $ 10,345.12 Assumed 5.6% FCF/Sales ratio based on past 10 years 471.59 471.59 471.59 $ 15.36 $ 18.45 $ 21.94 FY 2015 12/31/2015 1.28 15.70 229.13 468.76 6.9% Last 12M FY 2016 Est FY 2017 Est 12/31/2015 12/31/2016 12/31/2017 1.28 4.48 8.65 15.57 228.74 471.59 Amazon.com Inc (AMZN US) - Adj Highlights In Millions of USD 12 Months Ending Market Capitalization - Cash & Equivalents + Preferred & Other + Total Debt Enterprise Value Revenue, Adj Growth %, YoY Gross Profit, Adj Margin % EBITDA, Adj Margin % Net Income, Adj Margin % EPS, Adj Growth %, YoY Cash from Operations Capital Expenditures Free Cash Flow Source: Bloomberg FY 2009 12/31/2009 59,726.9 6,366.0 0.0 381.0 53,741.9 FY 2010 12/31/2010 81,180.0 8,762.0 0.0 865.0 73,283.0 FY 2011 12/31/2011 78,760.5 9,576.0 0.0 1,939.0 71,123.5 FY 2012 12/31/2012 113,895.0 11,448.0 0.0 4,964.0 107,411.0 FY 2013 12/31/2013 183,044.6 12,447.0 0.0 6,889.0 177,486.6 24,509.0 27.9 5,531.0 22.6 1,558.0 6.4 932.6 3.8 2.11 51.7 34,204.0 39.6 7,643.0 22.3 1,974.0 5.8 1,151.4 3.4 2.53 19.9 48,077.0 40.6 10,789.0 22.4 1,945.0 4.0 628.4 1.3 1.36 -46.0 61,093.0 27.1 15,122.0 24.8 2,910.0 4.8 173.3 0.3 0.38 -72.3 74,452.0 21.9 20,271.0 27.2 4,010.0 5.4 285.4 0.4 0.61 62.3 3,293.0 -373.0 2,920.0 3,495.0 -979.0 2,516.0 3,903.0 -1,811.0 2,092.0 4,180.0 -3,785.0 395.0 5,475.0 -3,444.0 2,031.0 FY 2014 12/31/2014 144,312.8 17,416.0 0.0 16,089.0 142,985.8 FY 2015 Current/LTM FY 2016 Est FY 2017 Est FY 2018 Est 12/31/2015 12/31/2015 12/31/2016 12/31/2017 12/31/2018 318,344.2 295,896.7 19,808.0 19,808.0 0.0 0.0 17,547.0 17,547.0 316,083.2 293,635.7 88,988.0 19.5 26,406.0 29.7 5,094.0 5.7 -130.5 -0.1 -0.28 107,006.0 20.2 35,355.0 33.0 8,514.0 8.0 599.3 0.6 1.26 107,007.0 20.2 35,356.0 33.0 8,514.0 8.0 599.3 0.6 1.24 122.7 130,198.3 21.7 44,924.9 34.5 13,889.8 10.7 4,495.6 3.5 9.31 640.7 156,312.3 20.1 56,658.5 36.2 18,480.8 11.8 6,847.7 4.4 14.09 51.3 185,889.2 18.9 70,080.2 37.7 24,570.9 13.2 11,190.3 6.0 20.53 45.8 6,842.0 -4,893.0 1,949.0 11,920.0 -4,589.0 7,331.0 11,920.0 -4,588.0 7,332.0 -5,666.3 10,022.3 -6,747.5 12,241.2 -7,592.6 17,453.0 Weight Cost WxC 3 Equity 94.80% 9.10% 8.60% 4 Debt Cost ( 5.20% 1.00% 0.10% 5 Preferred E 0.00% 0.00% 0.00% Rough apprWACC Economic Value Added (Millions of USD) 7 Net Operat 2211 8 Cash Opera 1349 9 NOPAT 862 Total Inves 31120 Capital Cha 2705.12 Economic V -1843.12 ROIC EVA Spread 2.77% -5.92% 8.70% Market Ca 318,344.20 94.80% ST Debt 3,364.00 1.00% LT Debt 14,183.00 4.20% Pref. Eqty 0 0.00% Total 335,891.20 100.00%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started