Frito Lay is determining whether to purchase a new piece of equipment, which has a base price of $450,000 and would cost another $34,000 to install. Using the equipment requires a $25,000 investment in additional assets, which will not be sold after this project. This represents the purchase of additional assets required to use the new equipment.

The equipment would be sold after three years for $100,000 and the depreciation allocated to each of those years is listed below. Upon the sale, the before-tax gain will be $61,000.

Year 1 = $160,000 Year 2 = $210,000 Year 3 = $75,000

Although it would not affect revenues, the equipment should save the firm $180,000 per year in before-tax operating costs (excluding depreciation). Frito Lays marginal tax rate is 40%, and its required rate of return is 14%.

Calculate the total initial investment, the total supplemental cash flows for each year 1 - 3, the terminal cash flows, and the NPV for the project, and state if the equipment should be purchased in a full sentence. Remember terminal cash flows are the after-tax cash flow plus the additional assets that were used in the initial investment because they are returned after the project is over.

For each of these calculations, just showing numbers does not constitute showing your work. You need to give the formula you are using in words and then show substitution.

Below is a template for your work.

Step 1: Initial Investment =

Step 2: Supplemental Cash Flows =

Step 3: Terminal Cash Flows =

Step 4: Net Present Value Analysis =

Step 5: Decision =