How do you calculate the NPV and IRR in excel? I am not getting the right answer for these.

Excel Assigament (THIS IS AN INDVDUAL ASSIGNMENT SO PLEASE TURN IN YOUR OWNwORK USING YOUR OWN wORDING ETC 2 5 The Chief Marketing Officer forecasts growth of 50 units per year through 2022, So, the demand will be 1,025 units in 2018, 1,075 units in 2019, etc. and the S100,000 price will remain consistent for all five years of the investment life. However, ABC cannot produce more 7 than 1,000 units anmually based on current capacity. norderto meet demand ABC mustesther updatethe current plantorrepl cet If the plant is replaced, an initial working catal investment 0 of $5,000,000 is required and these funds will be released at the end of the investment life to be used elsewhere. following table summarizes the projected data for both options: Update S110,000,000 S 10,000,000 Replace $ 140,000,000 14 Initial investment in 2018 15 Terminal salvage value in 2022 16 Working capital investment required 17 Useful life 18 Total annual cash operating costs per unit S5,000,000 5 years 75,000 65,000 21 The investment will be made at the beginning of 2018 and all transactions after that are 22 assumed to occur on the last day of each year. ABCs required rate of retumis10% Required: Please refer to the two Excel video lectures posted on Blackboard for Ch. 13 when setting up your spreadsheet for guidance. You may set up your spreadsheet using this file (on a separate Excel worksheet) to address requirement #1,#2, and 20 27, #3 and then answer question 84 directly on the spreadsheet. There are multiple ways to set up your spreadsheet and part of the esercse 8 is each student setting up hivher own spreadsheet. . Using Excel functions and formulas, calculate the net present value (NPV) for both the update and replace alternatives. 2. Using Excel functions and formulas, calculate the intermal rate of return (IRR) for both the update and replace alternatives. 3. Calculate the project profitability index (PPI) for both the update and replace alternatives 4. Based on the results, which option should ABC choose? Specifically explain why