Capital Budgeting for Equipment Replacement Free work cells Answer cells Madrid Chips is a manufacturer of prototype chips based in Madrid, Spain. Madrid's Chief Marketing Officer has provided the following forecast: 2018 Volume Forecast (Units): 2018 Average Selling Price: Annual Volume Growth (%): Annual Selling Price Increase (%) 615 $95,000 10% 5% To address future demand, Madrid is considering replacing its production equipment. The old equipment is fully depreciated and can be sold for a salvage if the plant is replaced. Any required working capital investment is to be recouped at the end of the project's life. Initial investment in 2018 Replace $66,300,000 Disposal of old equipment (pre-tax) Working capital investment (invested on day 1 and recocovered at final disposal) $4,200,000 $11,000,000 Terminal disposal value in 2024 (pre-tax) $16,000,000 Useful life (Years) 7 Total annual cash operating costs per prototype chip $66,000 Annaul cash operating cost increase (%) 2% 14% 35% Required Rate of Return Applicable Tax Rate Madrid Chips uses straight-line depreciation assuming zero terminal disposal value. Madrid is subjected to a 35% income tax rate on operating income and gains/losses (e.g. on disposal of assets). Assume the initial investment is made at the beginning of 2018 and all transactions thereafter occur on the last day of the year. Answer cells must remain in the same location so do not insert/delete columns or rows in the file. Numeric answers must include a formula or reference so do not hard enter the answer. 1. Calculate operating income and net income (gains and losses on disposal, interest, and taxes are considered non-operating items). 2. Calculate net cash flows 3. Calculated discounted cash flows 4. Calculate the Net Present Value, Internal Rate of Return, and Payback Period