'lnmcm r = - m. M 5m. . 7/. -... m mm ' .5. Ex. {y xfw Z m. mm..." . 3 . 9', , t4; ,4: m": m" wmmmwv I..." 1mm 1.." m 5.1... ram ,5..." 53;?

Part AIn the spreadsheet under NPV calculation I an investment cell B8. It a negative because the cash flow will be an outflow. assume a capital value. Enter this cell B6. Enter this a anything .What I want you enter cash flows (make up numbers your choosing) cells B9 B18 ( ) so that the net (NPV) +$, +$, I up the spreadsheet calculate the cash flow the net the all the cash flows. Make sure you see how I did this.All cash flows must be greater $ (but the cash flows need be same amount ). Yes, this will be trial-- you the numbers you assume you it work.I want you calculate the profitability the cash flows that you used calculate the NPV. cell C22 enter a formula that will calculate the profitability index. You must one formula that will this cell. I will look the cell be sure you did just enter the correct , but you figured how Excel make the calculation. we can this information calculate the payback (undiscounted), the discounted payback period. the undiscounted cash flows ( B), the cumulative the undiscounted cash flows D.* Similarly, the discounted (meaning ) cash flows ( C) the cumulative the discounted cash flows E. the bold font the two that bracket the investment paid back. this D (undiscounted) E (discounted). cells C24 C25 write the payback " " " " (whatever the correct two ). you cannot figure D E reason, figure the answer bold font the appropriate two B C. Optional bonus: This likely a challenge I have tried this so I know how easy difficult this ! See you can write one formula that gives the exact payback (see the details what the exact payback ) the undiscounted discounted cash flows. The formula must have cell , numbers. Enter the formula cells E24 E25. One added point you this correct (so you can up / this assignment). Part B the spreadsheet the IRR calculation I cash flows The investment shown. You need find an investment enter it cell B27 so that the IRR greater , but percent. Remember that the cash flow will be a negative value. The IRR will be calculated automatically (see cell B35 formula) be because the cell formatted percent.  ‘lnmcm r = »- m. M 5m. . 7/. -... m mm ’ .5. Ex. {y éxfw Zm. mm...“ . 3 . 9‘, , t4; ,4: m”: m“ wmmmwv I...“ 1mm 1..“ m 5.1... ram ,5...“ 53;?03 vl A a c D 5 F G H I J K L M N 0 P Q R s1 unmemsz3 u4 ‘ Presem Value calculation5 l5 instofcapualldeclmal) 0.157 Cash Flows Present Value5 l u s (900,000.00) 5 (500,000)Curnulative Sum 133m 51! Cumulative sum 09m C189 1 $ 230,000.00 5 200,000.00 xxx xxx10; 2 s 253,000.00 5 203,402.55 xxx xxx11‘ 3 5 234,000.00 5 153,353.50 xxx xxx12‘ 4 $ 100,000.00 $ 57,175.32 xxx xxx131 s s 130,000.00 5 54,532.93 xxx xxx14 5 s 172,000.00 5 74,350.35 xxx xxx15. 7 s 300,000.00 5 300,749.53 xxx xxx16‘ s s 400,000.00 5 130,750.71 xxx xxx17 5 s 53,400.00 5 23,707.49 xxx xxx13 10 $ 94,504.00 $ 23,334.55 xxx xxx19 ‘20 1 Net Present value: 5 332,032.55 'een +5200,000 and +5400,00021 ‘22 Profihbllitylndex: xxx23 l24 pack period (undlseounml): xxx Exact Payback Perlad: xxx25 back period (discos-med): xxx Exact Payback Period: xxx25 l27 Hi28 Emal rate of remm calculation29 . Cash Flows30 0 xxx31 , 1 s 345,000.0032 , 2 s 423,000.0033 1 3 s 300,000.0034 3 4 s 500,000.0035 5 s 400,000.0035 5 s 550,000.0037 138 IRR: ' #NUMI Between 12% and 15%39 ‘40 +1.1341 142 14344 l x. 35.... +M, -m _ _.__ 4 130’s