Question

Capital Budgeting Homework Assignment Show your calculations. A firm with a cost of capital of 10 percent is considering the following mutually exclusive projects: Year Project A ($450) Project B ($635) 300 300 75 250 60 (a) According to the payback criterion, which project should be accepted? According to the discounted payback criterion, which project should be accepted? According to the NPV criterion, which project should be accepted? (d) According to the IRR criterion, which project should be accepted? (C) According to the MIRR criterion, which project should be accepted? According to the PI criterion, which project should be accepted? Given all the information above, if there is no capital rationing, which project should be chosen and why? (h) Given all the information above, if there is severe capital rationing, which project should be chosen and why?

Answer 1

fix IRR(B69:B74) B76 B C D Н PVIF@10% Simple cumulative cash flows Project A Cash flows Present value Cumulative discounted cash flows 66 Project A Аxс Project B Project B Project B 67 Year Project A Project B Project A 68 A В C Вхс (450) $ (390)$ (330) $ (260)$ (10) $ 240 $ (635.00) $ 272.73 $ 247.93 $ (635) $ (335) $ (35) $ 40 $ 115 $ 175 $ (450.00) $ (395.45)$ (345.87) $ (293.28) $ (122.52) $ 32.71 $ (450) $ 60 $ 1.000 $ (450.00) $ (635) (635.00) (362.27) (114.34) (57.99) (6.76) 69 0.909 $ 1 $ 70 300 54.55 60 $ 0.826 $ 0.751 $ 49.59 $ 2$ 71 300 3 $ $ 5 $ 70 $ 72 52.59 $ 75 56.35 250 $ 250 $ 0.683 $ 0.621 $ 170.75 $ $ 73 75 51.23 37.26 $ 74 60 155.23 30.49 75 12.13% $ 32.71$ 12.63% NPV 76 IRR 30.49 77 Payback period 11.55% 11.04% 4.04 2.47 78 MIRR MIRR(C69:C74,10%,10%) Years =4+ 10/250 MIRR ( B69: B74,10%,10%) 79 Years -2+35/75 80 81 PI 1.07 1.05 82 -1 +32.71/450 -1+30.49/635 83 84 Discounted Payback period 4.79 4.18 85 Years Years 86 -4+6.76/37.26 =4+122.52/155.23 87 Project B Project B Project A Project B Project A Project A Both 88 a) 89 b) 90 c) 91 d) 92 e) 93 f 94 g) Project A 95 h

Please rate thumbs up