Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Hi can you answer questions in excel and show work?

/in /by

Hi can you answer questions in excel and show work?
ATTACHMENT PREVIEW Download attachment
PMAN635Advanced Project MethodsSession 2 – Individual AssignmentIndividual Assignment IA-2- Rev 2Please do question 1 and 2.Submit your Excel workbook using the Individual Assignment linkIA2 in your Assignments Folder1.(75%) A five-year software development project is forecast to have net cash inflows of$15,000, $20, 000, $25,000, $30,000, and $50,000 over the next five years. It will cost$80,000 to implement the project, payable at the beginning of the project. Onceimplemented, there will be an annual cost of $5,000, payable at the end of each year.There is an assumed inflation rate of .02 each of the five years for this project. If therequired rate of return is .05, construct a discounted cash flow model to determine the NetPresent Value (NPV).Use the concepts found in Mantel, Chapter 1, Section 1.5 andExcel to create the formulas needed to calculate the NPV.Assume the inflows all occurat the end of the year.2.(25%) Assuming your initial outflow is based on a fixed price vendor bid, your inflowsbased on a marketing study and your annual outflows based on your IT department’sestimate, which of these (initial outflow, annual outflow, and annual inflows) would youexpect to be most accurate?Which least accurate?Why?
Background image of page 1
Sign

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"