Present Value = Future value/ ((1+r)^t) | |||||
where r is the interest rate that is 15% and t is the time period in years. | |||||
Profitability index (PI) = (Sum of present values/Initial investment) | |||||
Net present value (NPV) = initial investment + sum of present values | |||||
Use excel to find the Internal rate of return (IRR) | |||||
Project A | |||||
t | 0 | 1 | 2 | 3 | 4 |
Cash flow | -318844 | 27700 | 56000 | 55000 | 399000 |
Present value | 24086.96 | 42344.05 | 36163.39 | 228129.5 | |
Sum of present values | 330723.9 | ||||
PI | 1.037259 | ||||
Net present value | 11879.94 | ||||
Internal rate of return | 16.24% | ||||
Project B | |||||
t | 0 | 1 | 2 | 3 | 4 |
Cash flow | -27476 | 9057 | 10536 | 11849 | 13814 |
Present value | 7875.652 | 7966.73 | 7790.91 | 7898.199 | |
Sum of present values | 31531.49 | ||||
PI | 1.147601 | ||||
Net present value | 4055.491 | ||||
Internal rate of return | 21.61% | ||||
Based on the calculations, the following statement is true. | |||||
3) Only NPV rule implies accepting Project A. |
10 points QUESTION 10 Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash...
PLEASE ANSWER A-D WITH WORK, THANK YOU! 2. Consider the following two mutually exclusive projects: Year Cash Flow A Cash Flow B 0 $-318,844 $-27,476 1 $27,700 $9,057 2 $56,000 $10,536 3 $55,000 $11,849 4 $399,000 $13,814 The required return is 15 percent for both projects. Based on NPV rule, Reject or Accept? Based on IRR rule, Reject or Accept? Based on PI, Accept or Reject? Which rule in this case would be preferred?
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$230,324 –$16,246 1 27,000 5,466 2 59,000 8,622 3 56,000 13,991 4 426,000 9,861 Whichever project you choose, if any, you require a 6 percent return on your investment. d. What is the discounted payback period for Project B? e. What is the NPV for Project A? g. What is the IRR...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$194,527 –$15,905 1 27,700 5,627 2 52,000 8,470 3 52,000 13,908 4 413,000 8,564 Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A? b. What is the payback period for Project B? c. What is the discounted payback period for Project A? d. What is the discounted payback period for...
Consider the following two mutually exclusive projects: Year. Cash Flow (A) Cash Flow (B). 02 -$264,129 -$16,027 12 26,500 5,769 2- 53,000 8,571 56,000 13,198 4 423,000 9,431 Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A?- b. What is the payback period for Project B? c. What is the discounted payback period for Project A? d. What is the discounted payback period for Project...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$244,500 –$14,607 1 29,800 4,237 2 59,000 8,285 3 55,000 13,203 4 410,000 8,788 Whichever project you choose, if any, you require a 6 percent return on your investment. What is the IRR for Project A? What is the IRR for Project B? What is the profitability index for Project A? What is the profitability index for Project B?
Bernie’s Restaurants is considering two mutually exclusive projects having the cash flow streams shown in the table below. Compute the net present value (NPV) for both projects using a 15% required rate of return. Compute the internal rate of return (IRR) for both projects. Compute the profitability index for both projects. Which project should Bernie’s business accept and why? Bernie’s Restaurants Capital Budgeting Projects Year Project A Net Cash Flow Project B Net Cash Flow 0 -$ 90,000 -$100,000 1...
Bernie’s Restaurants is considering two mutually exclusive projects having the cash flow streams shown in the table below. Compute the net present value (NPV) for both projects using a 15% required rate of return. Compute the internal rate of return (IRR) for both projects. Compute the profitability index for both projects. Which project should Bernie’s business accept and why? Bernie’s Restaurants Capital Budgeting Projects Year Project A Net Cash Flow Project B Net Cash Flow 0 -$ 90,000 -$100,000 1...
(3 marks) QUESTION 6 (6 marks) Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) $20,000 10, 000 10, 000 10, 000 10, 000 - $315, 000 25, 000 250, 000 55, 000 400, 000 The required return is 15% for both projects. Required: a) Which project should be accepted based on the net present value (NPV) and profitability index (PI) capital budgeting techniques? (4 marks) b) Explain why mutually exclusive projects might give rise...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$218,006 –$15,742 1 28,000 5,304 2 57,000 8,103 3 56,000 13,294 4 392,000 9,377 Whichever project you choose, if any, you require a 6 percent return on your investment. (e) What is the NPV for Project A? (Click to select) $205,825.37 $216,658.29 $227,491.2 $210,158.54 $223,158.04 (f) What is the NPV for Project B ? (Click to select) $14,309.64 $15,062.78 $14,610.89 $15,514.66 $15,815.91 ...
Consider the following two mutually exclusive projects: Year FNM Cash Flow (A) -$256,924 27,200 58,000 58,000 428,000 Cash Flow (B) -$15,486 5,007 8.930 13,709 8,052 Whichever project you choose, if any, you require a 6 percent return on your investment. e. What is the NPV for Project A? f. What is the NPV for Project B ? g. What is the IRR for Project A? h. What is the IRR for Project B? i. What is the profitability index for...