Amazon.com (ticker: AMZN) is considering installing a new and highly sophisticated computer system to help expand its business, which would cost $74 million. Delivery and installation would add another $1.3 million to the initial cost. The new computer system has a 5-year class life under MACRS. Because of the half-year convention, it will take six years for Amazon to fully depreciate the cost of the system (MACRS percentages: 20, 32, 19, 12, 11 and 6 percent), and at the end of Year 6 the salvage value of the system is estimated to be $5.487 million. Additional data: If the new system is purchased, revenue is expected to increase over the present level by $103 million in each of the first three years, by $96 million in Year 4, and by $88 million in Years 5 and 6. (These improvements are incremental, not cumulative.) The increase in operating costs is projected at $71.5 million for each of the six years. Amazons federal-plus-state income tax rate is 37.5 percent. The projects cost of capital is 8.5 percent. It is expected that installation of the new system would cause the following changes in working capital accounts (1) an increase in receivables of $26 million because of expanded services, (2) an increase in inventories of $5.5 million, and (3) an increase in accounts payable and accruals combined equal to $8 million. Using Excel, do the following: A. State the basic assumptions of the problem in an assumption block. This means that you should display in the upper left-hand corner of the spreadsheets all the relevant quantitative information given above, whether it actually changes in the problem or not. 1. Follow the analysis provided in your Ch. 12 PowerPoints and Table 12.1 in the e-book. The main difference is this project runs for six years while the example in the book runs for just four years. 2. Calculate the net cash outflow at time zero (t = 0) if Amazon goes ahead with this expansion. 3. Construct a table similar to that shown below to calculate net operating cash flows for Years 1 through 6 (in thousands). 4. Calculate the NPV of the expansion project (NPV = PV of all cash flows minus cash outflow at t = 0). I recommend you check the answer you get in Excel with your calculator. Both NPVsin Excel and with the calculatorshould be equal. Year 1 2 3 4 5 6 Revenue _________ _________ _______ _______ _______ _______ Operating costs _________ _________ _______ _______ _______ _______ Depreciation (DEP) _________ _________ _______ _______ _______ _______ Income before tax _________ _________ _______ _______ _______ _______ Taxes _________ _________ _______ _______ _______ _______ Net income (NI) _________ _________ _______ _______ _______ _______ Operating cash flow (NI + DEP) _________ _________ _______ _______ _______ _______ Recovery of Working Capital _______ Salvage after tax _______ Total project cash flows (operating + non-operating) _________ _________ _______ _______ _______ _______ NPV _________

Please, show your work in excel!!!

Thank you,