Question
Use MS Excel to develop cashflow table for the below projects . Project 1: Project 1 is an ERP Implementation project that will yield a
Use MS Excel to develop cashflow table for the below projects
. Project 1: Project 1 is an ERP Implementation project that will yield a possible annual 5% increase in sales on an annual basis and 5% reduction in labor costs also annually. Sales and labor figures are 500,000 JOD and 350,000 JOD respectively. The hardware setup cost of the project is estimated to be 25,000 JOD and Software Licenses are estimated to cost 150,000 JOD. Project 2: Is a Mobile App development project for on-line sales that will yield a 6% increase in sales on an annual basis and 5% reduction in labor costs also annually. Sales and labor figures are 500,000 JOD and 350,000 JOD respectively. The hardware setup cost of the project is estimated to be 38,000 JOD and Software development is estimated to cost 100,000. QUESTION 2: [5 POINTS] For the developed Cash Flow Table and considering a discount rate of 6%, calculate the values of NP, Payback Period, ROI, NPV and IRR. QUESTION 3: [2 POINTS] Select the appropriate project for management and justify your selection.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started