One project has the following benefits and cash flows at the discount rate of 10% Benefits Costs OSR/Month for year 1 300SR/Month for year 1 350SR /Month for year 2250SR /Month for year 2 400SR /Month for year 3200SR/Month for year 3 450SR /Month for year 4 150SR /Month for year 4 500SR /Month for year 5 100SR/Month for year 5 A: Calculate yearly cash flows and NPV in Excels spreadsheet. B: What will be effects on NPV if there is a reduction of 50 SR monthly benefits in year 2 to 5 and 100 SR per month increase in cost from year 1 to 5. Table 8-5. Cumulative Single Tail Probabilities of the Normal probability Describution (Areas under the Normal Curve from 10 w . 5000 5040 6179 6106 1044 > 0 1 2 3 4 5 . 7 $ 9 10 11 12 13 14 15 1.6 1.7 18 19 20 21 22 23 24 25 26 27 28 2.9 3.0 Example the area to the left of Z-1.34h found by following the best column down to 1.3 adming to the 04 cohe Atheistic sad 9099 The area to the right of 2 - 134s1 - 9099 - 0901. These we the man ** (center) and Z - 134 9099 - 3 - 4099 00 01 02 03 04 05 06 07 5050 5130 5160 5199 5230 5279 5350 5396 5433 5478 3512 5557 5596 56.36 3675 5714 5753 5793 5832 5621 5010 5943 3987 0026 6064 .6105 6141 6217 6355 6293 6331 6368 5443 6100 6517 6554 6501 6625 5654 6700 6736 6772 6808 6544 6879 8015 6950 6965 2019 7054 7085 7123 7857 .7290 72 7257 7291 7357 7359 7422 2454 7400 7517 7549 7580 .7611 7642 7673 7704 7734 7754 7294 7833 7852 7881 7910 7939 7967 7995 3023 3051 3073 8106 3133 3150 3156 1212 8264 3315 1340 139 8413 3438 8661 345 3508 3531 3554 3577 8599 3621 5613 3665 3636 3700 8729 17 3770 1790 3510 38.50 34 3060 SES 1907 8925 1962 3980 1997 2015 S032 9049 9066 SOS 9099 9115 9131 9147 916 9177 9192 9207 0222 9236 9251 9365 9279 9292 9306 9319 9332 9145 9357 9370 9382 9304 9406 9418 429 9441 0452 9463 0474 0434 9495 9505 9515 955 9535 9545 9354 9564 9573 9562 9591 9599 9608 9610 3625 9633 9641 9649 9656 9664 9671 9678 9086 9603 9600 9700 9713 9719 9726 9732 9738 9744 9750 9756 9761 9767 9772 0778 073 9788 929) 9798 9803 9808 9012 0817 9821 9626 95.00 9834 9930 9542 9546 9350 98:54 9557 9861 9854 9871 9875 5878 964 9887 9690 9893 9896 9.90 9901 9904 9906 9900 9911 9013 9916 9918 9920 99.32 9925 9927 9929 9931 3932 9934 9936 9938 9940 9941 904 9945 9948 9949 9951 9952 9953 9955 9956 0957 9950 9960 9961 0962 0063 9964 9965 9066 0967 996 9070 9971 9972 9973 9934 9974 9975 9976 9077 9977 9978 992 9900 9981 9981 9982 9900 9963 9954 9984 59859903 9986 9985 9987 9987 9987 9988 9988 9989 9900 9090 9990 8936 1886 1966 5929