help with option 2, questions 1-5 at the bottom.

Please give detail regarding the calculations.

The company's average reported net income is $1,250,000. The team is considering the following options Option 1: The asset cost is $300,000. The asset is expected to have a 10-year useful life with no salvage value. Straight-line depreciation is used. The net cash inflow is expected to be $89,000 each year for 10 years. The company uses a 12% discount rate in evaluating capital investments. Option 2: The asset cost is $575,000. The machine is expected to have a 10-year useful life with no salvage value. Straight-line depreciation is used. The net cash inflow is expected to be $142,000 each year for 10 years. The company uses a 12% discount rate in evaluating capital investments. Option 3: The asset cost is $280,000, The asset is expected to have a 10-year useful life with no salvage value. Straight-line depreciation is used. The net cash inflow is expected to be $62,000 each year for 10 years. The company uses a 12% discount rate in evaluating capital investments. REQUIRED You may use Excel's built-in functions for NPV and IRR. Compute the following fo options: 1.Payback period (assume the that cash inflows occur evenly throughou 2.ARR based on initial investment 3.NPV (assume that cash inflows occur at year-end) 4.Internal rate of return (IRR) 5. Present Value Index