Pliss show the solution step by step and use Excel formulas, thank you.

AMT, Inc., is considering the purchase of a digital camera for the maintenance of design specifications by feeding pictures directly into an engineering workstation where computer-aided design files can be superimposed over the digital pictures. Differences between the two images can be noted, and corrections as appropriate, can then be made by design engineers. The capital investment requirements is $345,000 and the estimated market value of the system after six-year study period is $115,000. Annual revenues attributable to the new camera system will be $120,000, whereas additional annual expenses will be $22,000. You have asked by management to determine the IRR (tir) \& NPV (vpn)of this project and to make a recommendation. The corporation 's MARR (trema) is 20% per year