Madera is considering investing in solar paneling for the roof of its large distribution facility. The investment will cost $12 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: (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 8% 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.) Payback - X + years Data Table 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.) Year 1 $ 1,100,000 Year 2 $ Accounting rate of return 2,200,000 2.500.000 Year 3 $ % Year 4 $ 3. Should Madera turn down the solar panel investment or consider it further? $ Year 5 Year 6 2,800,000 4,300,000 5,400,000 $ The payback period five years. The ARR 8%. Therefore, Madera should the solar panel investment. Print Done