I dont know how to calculate the NPV. More specifically, I dont know how the factor part was calculated.

4 Previous Co) Dashboard Calendar To Do 9:11 PM Wed Jun 14 Back k Sheet1 Sheet2 MGT - 5 MANAGERIAL ACCOUNTING PROBLEM 12B2 GIVEN: NEW MACHINE COST DEPR LIFE YEARS (S/L) ANNUAL SAVINGS SALES PRICE OLD MACHINE NBV OLD MACHINE DEPR YEARS REMAINING OVERHAUL OF NEW MACHINE YEAR OF OVERHAUL TAX RATE DISCOUNT RATE REQUIRED CALCULATE NPV COST/TODAY COST SALES PRICE OLD MACHINE NBV GAIN/LOSS TAX COST File Details MGT 5 - Managerial Accounting - Houskeeper [SF Sheet 3 ANNUITY ANNUAL SAVINGS DEPR TAXABLE INCOME TAX ANNUITY PRESENT VALUE ANNUITY DEPR OFFSET OVERHAUL COST NET PRESENT VALUE REQUIRED CASH 118,000 (NOTE: WE EXCLUDE THE OVERHAUL SINCE IT IS NON-RECURRING) Previous Co) Dashboard Calendar TO Do