An existing project is nearing its end. The machine that is currently being used and will not be replaced. It could be sold today for $50,000, or kept for up to 5 more years. Determine whether the project should be abandoned now, or whether the machine should continue to be used, and if so determine the endyear when it should be sold. The table below gives the projected annual revenues and expenses attributed to the machine, and its projected end-of-the-year market values. Assume 6% cost of capital.

Year Revenues Expenses Machine year-end market value

1 75,000 15,000 40,000

2 70,000 16,000 30,000

3 60,000 17,000 25,000

4 45,000 18,000 20,000

5 25,000 20,000 15,000

Solve it using XL and show the functions that has been used