IRR can be calculated by using the Excel's IRR function: =IRR(All the cash flows including investment)
When the cashflows are of the same amount as in our case, Payback Period can be calculated by: Investment/Cash Flow for any one period
Year | Project A | Project B |
0 | -89000 | -89000 |
1 | 29000 | 42000 |
2 | 29000 | 42000 |
3 | 29000 | 42000 |
4 | 29000 | |
IRR | 11.51% | 19.62% |
=IRR(All the cash flows including investment) | =IRR(All the cash flows including investment) | |
Payback Period(Years) | 3.07 | 2.12 |
=89000/29000 | =89000/42000 |
Note: Give it a thumbs up if it helps! Thanks in advance!
Problem #2 Each of two mutually exclusive projects involves an investment of S 89,000. The cash...
Each of two mutually exclusive projects involves an investment of $ 108,000. The cash flows for the projects are as follows: Year Project “A” Project "B" 1 $30,000 $36,000 2 30,000 36,000 3 30,000 36,000 4 30,000 36,000 A. Calculate each project's payback period. B. Compute the IRR of each project.
Each of two mutually exclusive projects involves an investment of $124,000. Net cash flows for the projects are as follows: Year Project A Project B 1 60,000 57,000 2 62,000 64,000 3 40,000 47,000 A. Calculate each project's payback period. (2 Points) B. Compute the Net Present Value (NPV) of each project when the firm's cost of capital is 10 percent. (2 Points) C. Internal Rate of Return (IRR) -Your choice; based on your answer to part (B). (2 Points) D. Modified Internal Rate...
4. You Corp, is analyzing two mutually exclusive projects. The free cash flows associated with these projects are as follows. Year Cash Flows Cash Flows -50,000 -50,000 15,625 15,625 15,625 15,625 15,625 100,000 The required rate of return on these projects is 10% A) What s each project's payback period? B) What is each project's NPV? C) What is each project's IRR? D) Which project should be accepted? Why?
10% DISCOUNT RATE 4. You Corp, is analyzing two mutually exclusive projects. The free cash flows associated with these projects are as follows. Year Cash Flows ܘ -50,000 ܝ ܟܬ Cash Flows -50,000 15,625 15,625 15,625 15,625 15,625 ܚ ܠܛ ܗ 100,000 A) What s each project's payback period? B) What is each project's NPV? C) What is each project's IRR? D) Which project should be accepted? Why? We were unable to transcribe this image
Problem 7-20 Comparing Investment Criteria Consider the following cash flows of two mutually exclusive projects for Spartan Rubber Company. Assume the discount rate for both projects is 9 percent. Year Dry Prepreg Solvent Prepreg 0 –$ 1,850,000 –$ 825,000 1 1,115,000 450,000 2 930,000 750,000 3 765,000 420,000 a. What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Payback period Dry Prepreg years Solvent Prepreg years...
Problem 7-18 Comparing Investment Criteria Consider the following cash flows of two mutually exclusive projects for A–Z Motorcars. Assume the discount rate for both projects is 11 percent. Year AZM Mini-SUV AZF Full-SUV 0 –$ 545,000 –$ 895,000 1 339,000 369,000 2 218,000 458,000 3 169,000 309,000 a. What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Payback period AZM Mini-SUV years AZF Full-SUV years b....
Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of $100000. The company's board of directors has set a 4-year payback requirement and has set its cost of capital at 12%. The cash inflows associated with the two projects are shown in the following table: YR Project A Project B 1 30000 85000 2 30000 50000 3 30000 10000 4 30000 10000 5 30000 10000 6 30000 10000 .a. Calculate the payback period for...
Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of $110,000. The company's board of directors has set a 4-year payback requirement and has set its cost of capital at 12%. The cash inflows associated with the two projects are shown in the following table: Cash inflows (CFt) Year Project A Project B 1 $35,000 $65,000 2 $35,000 $50,000 3 $35,000 $20,000 4 $35,000 $20,000 5 $35,000 $20,000 6 $35,000 $20,000 a. Calculate the...
18. Comparing Investment Criteria Consider the following cash flows of two mutually exclusive projects for Tokyo Rubber Company. Assume the discount rate for both projects is 8 percent. Year Dry Prepreg Solvent Prepreg -$1,700,000 1,100,000 900,000 --$750,000 375,000 600,000 390,000 750,000 a. Based on the payback period, which project should be taken? b. Based on the NPV, which project should be taken? c. Based on the IRR, which project should be taken? d. Based on this analysis, is incremental IRR...
All techniques with NPV profile - Mutually exclusive projects Projects A and B, of equal risk, are alternatives for expanding Rosa Company's capacity. The firm's cost of capital is 16%. The cash flows for each project are shown in the following table: PF a. Calculate each project's payback period. b. Calculate the net present value (NPV) for each project. c. Calculate the internal rate of return (IRR) for each project. d. Indicate which project you would recommend. a. The payback...