Question

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: E: (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.) 3 (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? 10% The solar panel proposal meets of the company's capital investment decisions. It has a payback of V five years and an ARR of VNPV which indicates that the IRR is the company's 12% hurdle rate. Therefore, the solar panels appear to be a financial standpoint. It has a investment from a Enter your answer in each of the answer boxes.