Format Tools Table Window Help AutoSaver OE N . Direction Assignment 1 Project Integration Mangoemen... Insert Draw Design Layout References Mailings Review View Times New. 12 AA A A EE 3.1A 2-A E E L -E Styles Styles Share OC Assignment 1: Project Integration Management (*Chapter 4 in text is a required reading to complete the assignment. The following tasks are based on the chapter.) [Task 1] Calculate NPV, ROI, and Payback values (50 points). (Direction) Perform a financial analysis for a project using the format provided in Figure 4-5 in chapter 4. Assume that the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $200,000 in Year 1 and $30,000 each year in Years 2, 3, and 4. Estimated benefits are SO in Year 1 and $100,000 each year in Years 2, 3, and 4. Use a 10 percent discount rate, and round the discount factors to two decimal places. Create a spreadsheet or use the business case financials template on the companion website to calculate and clearly display the NPV, ROI, and year in which payback occurs. In addition, write a paragraph explaining whether you would recommend investing in this project, based on your financial analysis (*write the paragraph in the excel document that you downloaded). Download an Excel template file from Blackboard and use it for the assignment For the calculation of discount factor, start Year 1. On completion, submit your Excel document to Blackboard [Supporting video on how to calculate NPV) https://www.youtube.com/watch?annotation id=annotation 1418261323&feature=iv&sre videg 4ub-xhzl10&v=N7pZZuckFbM [Supporting video on how to calculate ROI & Payback] https://www.youtube.com/watch?v=g4ub-xhzl10 age 1 of 3 Contromedi 1142 words English (United States) Focus F E MacBook Air gos Home Share Com Insert Draw Page Layout Formulas Data Review View Aria 12 AA 2 weet General BISA FI223 Mere GST : Created by Heather Miles E . - P S 2 E28- 0 t Pete Fame A2 E come by Hon. Financial Analysis for Project Name Financial Analysis for Project Name 2 Created by: Heather Milles Date: S Discount rate Discount factor Direction Read the description in textbook and watch two videos provided in the direction document. Calculate yellow and green cells by placing formula in the cells. Once completing your calculation, interpret the numbers and write a paragraph on your assumption and analysis in the below green cells. Dents 15 Discounted benefits 17 Discounted benefits.co 16 Cumulative Discounted benefits costs 21 PAYBACK NRXARNA Sheet Set + MacBook Air