Question

In: Finance

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?

Solutions

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.


Related Solutions

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"); }
Use the following information for part a and b. The 1-year, 2-year, 3-year and 4-year zero...
Use the following information for part a and b. The 1-year, 2-year, 3-year and 4-year zero rates are 2%, 3%, 4% and 5% per annum (APR) with quarterly compounding/payment. A)What are the zero coupon bond prices with maturities of 1 year, 2 years, 3 years and 4 years? (Assume that you receive a face value of $100 for each of these bonds on their maturity dates). B)What are the corresponding per annum zero rates with continuous compounding? Please show work...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT