Computers and Technology

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.

answer
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 10:00, danthehero56
Which of the following is true of operations within a spreadsheet program’s built-in functions? a. operations within parentheses, then multiplication and division, and then addition and subtraction are computed. b. operations within parentheses, then addition and subtraction, and then multiplication and division are computed. c. multiplication and division, then addition and subtraction, and then operations within parentheses are computed. d. addition and subtraction, then multiplication and division, and then operations within parentheses are computed
Answers: 2
image
Computers and Technology, 23.06.2019 11:30, kyraj21
Which excel file extension stores automated steps for repetitive tasks?
Answers: 1
image
Computers and Technology, 23.06.2019 17:30, Annlee23
When making changes to optimize part of a processor, it is often the case that speeding up one type of instruction comes at the cost of slowing down something else. for example, if we put in a complicated fast floating-point unit, that takes space, and something might have to be moved farther away from the middle to accommodate it, adding an extra cycle in delay to reach that unit. the basic amdahl's law equation does not take into account this trade-off. a. if the new fast floating-point unit speeds up floating-point operations by, on average, 2ă—, and floating-point operations take 20% of the original program's execution time, what is the overall speedup (ignoring the penalty to any other instructions)? b. now assume that speeding up the floating-point unit slowed down data cache accesses, resulting in a 1.5ă— slowdown (or 2/3 speedup). data cache accesses consume 10% of the execution time. what is the overall speedup now? c. after implementing the new floating-point operations, what percentage of execution time is spent on floating-point operations? what percentage is spent on data cache accesses?
Answers: 2
image
Computers and Technology, 23.06.2019 20:00, shaheedbrown06
What software programs are used to to create professional publication? a.) graphics programs b.) word processors c.) page layout programs d.) spreadsheet programs
Answers: 2
Do you know the correct answer?
This is for microsoft exccel

boston college is considering solar panels for the roof of...

Questions in other subjects: