Can you help to solve this, need the answer ASAP. Thank you

XYZ Manufacturing Corporation wants to purchase new equipment for its plant to streamline production. Information regarding purchase price and net cash inflows for three possible pieces of equipment that XYZ can purchase are shown below. Assume that the required rate of return and the discount rates are both 8% and XYZ uses straight-line depreciation. The present value tables are provided at the end of the problem. Option A Option B Option C Initial Investment $ 100,000 $ 150,000 $ 120,000 Net Cash Inflows Year 1 $ 35,000 Year 2 $ 32,000 Year 3 $ 30,000 $50,000 per $25,000 per year for 4 year for 5 years years Year 4 $ 27.000 Year 5 $ 26,000 Residual Value $ $ $ 5,000 Requirements: Calculate the NPV of each scenario below. Round to the nearest whole number. Do NOT use decimals. Option A Option B Option C NPV Which option should the Company select? LG Which option should the Company select? The selected option provides an IRR 8%. (Choices: greater than, less than, equal to) Present Value Table Present Value of a $1 Present Value of an Annuity of $1 Period 8% Period 8% 1 0.926 1 0.926 2 0.857 2 1.783 0.794 3 2.577 4 0.735 4 3.312 5 0.681 5 3.993