Question: do in excel and show formulas Question 1 40 marks Calculate the net present value (NPV), the payback period (using graphical method), and the return
do in excel and show formulas
Question 1 40 marks Calculate the net present value (NPV), the payback period (using graphical method), and the return on investment using a discount rate of 8% for the following systems development project. The development costs for the system were $225,000 Year 1 2 3 4 5 6 7 8 Anticipated Annual Benefits Expected Annual Operating Costs $55,000 $5,000 $60,000 $5,000 $70,000 $5,500 $75,000 $5,500 $80,000 $7,000 $80,000 $7,000 $80,000 $7,000 $80,000 $8,000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
