Year 0 1 2 3 A -5100 2700 2500 1600 B -5100 1100 2300 3700 Use...

Year	0	1	2	3
A	-5100	2700	2500	1600
B	-5100	1100	2300	3700

Use the incremental IRR to determine the range of discount rates for which each project is optimal to undertake. Note you should also include the range in which it does not make sense to take either project.

a. What is the incremental IRR?

b. What is the range of discount rates A is the optimal project to take?

c. What is the range of discount rates B is the optimal project to take?

d. What is the range of discount rates neither project is optimal to take?

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Please note: Incremental IRR also known as Cross over rate, is the at which both projects have equal NPV which means at this rate decision is indifference.

Comparatively, Project with large cash inflows in early years is optimal to select only if discount rate is more than incremental IRR and Project with large cash inflows in later years is optimal to select only if discount rate is less than incremental IRR.

jeff jeffy answered 1 year ago

1. Consider the Following 10-year project: Year Cash Flow 0 -30000 1 2500 2 5000 3...

1. Consider the Following 10-year project: Year Cash Flow 0 -30000 1 2500 2 5000 3 6750 4 7000 5 7250 6 6000 7 6250 8 8000 9 3750 10 2000 Complete the following questions on excel: What is the Payback Period for the project? What is the Discounted Payback Period for the project at 12% required rate of return? What is the NPV of the project if the required rate of return is 12% What is the PI of...

Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5...

Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B

Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5

Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B

Use data below to complete 5 3 0 0 0 5 1 2 0 1 1...

Use data below to complete 5 3 0 0 0 5 1 2 0 1 1 1 1 7 0 2 2 1 2 0 6 4 1 3 2 4 0 1 1 0 0 0 1 3 0 2 1 0 3 0 3 0 1 2 8 2 3 0 0 5 1 1 3 10 1 0 2 0 1 0 Table 1.18 Frequency of Number of Movies Viewed Number of Movies Frequency Relative Frequency Cumulative...

Add binary numbers 0 1010 1100+ 0 0011 1010 a. 0 1110 0110,NZVC= 0000 b. 1...

Add binary numbers 0 1010 1100+ 0 0011 1010 a. 0 1110 0110,NZVC= 0000 b. 1 0101 1011,NZVC= 1001 c. 0 0110 1111,NZVC= 0011 d. 1 0000 0110,NZVC= 1010 e. None of the above

1. Use the Laplace transform to solve the initial value problem. ?"+4?′+3?=1−?(?−2)−?(?−4)+?(?−6), ?(0)=0, ?′(0)=0 2. Use...

1. Use the Laplace transform to solve the initial value problem. ?"+4?′+3?=1−?(?−2)−?(?−4)+?(?−6), ?(0)=0, ?′(0)=0 2. Use the Laplace transform to solve the initial value problem. ?"+4?=?(?), ?(0)=1, ?′(0)=−1 = { 1, ? < 1 where ?(?) = {0, ? > 1.

exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6...

exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6 1 5 6 8 2 4 6 7 3 4 5 9 10 5 8 9 4 7 9 6 7 8 6 How can I detect when 'cin' starts reading from a new line. The amount of numbers in each row is unknown. I need them in type 'int' to use the data.

Year 1 year 2 year 3 Sales Units 2500 2750 2900 sales Price Unit $150.00 $ ...

Year 1 year 2 year 3 Sales Units 2500 2750 2900 sales Price Unit $150.00 $ 150.00 $ 150.00 REVENUE $185,000 $250,000 $440,000 $375,000.00 $ 412,500.00 $ 435,000.00 Variable Costs: Direct Materials $20.00 $20.50 $26.01 Direct Labor $17.15 $17.60 $19.22 Variable OH $2.50 $2.53 $2.55 Fixed Costs: Rent 80,000 $80,000 $80,000 Supervision 200,000 $205,000 $210,250 Mixed Costs: Utilites-Fixed 20,000 20,000 20,000 Utilities-Variable $2.50 $2.50 $2.50 Total Costs: Variable cost per unit $42.15 $43.13...

int a = 3; int b = -2; if((a>0)&&(b>0)){ if (a>b) { System.out.println("A"); } else {...

int a = 3; int b = -2; if((a>0)&&(b>0)){ if (a>b) { System.out.println("A"); } else { System.out.println("B"); } } else if ((b<0)||(a<0)) { System.out.println("C"); } else { System.out.println("D"); }

Project Wind Power Year 0 Year 1 Year 2 Year 3 Costs $6,000,000 $4,000,000 $0 $0...

Project Wind Power Year 0 Year 1 Year 2 Year 3 Costs $6,000,000 $4,000,000 $0 $0 Benefits $18,000,000 $15,000,000 $12,000,000 $12,000,000 Project Hydroelectric power Year 0 Year 1 Year 2 Year 3 Costs $4,000,000 $2,000,000 $1,000,000 $0 Benefits $10,000,000 $14,000,000 $15,000,000 $16,000,000 If the interest rate is 3%, which project would you choose and why? Show your work using excel (15 points) If the interest rate is 15%, which project would you choose and why? Show your work using excel...

Question