Question: Please use Excel and insert the answer in a table I will be able to copy. Thank you! Please perform economic feasibility / NPV analysis

Please use Excel and insert the answer in a table I will be able to copy. Thank you! Please perform economic feasibility /NPV analysis for an Information Systems project for next five years with the following projections for Costs and Benefits in the next 5 years (Follow example on Slide 34 Chapter5)
One time cost/Capital Investment: 500,000$
Discount Rate: 7%
\table[[Year,Recurring Costs(Projection),Benefits(Projection)],[0,0,0],[1,250,000,350,000],[2,250,000,400,000],[3,270,000,425,000],[4,300,000,450,000],[5,310,000,500,000]]
Please calculate the following:
Overall NPV, Overall ROI, Breakeven Point------------------- Slide 34, Chapter 5(Fig 5.6)
Project break-even occurs between years 2 and 3
Use first year of positive cash flow to calculate break-even fraction -(153033-91394153033)=.402
Actual break-even occurred at 2.4 years
Note: All dollar values have been rounded to the nearest dollar
 Please use Excel and insert the answer in a table I

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!