I need help with the following question - finding the NPV. the assignment is as follows:

Magic Timber and Steel (Magic) has two options:

Keep the old machine, the Matrix 750, by spending money upfront to service and improve its output.

Buy the new and improved machine, the Delta A390.

Performed NPV calculation and the following table is the result.

NPV of Purchasing Delta

Calculation of Tax

Repair costs saved (old) 28,000 Maintenance saved (old) 7,000 7,000 7,000 7,000 7,000

Major service saved (old) 4,000

Labour saving (new) 5,250 5,500 5,750 6,000 6,250

Electricity saving (new) 4,725 4,800 4,875 4,950 5,025

Maintenance (new) -2,000 -3,000 -4,000 -5,000 -6,000

Depreciation foregone (old) 6,000 6,000 6,000 6,000 6,000

Depreciation (new) -14,000 -14,000 -14,000 -14,000 -14,000

Profit/loss on sale (new)* -10,000

Taxable income 28,000 6,975 6,300 9,625 4,950 -5,725

Tax payable (saving) 8,400 2,093 1,890 2,888 1,485 -1,718

Cash Flows

Sale of MATRIX 35,000

Cost of DELTA -140,000

Scrap foregone (old) -5,000

Repair costs saved (old) 28,000

Maintenance saved (old) 7,000 7,000 7,000 7,000 7,000

Major service saved (old) 4,000

Selling price (new) 60,000

Labour saving (new) 5,250 5,500 5,750 6,000 6,250

Electricity saving (new) 4,725 4,800 4,875 4,950 5,025

Maintenance (new) -2,000 -3,000 -4,000 -5,000 -6,000

LESS TAX -8,400 -2,093 -1,890 -2,888 -1,485 1,718

CASH FLOWS -85,400 12,883 12,410 14,738 11,465 68,993

Discount factors at cost of capital 1 0.9009 0.8116 0.7311 0.6587 0.5934

Discounted cash flows (DCF) -$85,400 $11,606 $10,072 $10,776 $7,552 $40,944

Net Present Value (sum of DCF) -$4,450

Sensitivity analysis

Change the discount rate to 12 per cent.

Change the Year 5 selling price of the Delta to $80,000.

Change the maintenance costs for the Delta: Year 1 costs are $1,000, increasing by $1,000 each year.

Change all of the above factors together. The results are as follows,

Change the discount rate to 12 per cent: NPV = -$7,080

Change the Year 5 selling price of the Delta to $80,000: NPV = $3,858

Change the maintenance costs for the Delta: Year 1 costs are $1,000, increasing by $1,000 each year: NPV = -$1,863

Change all the above factors together: NPV = $3,387