A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows:
0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
Project A | -$300 | -$387 | -$193 | -$100 | $600 | $600 | $850 | -$180 |
Project B | -$405 | $135 | $135 | $135 | $135 | $135 | $135 | $0 |
a. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations.
Project A $
Project B $
b. What is each project's IRR? Round your answer to two decimal places.
Project A %
Project B %
c. What is each project's MIRR? (Hint: Consider Period 7 as the end of Project B's life.) Round your answer to two decimal places. Do not round your intermediate calculations.
Project A %
Project B %
d. Construct NPV profiles for Projects A and B. Round your answers to the nearest cent. Do not round your intermediate calculations. Negative value should be indicated by a minus sign.
Discount Rate | NPV Project A | NPV Project B |
0% | $ | $ |
5 | ||
10 | ||
12 | ||
15 | ||
18.1 | ||
24.29 |
e. Calculate the crossover rate where the two projects' NPVs are
equal. Round your answer to two decimal places. Do not round your
intermediate calculations.
%
f. What is each project's MIRR at a WACC of 18%? Round your answer to two decimal places. Do not round your intermediate calculations.
Project A %
Project B %
Project A
cost of capital, WACC, (R)= 13% = 0.13
Cash flow for year 1, C1 = -$387
Cash flow for year 2, C2 = -$193
Cash flow for year 3, C3 = -$100
Cash flow for year 4, C4 = $600
Cash flow for year 5, C5 = $600
Cash flow for year 6, C6 = $650
Cash flow for year 7, C7 = $180
Initial investment , I = $300
NPV of project A = [ (C1/(1.13)1) + (C2/(1.13)2) + (C3/(1.13)3) + (C4/(1.13)4) + (C5/(1.13)5) + (C6/(1.13)6) + (C7/(1.13)7) ] - I
= [ (-387/(1.13)1) + (-193/(1.13)2) + (-100/(1.13)3) + (600/(1.13)4) + (600/(1.13)5) + (850/(1.13)6) + (-180/(1.13)7)] - 300
= $162.48
Project B
Cash flow for year 1, C1 = $135
Cash flow for year 2, C2 = $135
Cash flow for year 3, C3 = $135
Cash flow for year 4, C4 = $135
Cash flow for year 5, C5 = $135
Cash flow for year 6, C6 = $135
Cash flow for year 7, C7 = 0
Initial investment , I = $405
NPV of project B = [ (C1/(1.13)1) + (C2/(1.13)2) + (C3/(1.13)3) + (C4/(1.13)4) + (C5/(1.13)5) + (C6/(1.13)6) + (C7/(1.13)7) ] - I
= [ (135/(1.13)1) + (135/(1.13)2) + (135/(1.13)3) + (135/(1.13)4) + (135/(1.13)5) + (135/(1.13)6)+ 0 ] - 405
= $134.67
b)
IRR is the rate of return for which NPV = 0
NPV = Present value of cash inflows of the project - initial investment
Putting NPV = 0
Present value of cash inflows of the project = initial investment
[ (C1/(1+IRR)1) + (C2/(1+IRR)2) + (C3/(1+IRR)3) + (C4/(1+IRR)4) + (C5/(1+IRR)5) + (C6/(1+IRR)6) + (C7/(1+IRR)7) ] = I
[ (-387/(1+IRR)1) + (-193/(1+IRR)2) + (-100/(1+IRR)3) + (600/(1+IRR)4) + (600/(1+IRR)5) + (850/(1+IRR)6) + (-180/(1+IRR)7) ] = 300
We have to find IRR by trial and error method
by assuming any value and substituting the assumed value in the above equation
we want IRR such that
Leht Hand side of equation(LHS) = Right hand side of equation (RHS) = 300
by following this method we find that for IRR = 18.09671%
LHS = RHS
hence IRR For project A= 18.09671% or 18.10% ( rounding off to two decimal places)
For project B
Present value of cash inflows of the project B = initial investment
[ (C1/(1+IRR)1) + (C2/(1+IRR)2) + (C3/(1+IRR)3) + (C4/(1+IRR)4) + (C5/(1+IRR)5) + (C6/(1+IRR)6) + (C7/(1+IRR)7) ] = I
[ (135/(1+IRR)1) + (135/(1+IRR)2) + (135/(1+IRR)3) + (135/(1+IRR)4) + (135/(1+IRR)5) + (135/(1+IRR)6) + (0/(1+IRR)7) ] = 405
We have to find IRR by trial and error method
by assuming any value and substituting the assumed value in the above equation
we want IRR such that
Leht Hand side of equation(LHS) = Right hand side of equation (RHS) = 405
by following this method we find that for IRR = 24.29247%
LHS = RHS
hence IRR For project B= 24.29247% or 24.29% ( rounding off to two decimal places)
c)
future value of cash flows for project A = C4*(1+R)3 + C5*(1+R)2 + C6*(1+R)1
= 600*(1.13)3 + 600*(1.13)2 + 850*(1.13)
= 2592.378
present value of costs = -300 -[387/(1.13)] - [193/(1.13)2] -[100/(1.13)3] -[180/(1.13)7] = -300 -342.478 - 151.147-69.305 - 76.5109 = -939.441
MIRR = (future value/cost)(1/period of investment) -1
= (2592.378/939.441)(1/7) - 1 = 0.156047 = 15.6047% OR 15.60%
PROJECT B
future value of cash flows for project A = C1*(1+R)6 + C2*(1+R)5 + C3*(1+R)4 + C4*(1+R)3 + C5*(1+R)2 + C6*(1+R)1 + C7
= 135*(1.13)6 + 135*(1.13)5 + 135*(1.13)4 + 135*(1.13)3 + 135*(1.13)2 + 135*(1.13)
= 1269.629
MIRR = (future value/cost)(1/period of investment) -1
= (1269.629/405)(1/7) - 1 = 0.177304 = 17.7304% OR 17.73%
d)
1. when discount rate = 0
NPV of A = -300 -387 - 193 -100+600 + 600+ 850 -180 = 890
NPV of B = -405 +135 +135 +135 +135 + 135+ 135 +0 = 405
2.) when discount rate = 5% = 0.05
NPV for A = [ (-387/(1.05)1) + (-193/(1.05)2) + (-100/(1.05)3) + (600/(1.05)4) + (600/(1.05)5) + (850/(1.05)6) + (-180/(1.05)7)] - 300
= $540.09
NPV for B = [ (135/(1.05)1) + (135/(1.05)2) + (135/(1.05)3) + (135/(1.05)4) + (135/(1.05)5) + (135/(1.05)6) + 0] - 405
= $280.22
3) when discount rate = 10% = 0.10
NPV for A = [ (-387/(1.10)1) + (-193/(1.10)2) + (-100/(1.10)3) + (600/(1.10)4) + (600/(1.10)5) + (850/(1.10)6) + (-180/(1.10)7)] - 300
= $283.34
NPV for B = [ (135/(1.10)1) + (135/(1.10)2) + (135/(1.10)3) + (135/(1.10)4) + (135/(1.10)5) + (135/(1.10)6) + 0] - 405
= $182.96
4)
when discount rate = 12% = 0.12
NPV for A = [ (-387/(1.12)1) + (-193/(1.12)2) + (-100/(1.12)3) + (600/(1.012)4) + (600/(1.12)5) + (850/(1.12)6) + (-180/(1.12)7)] - 300
= $200.41
NPV for B = [ (135/(1.12)1) + (135/(1.12)2) + (135/(1.12)3) + (135/(1.12)4) + (135/(1.12)5) + (135/(1.12)6) + 0] - 405
= $150.04
5)
when discount rate = 15% = 0.15
NPV for A = [ (-387/(1.15)1) + (-193/(1.15)2) + (-100/(1.15)3) + (600/(1.15)4) + (600/(1.15)5) + (850/(1.15)6) + (-180/(1.15)7)] - 300
= $92.96
NPV for B = [ (135/(1.15)1) + (135/(1.15)2) + (135/(1.15)3) + (135/(1.15)4) + (135/(1.15)5) + (135/(1.15)6) + 0] - 405
= $105.91
6)
when discount rate = 18.1% = 0.181
NPV for A = [ (-387/(1.181)1) + (-193/(1.181)2) + (-100/(1.181)3) + (600/(1.181)4) + (600/(1.181)5) + (850/(1.181)6) + (-180/(1.181)7)] - 300
= -$0.09
NPV for B = [ (135/(1.181)1) + (135/(1.181)2) + (135/(1.181)3) + (135/(1.181)4) + (135/(1.181)5) + (135/(1.181)6) + 0] - 405
= $65.97
7)
when discount rate = 24.29% = 0.2429
NPV for A = [ (-387/(1.2429)1) + (-193/(1.2429)2) + (-100/(1.2429)3) + (600/(1.2429)4) + (600/(1.2429)5) + (850/(1.2429)6) + (-180/(1.2429)7)] - 300
= -$143.39
NPV for B = [ (135/(1.2429)1) + (135/(1.2429)2) + (135/(1.2429)3) + (135/(1.2429)4) + (135/(1.2429)5) + (135/(1.2429)6) + 0] - 405
= $0.02
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be...
A company has a 11% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $135 $135 $135 $135 $135 $135 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is each...
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $134 $134 $134 $134 $134 $134 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is each...
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 +++ Project --$300-$387-$193-$100$600$600$850-$180 A Project --$405 $131 $131 $131 $131$131$131 $0 в The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below Open spreadsheet a. What is each project's NPV? Round your answer to the...
A company has a 13% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 1 2 3 4 5 6 7 Project A Project B -$300 -$400 -$387 $134 -$193 $134 -$100 $134 $600 $134 $600 $134 $850 $134 -$180 $0 a. What is each project's NPV? Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent....
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $132 $132 $132 $132 $132 $132 $0 What is each project's NPV? Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent. Project A:...
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $131 $131 $131 $131 $131 $131 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is each...
A company has an 11% WACC and is considering two mutually exclusive investments that cannot be repeated) with the following cash flows: Project A Project B -$300 -$405 -$387 $134 -5193 $134 -$100 $134 $600 $134 $600 $134 $850 $134 - $180 $0 a. What is each project's NPV? Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent. Project A: $ Project B: $ b. What...
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $131 $131 $131 $131 $131 $131 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is each...
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$400 $131 $131 $131 $131 $131 $131 $0 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Project A NPV: $ 200.41 Project...
A company has a 12% WACC and is considering two mutually exclusive investments (that cannot be repeated) with the following cash flows: 0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180 Project B -$405 $132 $132 $132 $132 $132 $132 $0 What is each project's NPV? Negative values, if any, should be indicated by a minus sign. Do not round intermediate calculations. Round your answers to the nearest cent. Project A:...