SOLVE WITH EXCEL FUNCTIONS

It is studied between two methods to produce the case of a portable photoionization monitor made of hazardous material. One of the cases would be plastic and would require an initial investment of $ 75,000 and would have an annual operating cost of $ 27,000, with no salvage value after two years. An aluminum case would require an investment of $ 125,000, with annual costs of $ 12,000 and some of the equipment can sell for $ 30,000 after three years of life. With an interest rate of 10% per annum compounded semi-annually, which case should be used based on present value analysis?

Remember excel.