Question

Problem #2 Each of two mutually exclusive projects involves an investment of S 89,000. The cash flows for the projects are as
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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!

Add a comment
Know the answer?
Add Answer to:
Problem #2 Each of two mutually exclusive projects involves an investment of S 89,000. The cash...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Each of two mutually exclusive projects involves an investment of $ 108,000.   The cash flows for...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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,...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT