answer questions 1,2 and 3

Boston College is considering adding solar panels to the roof of O'Neill Library. The panels cost $500,000 to install. The power produced would be sold back to a local electric company, which would pay BC $100,000 at the end of each year for the first three years and $80,000 at the end of years four and five. This agreement with the electric company would end after these 5 years, at which point the panels could be sold for $120,000 in scrap. The University's discount rate is 10%.

Note: in all your answers below:

do not include a $

use a minus sign for negative (not parentheses)

round your answers to the nearest cent

Here are some examples of correctly formatted answers:

50,000.00 (or 50000.00)

-100.50

1.What is the internal rate of return for the project? Round your answer to one decimal place. percent

(Note that Excel may round even further so you may need to add one decimal place to your answer. For example 5% could really be 4.9% rounded.)

2. What is the net present value of the project? Round to the nearest cent. $

3. Should the University accept the project? Answer yes or no.

Open a spreadsheet and enter the appropriate formula to do the calculations.