Question

In: Finance

                        Year 0             Year 1     &

                        Year 0             Year 1            Year 2             Year 3             Year 4

Project A         (4,000,000)     1,600,000       1,800,000        2,000,000        2,100,000

Project B         (4,200,000)     500,000          1,700,000        1,900,000        2,000,000

The cost of capital for Project A is assumed to be 14%.

For Project B, which is the riskier project of the two, a risk-adjusted cost of capital of 15% is applied.

(a) Assess the projects using the investment appraisal technique of Net Present Value.

(b) Assess them using the investment appraisal technique of Internal Rate of Return.

Solutions

Expert Solution

a.Project A

Net present value is calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$4,000,000. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the cost of capital of 14%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.

The net present value of cash flows is $1,381,861.94.

Project B

Net present value is calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$4,200,000. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the cost of capital of 15%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.

The net present value of cash flows is -$86,985.82.  

Only Project A can be accepted since it the only project with a positive net present value.

b. Project A

Internal rate of return is calculated using a financial calculator by inputting the below:

Press the CF button.

  • CF0= -$4,000,000. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the IRR and CPT button to get the IRR of the project.

The IRR of project is 29.17%.

Project B

Internal rate of return is calculated using a financial calculator by inputting the below:

Press the CF button.

  • CF0= -$4,200,000. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the IRR and CPT button to get the IRR of the project.

The IRR of project is 14.13%.

Both projects can be accepted since their internal rate of return is higher than the cost of capital.

In case of any query, kindly comment on the solution.


Related Solutions

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...
1.       A project has the following cash flow. Year Costs Benefits 0 $10,000 0 1 0...
1.       A project has the following cash flow. Year Costs Benefits 0 $10,000 0 1 0 $5,000 2 $1,000 $5,000 3 0 $3,000 Assuming a discount rate of 10%, estimate the following: a)      Net Present Value (NPV) b)     Discounted Benefit-Cost Ratio c)      Net discounted Benefit-Cost Ratio d)     Is the project feasible? Explain your answer
3. In R4 , does the set {(1, 1, 1, 0,(1, 0, 0, 0),(0, 1, 0,...
3. In R4 , does the set {(1, 1, 1, 0,(1, 0, 0, 0),(0, 1, 0, 0),(0, 0, 1, 1)}, span R4? In other words, can you write down any vector (a, b, c, d) ∈ R4 as a linear combination of vectors in the given set ? Is the above set of vectors linearly independent ? 4. In the vector space P2 of polynomials of degree ≤ 2, find explicitly a polynomial p(x) which is not in the span...
0 0 2 0 5 3 1 12 0 0 0 1 6 0 1 1...
0 0 2 0 5 3 1 12 0 0 0 1 6 0 1 1 2 8 1 3 1 6 2 4 0 16 17 0 8 0 3 0 0 1 2 5 2 0 2 1 5 0 7 0 1 0 0 1 0 0 3 1 9 4 1 3 0 1 1 1 0 7 1 9 2 0 1 1 1 1 7 2 7 1 2 =============================== (a) What type of...
0. 0. 0. 0.0. 0. 0. 0. 0. 1. 1. 1. 1. 1. 1. 2. 2. 2. 3. 4.
0. 0. 0. 0.0. 0. 0. 0. 0.   1. 1. 1. 1. 1. 1. 2. 2. 2. 3.   4. A.)MEAN – B.)MEDIAN - C.)MODE - D.)STANDARD DEVIATION – E.)5 NUMBER SUMMARY – F.)BOX AND WHISKERS PLOT – G.) OUTLIERS-
0. 0. 0. 0.0. 0. 0. 0. 0. 1. 1. 1. 1. 1. 1. 2. 2. 2. 3. 4.
0. 0. 0. 0.0. 0. 0. 0. 0.   1. 1. 1. 1. 1. 1. 2. 2. 2. 3.   4. A.)5 NUMBER SUMMARY – B.)BOX AND WHISKERS PLOT – C.) OUTLIERS-
A = ⌈ 1 2 0 ⌉ | -1 0 1 | ⌊ 0 1 -1...
A = ⌈ 1 2 0 ⌉ | -1 0 1 | ⌊ 0 1 -1 ⌋ and B = ⌈ 1/3 -2/3 -2/3 ⌉ | 1/3 1/3 1/3 | ⌊ 1/3 1/3 -2/3 ⌋ Given matrices A and B, find AB and BA. Show all work. Are they equal, and why or why not?
Let A =   [  0 2 0 1 0 2 0 1 0 ]  . (a)...
Let A =   [  0 2 0 1 0 2 0 1 0 ]  . (a) Find the eigenvalues of A and bases of the corresponding eigenspaces. (b) Which of the eigenspaces is a line through the origin? Write down two vectors parallel to this line. (c) Find a plane W ⊂ R 3 such that for any w ∈ W one has Aw ∈ W , or explain why such a plain does not exist. (d) Write down explicitly...
The projected net cash flows for a project are (in $thousands): Year Year 0 Year 1...
The projected net cash flows for a project are (in $thousands): Year Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 $(350) $40 $100 $210 $260 $160 Assuming the initial investment is depreciated over the life of the project, the accounting rate of return for the project is Select one: a. 40% b. 25% c. 48% d. 33%
Project Year 0 Year 1 Year 2 Year 3 Year 4 A    -$ 49 $ 25...
Project Year 0 Year 1 Year 2 Year 3 Year 4 A    -$ 49 $ 25 $ 22 $ 22 $ 15 B -$ 101 $ 19 $ 39 $ 51 $ 61 a. What are the IRRs of the two​ projects? b. If your discount rate is 4.8%​, what are the NPVs of the two​ projects? c. Why do IRR and NPV rank the two projects​ differently?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT