Question

Consider two investments A and B with the sequences of cash flows given in the table below. Click the icon to view the cash f

0 0
Add a comment Improve this question Transcribed image text
Answer #1
N Project A Project B
0 -115000 -95000
1 30000 20000
2 30000 20000
3 120000 130000
IRR = 20.1% 25.2%

Using excel, the formula table is:-

N Project A Project B
0 -115000 -95000
1 30000 20000
2 30000 20000
3 120000 130000
=IRR(B26:B29) =IRR(C26:C29)
Add a comment
Know the answer?
Add Answer to:
Consider two investments A and B with the sequences of cash flows given in the table...
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
  • what is the rate of return of A and B ? Consider two investments A and...

    what is the rate of return of A and B ? Consider two investments A and B with the sequences of cash flows given in the table belo Click the icon to view the cash flows for the projects. (a) Compute the BR for each investment. X i More Info The rate of Net Cash Flow Project A -$115,000 40,000 40,000 150,000 Project B -$100,000 1 30,000 30,000 160,000 2 3 Print Done

  • Consider two investments A and B with the following sequences of cash flows: Net Cash Flow...

    Consider two investments A and B with the following sequences of cash flows: Net Cash Flow Project A Project B -$111000 -$102000 22000 13000 22000 13000 111000 108000 (a) Compute the IRR for each investment. Project A: IRR = Project B: IRR = (keep 2 decimal places in numerical results) (b) At MARR = 59%, determine the acceptability of each project. Project A: Project B: (c) If A and B are mutually exclusive projects, which project is better, based on...

  • Solve Part C: WN -os Net Cash Flow Project A - $115,000 40,000 40,000 150,000 Project...

    Solve Part C: WN -os Net Cash Flow Project A - $115,000 40,000 40,000 150,000 Project B - $100,000 30,000 30,000 160,000 Consider two investments A and B with the sequences of cash flows given in the table below. Click the icon to view the cash flows for the projects. (a) Compute the IRR for each investment. The rate of return for Project A is 33.73 %. (Round to one decimal place.) The rate of return for Project B is...

  • Consider the two mutually exclusive investment projects given in the table below for which MARR =...

    Consider the two mutually exclusive investment projects given in the table below for which MARR = 19%. On the basis of the IRR criterion, which project would be selected under an infinite planning horizon with project repeatability likely? Click the icon to view the cash flows for the investment projects. The rate of return on the incremental investment is %. (Round to one decimal place.) Which project would be selected on the basis of the IRR criterion? Choose the correct...

  • Consider the two mutually exclusive investment projects given in the table below for which MARR =...

    Consider the two mutually exclusive investment projects given in the table below for which MARR = 16%. On the basis of the IRR criterion, which project would be selected under an infinite planning horizon with project repeatability likely? Click the icon to view the cash flows for the investment projects. The rate of return on the incremental investment is % (Round to one decimal place.) n 0 Net Cash Flow Project A -- $4,000 1,500 2,500 2,500 26.23% Project B...

  • 14. Consider four projects with the following sequences of cash flows: n 0 NET CASH FLOWS...

    14. Consider four projects with the following sequences of cash flows: n 0 NET CASH FLOWS A B C -$25,000|-$23,000-$56,500 $12,000 $32,000 -$2,500 $23,000 $32,000-$6,459 $34,000 $25,000 $88,345 3 (a) Identify all the simple investments. (b) Identify all the non-simple investments. (c) Compute the Internal Rate of Return (IRR) for each project using NPV method and Excel. Note the following: A simple (or conventional) investment is simply when one sign change occurs in the net cash flow series. If the...

  • Consider the two mutually exclusive investment projects given in the table below for which MARR=11​%. On...

    Consider the two mutually exclusive investment projects given in the table below for which MARR=11​%. On the basis of the IRR​ criterion, which project would be selected under an infinite planning horizon with project repeatability​ likely? The rate of return on the incremental investment is ?% Homework: HW #7 Save Score: 0 of 1 pt 10 of 10 (8 complete) HW Score: 78.33%, 7.83 of 10 pts Problem 7-56 (algorithmic) Question Help Consider the two mutually exclusive investment projects given...

  • Consider the two mutually exclusive investment projects given in the table below. Click the icon to...

    Consider the two mutually exclusive investment projects given in the table below. Click the icon to view the cash flows for the projects. (a) To use the IRR criterion, what assumption must be made in comparing a set of mutually exclusive investments with unequal service lives? Select all that apply. A. Project A1 can be repeated at the same cost in the future. B. The required service period is 3 years. OC. Project A2 can be repeated at the same...

  • Consider the two mutually exclusive investment projects given in the table below. E Click the icon...

    Consider the two mutually exclusive investment projects given in the table below. E Click the icon to view the cash flows for the projects. (a) To use the IRR criterion, what assumption must be made in comparing a set of mutually exclusive investments with unequal service lives? Select all that apply. A. The required service period is infinity B. Project A1 can be repeated at the same cost in the future. C. Project A2 can be repeated at the same...

  • Need IRR for both projects ASAP MOHAMMED AL ALAMI & 11/2/19 11:26 AM IDE 300 FALL19-C671020)...

    Need IRR for both projects ASAP MOHAMMED AL ALAMI & 11/2/19 11:26 AM IDE 300 FALL19-C671020) HW Score: 72 55%, 12 33 of 17 pts ncemer Homework: Ch. 7 ROR + Ch.4 Score: 0 of 1pk 10017 (13 complete) Problem 7-37 (algorithmic) Consider two investments A and B with the sequences of cash flows given in the table below. Click the icon to view the cash flows for the projects (a) Compute the IRR for each investment More Info The...

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