the assigment is done I just need corrections please
All techniques, conflicting rankings Nicholson Roofing Materials, Inc., is consid- ering two mutually exclusive projects, each with an initial investment of $150,000. The company's board of directors has set a maximum 4-year payback requirement and has set its cost of capital at 9%. The cash inflows associated with the two projects are shown in the following table. Year 1 2 3 4 Cash inflows (CF) Project A Project B $45,000 $75,000 45,000 60,000 45,000 30,000 45,000 30,000 45,000 30,000 45,000 30,000 5 6 a. Calculate the payback period for each project. b. Calculate the NPV of each project at 0%. c. Calculate the NPV of each project at 9%. d. Derive the IRR of each project: e. Rank the projects by each of the techniques used. Make and justify a recommen- dation. B D H 2 Al techniques, conflicting rankings Nicholson Roofing Materials, Inc. is considering two mutually exclusive projects, each with an initial investment of $150.000, 4 Initial Investment $ 150,000.00 5 Year Project A Investment Balance 7 Project B Investment Balance 1 $45,000.00 8 (105,000) $75,000.00 [75,000 2 45,000 (60,000) 60,000 3 (15,000 45,000 (15,000) 10 30,000 15,000 4 45,000 11 30,000 30,000 5 45,000 12 30,000 6 45,000 30,000 13 14 Payback Period yrs. 15000/45000 2yrs. 15 15000/30000 3.3 yrs 2.50 yrs 16 17 Both projects have payback period less than 4 years, as per management requirement, so both will be accepted. Since project has less pay back period so it is preferrable 18 19 NPV 20 Rate 21 ox120,000.00 105.000.00 22 23 At discount rate of OX NPV of project Ais more than of project 8, so project Awill be accepted 24 25 26 E5L,866.34 251,112,36 27 28 29 At discount rate of 9 % both projects have a minimal difference of NPV values 30 31 32 RR 33 Internal rate of return is calculated to estimate the profitability of potential investment. It is will be calculated on hit and trial method where NPV becomes were 35 Rate 19.91 0.01 22.7150 E01 36 37 38 Merge Center A D 19 NPV 20 Rate 29 OX 120,000.00 22 E105,000.00 23 At discount rate of OX NPV of project Ais more than of project 8, so project Awill be accepted 24 25 26 9x E51 866.34 ES111236 27 28 29 At discount rate of 9 % both projects have a minimal difference of NPV values 30 31 32 IRR 33 Internal rate of return is calculated to estimate the profitability of potential investment. It is will be calculated on hit and trial method where NPV becomes were 34 35 Rate 0.01 22.71N 0.01 36 19.91% 37 38 39 The calculation of payback period shows that both projectsfulfills the requirement of management Led years As project has less number of years so it hould be accepted 40 41 The NPV calculation at rate zero shows project Ato be preffered, as the NPV value is high than project, but at rate we will not be taking time value of morwy into consideration. At 42 discount rate of 9% both projects has a minimal difference in their NPV values. The third enteria is of that calculates the profitability of intent. Project shows the proti 43 of 22.71% which is higher than project A So with less payback period and more project should be preferred 44 45 46 47 48 49 50 51