1 Capital Budgeting Calolator Prepared by 0085 4 Cost of capital 0.095 0.085 0.075 6 Year 7 9 10 11 17 12 0 1 2 3 14 5 le Estimated Cash Flows Project 1 Project 2 -100000 -320000 10000 40000 20000 45000 20000 60000 20000 66000 20000 68000 20000 68000 20000 60000 20000 59000 20000 57000 22000 75000 Project -450000 100000 100000 100000 100000 40000 60000 30000 30000 30000 20000 Project 4 200000 42000 44000 38000 40000 34000 34000 34000 34000 20000 25000 Discounted Cash Flows Project 1 Project 2 -100000 -320000 9216.589862 36520 68037 16989.10574 37630.49353 15658.16197 4569923108 14431 48500 45907 90337 130090847 4379548124 12258.90181 39447.92807 11298 52702 31787 21037 104 13.38895 28545 59227 9597593506 25186 33797 9730 279131 30263.55401 Sum of discounted cash flows 22894 94214 4409242227 Project 3 450000 92165,89862 84945.52868 78290 80954 7215742843 28001863 35778.70544 16947.79052 15620 08343 14396.39020 8845.708301 Project 4 -200000 39069.76744 38074 63494 30588.50164 2995202119 23602793 22030.69183 20493.66663 19053.87594 10431.66946 12120 84821 14 IS 16 13 7 18 19 10 -3251 839551 4551767057 These should be equal to each other. 13 20 21 Net present value (NPV) $22.894.94 S44 09242 183.251.54 545,517,67 32 Internal rate of return (IRR) 13% 12% 8% 13% 21 Modified internal rate of return (MIRR) 11% 11 8% 10% 24 Payback period 55 5.602941176 5.166666667 5.058823529 25 Discounted paytack period 7.68 8.45 Never 5.81 25 27 Use an IF statement to write and about which projects should be chosen under the following two mumption 21. Projects are independent. Accept or reject based on 29 Nu Accept Accept Reject Accept IRR e Accept Accept Reject Accept 11 MIRRrue Accent Accept Reject Accept 13 2. Projects are my exclusive 23 The NV 14 Project with the NPV is chosen 15 6. Next, use an IFstatement to detemine which project to take if they are mutually exclusive. This means you take the project with the highest NPV. One way to do this is by using an -MAX function to find the project with the highest NPV and then using an IF statement to find the NPV that equals the maximum value. 1 Capital Budgeting Calolator Prepared by 0085 4 Cost of capital 0.095 0.085 0.075 6 Year 7 9 10 11 17 12 0 1 2 3 14 5 le Estimated Cash Flows Project 1 Project 2 -100000 -320000 10000 40000 20000 45000 20000 60000 20000 66000 20000 68000 20000 68000 20000 60000 20000 59000 20000 57000 22000 75000 Project -450000 100000 100000 100000 100000 40000 60000 30000 30000 30000 20000 Project 4 200000 42000 44000 38000 40000 34000 34000 34000 34000 20000 25000 Discounted Cash Flows Project 1 Project 2 -100000 -320000 9216.589862 36520 68037 16989.10574 37630.49353 15658.16197 4569923108 14431 48500 45907 90337 130090847 4379548124 12258.90181 39447.92807 11298 52702 31787 21037 104 13.38895 28545 59227 9597593506 25186 33797 9730 279131 30263.55401 Sum of discounted cash flows 22894 94214 4409242227 Project 3 450000 92165,89862 84945.52868 78290 80954 7215742843 28001863 35778.70544 16947.79052 15620 08343 14396.39020 8845.708301 Project 4 -200000 39069.76744 38074 63494 30588.50164 2995202119 23602793 22030.69183 20493.66663 19053.87594 10431.66946 12120 84821 14 IS 16 13 7 18 19 10 -3251 839551 4551767057 These should be equal to each other. 13 20 21 Net present value (NPV) $22.894.94 S44 09242 183.251.54 545,517,67 32 Internal rate of return (IRR) 13% 12% 8% 13% 21 Modified internal rate of return (MIRR) 11% 11 8% 10% 24 Payback period 55 5.602941176 5.166666667 5.058823529 25 Discounted paytack period 7.68 8.45 Never 5.81 25 27 Use an IF statement to write and about which projects should be chosen under the following two mumption 21. Projects are independent. Accept or reject based on 29 Nu Accept Accept Reject Accept IRR e Accept Accept Reject Accept 11 MIRRrue Accent Accept Reject Accept 13 2. Projects are my exclusive 23 The NV 14 Project with the NPV is chosen 15 6. Next, use an IFstatement to detemine which project to take if they are mutually exclusive. This means you take the project with the highest NPV. One way to do this is by using an -MAX function to find the project with the highest NPV and then using an IF statement to find the NPV that equals the maximum value