pls help

Madoe is considering irvesting in solar paneling for the roof of its large distrbution facility. The irvostment wil costs9 milich and have a six-year usoful ife and no cesidual vilue. Because of rising utility costs, the compary eqpects the yeafly utity savirge to increase over time, as folows: (Cick the icon 10 view the yosiry utitity savings.) Company policy requires a payback pened of less than five years and an ARR of at seast 14%. Any potential investments that do not meot theie criteria wil be remowd from further consideratian. The solat panels have already passed the payback period and ARR screering. (Clek the lcon to vew the present velue pnnulty tscter table.) (Cick the icon to view the prosent value tuclor tablo.) (Click the icon to vew the future value annuity factor table), (Cick the loon to vew the future value tactor tabie.) 1. Compute the NPV of the solar panets, given the comparys 14\% hurde rate. 2. Estinats the IPRT of the solar panels Use Excel to tind the exact IPR 3. Should Modoc invest in the solar paneling? Why or why not? 1. Compute the NPV of the solar panels, given the company's 14% hurdie fate, (Round your answetr to the nearest whole dolar. Use parventheses ix a minus sign for negative nat presiel Vilues.) The NPVIs 2. Estimate the IRR of the solar paneis. Use Excel to find the exact IRR. (Round your answer to two decimal places.) The IRR is somewhere between The dxact IRR using Excel is 3. Should Modoc invest in the solar paneling? Why or why not? The eolar paral proposal mests of the compacy's captal investment decisions. It has a paybick of tre yean md an AFR of 14\%: it hass which indicatos that the IRR is the companys 14% hurdlo rath. Theretore, the soler peneis appoar to be a invostment trom a fonschal standpoint: Data table Reference Reterence Reference Reference