Green Zebra Grocery (GZ) is considering replacing its current kitchen equipment with a technology that will allow for greater flexibility in producing grab and go food and, at the same time, greater cost efficiency. The existing machinery is in good operating condition but company analysts have estimated that buying the new equipment with flexible cooking & storage patterns would allow them to better meet the needs of all of its stakeholders. The old equipment has a current pook value of $260million with a remaining life of four years. The company has been using straight-line depreciation to depreciate this asset towards a zero salvage value for tax purposes. However, based upon current estimates, company experts are estimating a $65 million salvage value at the end of the assets' useful life (at T4). If sold today, the company would receive $75 million. The new kitchen equipment will cost $350 million and will be depreciated as a 3 year MACRS asset even though it is expected to have a four year economic life. Although increased efficiencies are expected to occur, the additional sales of $115 million per year will require a slight increase in operating expenses of $17 million per year. GZ estimates that working capital will increase by $23m with the adoption of the new machine. To prepare the site for installation, an nvestment of $27m will be required. This installation cost will be added to the equipment cost and depreciated. Full recovery of working capital is expected in four years, and the company estimates they can sell the equipment at that time for $85 million. GZ's marginal tax rate is 25 percent and this project requires a discount rate of 8%. putline what you know by placing the name of an input in one column and the amount in the adjacent, column, as shown by the example inputs below. Cost of New Store Equipment $485 Tax rate 25% Calculate BV, Depreciation and Amortization Schedule Years 0 1 2 3 4 33.0% 45.0% 15.0% 7.0% New Equipment Equipment Deprn Rate Equipment Deprn, Dollars Ending Book Value NEW Equipment Net T4 Salvage Values (OLD) OLD Equipment Net T4 Salvage Values (NEW) Net cash flow from salvage, NEW Net cash flow from salvage, OLD = Net change in expected salvage value, after tax (new - O Projected Net Cash Flows (Time line of annual cash flows) Year Investment Outlays at Time Zero: 0 1 2 3 4 Total Outlay @ To: Operating Cash Flows over the Project's Life: Operating Cash Flows over the Project's Terminal Year Cash Flows: et Pjt Cash Flows (Time line of cash flow: Operating Cash Flows over the Project's Life: Terminal Year Cash Flows: Net Pjt Cash Flows (Time line of cash flows) Key Output: Appraisal of the Proposed Project Net Present Value MIRR Green Zebra Grocery (GZ) is considering replacing its current kitchen equipment with a technology that will allow for greater flexibility in producing grab and go food and, at the same time, greater cost efficiency. The existing machinery is in good operating condition but company analysts have estimated that buying the new equipment with flexible cooking & storage patterns would allow them to better meet the needs of all of its stakeholders. The old equipment has a current pook value of $260million with a remaining life of four years. The company has been using straight-line depreciation to depreciate this asset towards a zero salvage value for tax purposes. However, based upon current estimates, company experts are estimating a $65 million salvage value at the end of the assets' useful life (at T4). If sold today, the company would receive $75 million. The new kitchen equipment will cost $350 million and will be depreciated as a 3 year MACRS asset even though it is expected to have a four year economic life. Although increased efficiencies are expected to occur, the additional sales of $115 million per year will require a slight increase in operating expenses of $17 million per year. GZ estimates that working capital will increase by $23m with the adoption of the new machine. To prepare the site for installation, an nvestment of $27m will be required. This installation cost will be added to the equipment cost and depreciated. Full recovery of working capital is expected in four years, and the company estimates they can sell the equipment at that time for $85 million. GZ's marginal tax rate is 25 percent and this project requires a discount rate of 8%. putline what you know by placing the name of an input in one column and the amount in the adjacent, column, as shown by the example inputs below. Cost of New Store Equipment $485 Tax rate 25% Calculate BV, Depreciation and Amortization Schedule Years 0 1 2 3 4 33.0% 45.0% 15.0% 7.0% New Equipment Equipment Deprn Rate Equipment Deprn, Dollars Ending Book Value NEW Equipment Net T4 Salvage Values (OLD) OLD Equipment Net T4 Salvage Values (NEW) Net cash flow from salvage, NEW Net cash flow from salvage, OLD = Net change in expected salvage value, after tax (new - O Projected Net Cash Flows (Time line of annual cash flows) Year Investment Outlays at Time Zero: 0 1 2 3 4 Total Outlay @ To: Operating Cash Flows over the Project's Life: Operating Cash Flows over the Project's Terminal Year Cash Flows: et Pjt Cash Flows (Time line of cash flow: Operating Cash Flows over the Project's Life: Terminal Year Cash Flows: Net Pjt Cash Flows (Time line of cash flows) Key Output: Appraisal of the Proposed Project Net Present Value MIRR