a) 6yrs+(375000-350000)/50000
PBP= 6.5yrs
b) DPBP= company will not be able to recover the entire investment according to DPBP method because cash inflow stop after 10yrs
c) IRR
year | cashflow | disc 7% | PV of cash flow |
0 | -375000 | 1 | -375000 |
1 | 60000 | 0.934 | 56040 |
2 | 60000 | 0.873 | 52380 |
3 | 60000 | 0.816 | 48960 |
4 | 60000 | 0.763 | 45780 |
5 | 60000 | 0.713 | 42780 |
6 | 50000 | 0.666 | 33300 |
7 | 50000 | 0.622 | 31100 |
8 | 50000 | 0.582 | 29100 |
9 | 50000 | 0.544 | 27200 |
10 | 50000 | 0.508 | 25400 |
IRR is 7% when NPV is 0
d)
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
inflow | 60000 | 60000 | 60000 | 60000 | 60000 | 50000 | 50000 | 50000 | 50000 | 50000 | |
discount 18% | 0.847 | 0.718 | 0.609 | 0.516 | 0.437 | 0.37 | 0.314 | 0.266 | 0.225 | 0.191 | |
PV of inflow | 50820 | 43080 | 36540 | 30960 | 26220 | 18500 | 15700 | 13300 | 11250 | 9550 | 255920 |
Initial outflow | 375000 | ||||||||||
NPV | -119080 |
e) profitability index = PV of future cashflows/ initial investment
255920/375000= 0.6824
Capital Budgeting Analysis : A firm is planning a new project that is projected to yield cash flows of - $595,000 in Year 1, $586,000 per year in Years 2 through 5, and $578,000 in Years 6 through 11. This investment will cost the company $2,580,000 today (initial outlay). We assume that the firm's cost of capital is 11%. (1) Draw a timeline to show the cash flows of the project. (2) Compute the project’s payback period, net present value...
A firm is planning a new project that is projected to yield cash flows of -$515,000 in Year 1, $586,000 per year in Years 2 through 3, and $678,000 in Years 4 through 6, and $728,000 in Years 7 through 10. This investment will cost the company $2,780,000 today (initial outlay). We assume that the firm's cost of capital is 9.65%. (1) Draw a time line to show the cash flows of the project. (2) Compute payback period, net present...
1. Which of the following methods of project analysis are most commonly used by CFO's? internal rate of return and net present value discounted payback and net present value net present value and payback internal rate of return and payback 2. Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$ 341,000 –$ 51,000 1 54,000 24,900 2 74,000 22,900 3 74,000 20,400 4 449,000 15,500 Whichever project you choose, if any,...
Capital Budgeting Analysis: The MCSL Corp. is planning a new investment project which is expected to yield cash inflows of $180,000 per year in Years 1 through 3, $225,000 per year in Years 4 through 7, and $185,000 in Years 8 through 10. This investment will cost the company $880,000 today (initial outlay). We assume that the firm's cost of capital is 7.8%. (1) Draw a time line to show the cash flows of the project. 2) Compute the project’s...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$ 350,000 –$ 50,000 1 45,000 24,000 2 65,000 22,000 3 65,000 19,500 4 440,000 14,600 Whichever project you choose, if any, you require a 15% return on your investment. a-1. What is the payback period for each project? (Round the final answers to 2 decimal places.) Payback Period Project A years Project B years a-2. If you apply the payback criterion, which investment will...
Consider the following two mutually exclusive projects: Cash Flow Year 0 Cash Flow (B) - $ 50,000 24,000 22,000 19,500 14, 600 - $ 350,000 45,000 65,000 65,000 440,000 AM + Whichever project you choose, if any, you require a 15% return on your investment. a-1. What is the payback period for each project? (Round the final answers to 2 decimal places.) Payback Period Project A Project B years years a-2. If you apply the payback criterion, which investment will...
udicates problems in Excel Study Problems All Study Problems are available in MyLab Finance. The X icon indicates problems Mylab format available in MyLab Finance. LO2 10-1. (Payback Period) What is the payback period for the following set of cash flowe YEAR CASH FLOWS --- $11,300 3,400 4,300 3,600 4,500 3,500 x 10-2. (IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $10,000 resulting in a single free cash flow of $17,182 after 8 years...
1. We can get multiple IRRS when we draw an NPV profile for a project when: a. The project is riskless. b. The project requires a large investment. c. The project cash flows are uneven and change in sign. d. The project has a balloon payment. e. The opportunity cost of capital is high. 2. The length of time required for an investment to generate cash flows sufficient to recover its initial cost, without taking into account time value of...
Water Planet is considering purchasing a water park in Atlanta, Georgia, for $1,870,000. The new facility will generate annual net cash inflows of $460,000 for eight years. Engineers estimate that the facility will remain useful for eight years and have no residual value. The company uses straight-line depreciation, and its stockholders demand an annual return of 10% on investments of this nature. Requirements: Compute the payback period, the ROR, the NPV, the IRR, and the profitability index of this investment. Recommend...
you are considering a project with an initial cash outlay of $100,000 and expected free cash flow of $50,000 at the end of each year for 3 years. the required rate of return for this project is 10 percent. a. What is the project's conventional payback periods? b. What is the project's discounted payback period? c. what is the project's NPV? d. what is the project's PI? e. what is the project's IRR?