As soon as possible please!
THIS SHEET NOT DONE YET when you are Finished with this exercise, change the status to \"DONE!" ALT-NFV Merlot City is planning to purchase a large computer. The computer system requires a payment now for hardware in the amount of $80,000 and software in the amount of $30,000. The new computer would result in savings of $24,000 per year. A system upgrade would be necessary in year 3 in the amount of $19,000. At the end ofits 5-year life, the computer could be sold for salvage value of $9,000. I II Additionally, spare computer time could be sold for $11,000 in years 1-5. Compute the NPV using a cost of capital of8.00%. Use positive numbers for cash inows, use neggive numbersfor cash outows. Years 0 1 1 3 4 5 Purchase of Computer Hardware Purchase of Computer Software Total Project Cost in Time Period 0 Savings System Upgrade Revenue from Time Sharing Salvage Value Net Annual Cash Flows Discount Factors at 8% Discounted Cash Flows Net Present Value PV OFSl.00 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 1 0.9901 0.9304 0.9709 0.9615 0.9524 0.9434 0.9346 0.9259 0.9174 0.9091 0.9009 0.3929 0.3350 0.3772 0.3696 2 0.9303 0.9612 0.9426 0.9246 0.9070 0.3900 0.3734 0.3573 0.3417 0.3264 0.3116 0.7972 0.7331 0.7695 0.7561 3 0.9706 0.9423 0.9151 0.3390 0.3633 0.3396 0.3163 0.7933 0.7722 0.7513 0.7312 0.7113 0.6931 0.6750 0.6575 4 0.9610 0.9233 0.3335 0.3543 0.3227 0.7921 0.7629 0.7350 0.7034 0.6330 0.6537 0.6355 0.6133 0.5921 0.5713 5 0.9515 0.9057 0.3626 0.3219 0.7335 0.7473 0.7130 0.6306 0.6499 0.6209 0.5935 0.5674 0.5423 0.5194 0.4972 PV OF AN ANNUITY OF $1.00 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 1 0.9901 0.9304 0.9709 0.9615 0.9524 0.9434 0.9346 0.9259 0.9174 0.9091 0.9009 0.3929 0.3350 0.3772 0.3696 2 1.9704 1.9416 1.9135 1.3361 1.3594 1.3334 1.3030 1.7333 1.7591 1.7355 1.7125 1.6901 1.6631 1.6467 1.6257 3 2.9410 2.3339 2.3236 2.7751 2.7232 2.6730 2.6243 2.5771 2.5313 2.4369 2.4437 2.4013 2.3612 2.3216 2.2332 4 3.9020 3.3077 3.7171 3.6299 3.5460 3.4651 3.3372 3.3121 3.2397 3.1699 3.1024 3.0373 2.9745 2.9137 2.3550 5 4.3534 4.7135 4.5797 4.4513 4.3295 4.2124 4.1002 3.9927 3.3397 3.7903 3.6959 3.6043 3.5172 3.4331 3.3522