Calculate the net present value and the internal rate of return. For the net present value calculation, use a 3% discount rate. Use a spreadsheet program (e.g., Microsoft Excel, OpenOffice Calc, etc) to perform the calculation.

NPV Calculations 2. Considerthe following data all expressed in dollars: Timeline Today.r Year1 Year2 Year 3 \\"earr Year5 Purchase price 40,000} Maintenance cost [2000} (2,000} (2.000} [1.000) [500} Labor savings 12.000 12.000 12,000 (12000} (12,000} Salvage value 3.000 Total cash in {out} (40,000} 10.000 10.000 10.000 11.000 14.500 1. Calculate the net present value and the internal rate of return. For the net present value calculation. use a 3% discount rate. 2. Use a spreadsheet program {e.g., Microsoft Excel, DpenDlce Calc, etc} to perform the calculation