X Data Table Year 1 Year 2 $ $ Year 3 Year 4 1,300,000 1,500,000 2,400,000 3,100,000 4,300,000 5,400,000 $ Year 5 $ $ Year 6 Print Done i Requirements 1. Calculate the payback period of the solar panels. 2. Calculate the ARR of the solar panels. 3. Should Humboldt turn down the solar panel investment or consider it further? Print Done Humboldt is considering investing in solar paneling for the roof of its large distribution facility. The investment will cost $9 million and have a six-year useful life and no residual value. Because of rising utility costs, the company expects the yearly utility savings to increase over time, as follows: E: (Click the icon to view the yearly utility savings.) The company uses the payback period and ARR to screen potential investments. Company policy requires a payback period of less than five years and an ARR of at least 10%. Any potential investments that do not meet these criteria will be removed from further consideration. Read the requirements. 1. Calculate the payback period of the solar panels. First enter the formula, then calculate the payback period. (Enter amounts in dollars, not millions. Round your answer to two decimal places.) Full years Amount to complete recovery in next year 1 Projected net cash inflow in next year ) = Payback + years 2. Calculate the ARR of the solar panels. First enter the formula, then compute the ARR of the solar panels. (Enter amounts in dollars, not millions. Enter your answer as a percent rounded to two decimal places.) Accounting Average annual operating income from asset 1 Initial investment rate of return % 3. Should Humboldt turn down the solar panel investment or consider it further? The payback period five years. The ARR V 10%. Therefore, Humboldt should the solar panel investment