Question
Suppose Amazon has decided to introduce the Echo II. Before they launch the Echo II, they conducted an analysis to see if the Echo II
Suppose Amazon has decided to introduce the Echo II. Before they launch the Echo II, they conducted an analysis to see if the Echo II would be a desirable investment. The company estimated that it would sell 2 million Echo IIs per year at a price of $160 for the next six years. The initial capital outlay is determined to be $1 billion and a $400 million outlay in net working capital would also be required. Assume that the equipment used will be depreciated using the MACRS 7 year schedule and that the equipment has a salvage value of zero. At the end of year 6, the equipment will be sold for its book value. Also, assume that that the tax rate is 35%. | |
1. | Using information from Amazons financial statements (you may want to use Morningstar.com or some other online site) estimate the operating cash flows from the project. Make any simplifying assumptions that are necessary to produce the estimate. |
2. | If the cost of capital is 13%, compute the NPV and IRR for the project. Test the sensitivity of NPV to changes in the cost of capital by increasing the WACC by 1%. |
3. | Test the sensitivity of NPV and IRR to changes in the growth rate of sales. Use a -2% 0% and 2% growth rate for sales in your analysis. (use the original 13% cost of capital for this part of the assignment). |
4. | Test the sensitivity of NPV and IRR to changes in the cost of goods sold percentage. Use a percentage that is 3% less than the number you originally estimated to do the computation. Then recalculate using a percentage that is 3% more than you originally estimated. For example, if you used 80%, redo the calculations using 77% and 83%. |
5. | Use the 10 year Treasury Bond rate as the risk free rate and assume that the market risk premium is 8% to find Amazons cost of equity. Assume that Amazons bonds are rated AAA and that Amazons corporate tax rate is 35%. Find Amazons weighted average cost of capital. Assume that the project will be financed with internal funds. You will need to find additional financial information from the Wall Street Journal and online at sites like http://finance.yahoo.com to complete your calculation. |
6. | Using your cost of capital estimates in part 5, recalculate the original NPV and IRR using these new estimates. (Redo part 2, but use the number you estimated instead of 13%). |
7. | Write up your findings and determine if Amazon should produce the Echo II. You do not need to submit a spreadsheet for every calculation. Just summarize your results in a table and submit one spreadsheet. Given your analysis, should Amazon proceed with the Echo II? |
AMAZON.COM INC (AMZN) Statement of CASH FLOW Fiscal year ends in December. USD in millions except per share data 2012-12 Cash Flows From Operating Activities 2013-12 2014-12 2015-12 2016-12 TTM Depreciation & amortization 5 Net cash provided by operating activities Cash Flows From Investing Activities Investments in property, plant, and equipment Net cash used for investing activities Excess tax benefit from stock based compensation Net cash provided by (used for) financing activities Effect of exchange rate changes 1 Supplemental schedule of cash flow data AMAZON.COM INC (AMZN) Statement of CASH FLOW Fiscal year ends in December. USD in millions except per share data 2012-12 Cash Flows From Operating Activities 2013-12 2014-12 2015-12 2016-12 TTM Depreciation & amortization 5 Net cash provided by operating activities Cash Flows From Investing Activities Investments in property, plant, and equipment Net cash used for investing activities Excess tax benefit from stock based compensation Net cash provided by (used for) financing activities Effect of exchange rate changes 1 Supplemental schedule of cash flow data
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