can you use excel?

Economic Life The Scampini Supplies Company recently purchased a new delivery truck. The new truck cost $22,500, and it is expected to generate net after-tax operating cash flows, including depreciation, of $6,250 per year. The truck has a 5-year expected life. The expected salvage values after tax adjustments for the truck are given below. The company's cost of capital is 12 percent. Year 0 1 2 Annual Operating Cash Flow -$22,500 6,250 6,250 6,250 6,250 6,250 Salvage Value $22,500 17,500 14,000 11,000 5,000 0 3 4 5 a. What is the optimal number of years to operate the truck? Do not round intermediate calculations. Round your answers to the nearest whole number. years b. Would the introduction of salvage values, in addition to operating cash flows, ever reduce the expected NPV and/or IRR of a project? I. Salvage possibilities would have no effect on NPV and IRR. II. No. Salvage possibilities could only raise NPV and IRR. III. Yes. Salvage possibilities could only lower NPV and IRR. -Select