ALL / NONE / SOME

LESS THAN / MORE THAN

GREATER THAN / LESS THAN

NEGATIVE / POSITIVE

ABOVE / BELOW

GOOD / POOR

1,000,000 1,500,000 2,000,000 2,500,000 3,500,000 4,500,000 Year 1 Year 4 Year 6 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 EEB (Click the icon to view the yearly utility savings.) 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. The solar panels have already passed the payback period and ARR screening (Click the icon to view the present value annuity factor table.) (Click the icon to view the present value factor table.) (Click the icon to view the future value annuity factor table.)(Click the icon to view the future value factor table.) 1. Compute the NPV of the solar panels, given the company's 12% hurdle rate 2. Estimate the IRR of the solar panels. Use Excel to find the exact IRR. 3. Should Sonoma invest in the solar paneling? Why or why not? 1. Compute the NPV of the solar panels, given the company's 12% hurdle rate. (Round your answer to the nearest whole dollar. Use parentheses or a minus sign for negative net present values.) The NPV is $ 2. Estimate the IRR of the solar panels. Use Excel to find the exact IRR. (Round your answer to two decimal places.) The IRR is somewhere between The exact IRR using Excel is 3. Should Sonoma invest in the solar paneling? Why or why not? The solar panel proposal meets standpoint. of the company's capital investment decisions. It has a payback of five years and an ARR of 10%. It has a NPV which indicates that the IRR is the company's 12% hurdle rate. Therefore, the solar panels appear to be a investment from a financial Choose from any list or enter any number in the input fields and then continue to the next