Sonoma 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: (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.) Data Table x Payback years 2. Calculate the ARR of the solar panels. Year 1 $ 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 2 $ Year 3 $ Accounting 1,000,000 1,500,000 2,000,000 2,500,000 3,500,000 4,500,000 Year 4 $ = rate of return Year 5 $ % Year 6............... 3. Should Sonoma turn down the solar panel investment or consider it further? The payback period V five years. The ARR 10%. Therefore, Sonoma should the solar panel investment Print Done