Question

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 |

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

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 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 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). 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). 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
–$
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:
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
–$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
–$
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 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...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 21 minutes ago

asked 23 minutes ago

asked 23 minutes ago

asked 30 minutes ago

asked 39 minutes ago

asked 47 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago