This is for microsoft exccel

boston college is considering solar panels for the roof of o’neill library. the panels will cost
$550,000 to install this year (year 0). the power generated would be sold back to the local
electric company, which would pay the university $100,000 at the end of each year for the first
3 years, and then $80,000 at the end of year 4 and year 5. this agreement with the electric
company would conclude at the end of year 5, at which time the panels could be sold for
$200,000 in scrap. the university’s discount rate is 10%.
enter this information into a worksheet and use financial formulas to answer the following:
(a) what is the internal rate of return for the project?
(b) what is the net present value of the project? round to the nearest cent.
(c) should boston college accept this project? 1*
somewhere in the worksheet, type a “yes
or no” response. include a brief statement justifying this decision via interpretation of
your results for both (a) internal rate of return and (b) net present value.