Question

compute the internal rate of return for the cash flows of the following two projects (Do...

compute the internal rate of return for the cash flows of the following two projects (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.):

year project A PROJECT B
0 -6800 -4400
1 2600 1500
2 3400 2900
3 2200 1800

Homework Answers

Answer #1

IRR is calculated using IRR function in excel.

year project A PROJECT B
0 -6800 -4400
1 2600 1500
2 3400 2900
3 2200 1800
IRR 10.23% 18.68%

At this Rate NPV is $0.

year project A Discount rate Present value PROJECT B Discount rate Present value
0 -6800 1 -6800 -4400 1 (4,400.00)
1 2600 0.90723097 2358.80052 1500 0.84264    1,263.95
2 3400 0.82306803 2798.43131 2900 0.71004    2,059.10
3 2200 0.74671281 1642.76818 1800 0.5983    1,076.94
NPV 0.00              -  
Know the answer?
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
Similar Questions
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC)....
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual return of 16 percent. Year Deepwater New Sub Ride 0 −$ 995,000 −$ 1,940,000 1 415,000 990,000 2 546,000 845,000 3 465,000 840,000 a-1. Compute the IRR for both projects. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) IRR Deepwater Fishing _____ % Submarine Ride _______ % Calculate the...
Consider the following cash flows of two mutually exclusive projects for Tokyo Rubber Company. Assume the...
Consider the following cash flows of two mutually exclusive projects for Tokyo Rubber Company. Assume the discount rate for both projects is 11 percent. Year Dry Prepreg Solvent Prepreg 0 –$ 1,740,000 –$ 770,000 1 1,104,000 395,000 2 908,000 640,000 3 754,000 398,000    a. What is the payback period for both projects? (Do not round intermediate calculations. Round your answers to 2 decimal places, e.g., 32.16.)     b. What is the NPV for both projects? (Do not round intermediate...
   Consider the following cash flows of two mutually exclusive projects for Tokyo Rubber Company. Assume...
   Consider the following cash flows of two mutually exclusive projects for Tokyo Rubber Company. Assume the discount rate for both projects is 12 percent. Year Dry Prepreg Solvent Prepreg 0 –$ 1,800,000 –$ 800,000 1 1,110,000 425,000 2 920,000 700,000 3 760,000 410,000    a. What is the payback period for both projects? (Do not round intermediate calculations. Round your answers to 2 decimal places, e.g., 32.16.)     b. What is the NPV for both projects? (Do not round...
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC)....
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual return of 18 percent. Year Deepwater Fishing New Submarine Ride 0 ?$ 1,040,000 ?$ 2,030,000 1 460,000 1,080,000 2 582,000 890,000 3 510,000 930,000 a-1. Compute the IRR for both projects. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places (e.g., 32.16).) IRR Deepwater Fishing % Submarine Ride % a-2. Based on...
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC)....
Consider the following cash flows on two mutually exclusive projects for the Bahamas Recreation Corporation (BRC). Both projects require an annual return of 18 percent. Year Deepwater Fishing New Submarine Ride 0 ?$ 1,035,000 ?$ 2,020,000 1 455,000 1,070,000 2 578,000 885,000 3 505,000 920,000 a-1. Compute the IRR for both projects. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places (e.g., 32.16).) IRR Deepwater Fishing % Submarine Ride % a-2. Based on...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$ 424,000 –$ 39,500 1 44,500 20,300 2 61,500 13,400 3 78,500 18,100 4 539,000 14,900    The required return on these investments is 11 percent. 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 Project A years Project B years b. What is the NPV for each...
Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows:   ...
Howell Petroleum, Inc., is trying to evaluate a generation project with the following cash flows:    Year Cash Flow 0 –$ 43,000,000 1 67,500,000 2 – 18,000,000    a. If the company requires a return of 11 percent on its investments, what is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)    NPV            $    b. Compute the IRRs for this project. (Do not round intermediate calculations and...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$40,000...
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 –$40,000       –$180,000       1 25,000       15,000       2 22,000       45,000       3 20,000       50,000       4 15,000       275,000       The required return on these investments is 11 percent. Required: (a) What is the payback period for each project? (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).) Payback period   Project A years     Project B years  ...
Consider the following two mutually exclusive projects:     Year Cash Flow (X) Cash Flow (Y) 0...
Consider the following two mutually exclusive projects:     Year Cash Flow (X) Cash Flow (Y) 0 –$ 20,900 –$ 20,900 1 9,075 10,550 2 9,550 8,025 3 9,025 8,925      Calculate the IRR for each project. (Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.)     IRR   Project X %     Project Y %     What is the crossover rate for these two projects? (Do not round intermediate calculations. Enter your answer...
Consider the following cash flows of two mutually exclusive projects for A–Z Motorcars. Assume the discount...
Consider the following cash flows of two mutually exclusive projects for A–Z Motorcars. Assume the discount rate for both projects is 12 percent. Year AZM Mini-SUV AZF Full-SUV 0 –$ 525,000 –$ 875,000 1 335,000 365,000 2 210,000 450,000 3 165,000 305,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. What is the NPV for...