Question

In: Finance

A 30 year project is estimated to cost $35 million and provideannual cash flows of...

A 30 year project is estimated to cost $35 million and provide annual cash flows of $5 million per year in years 1-5; $4 million per year in years 6-20 and $2 million per year in years 21-30. If the company's required rate of return is 10%, determine the NPV.

Solutions

Expert Solution

i ii iii=i*ii
Year Cash flow in million PVIF @ 10% Present value
0 -35 1 $ (35.00)
1 5 0.909091 $     4.55
2 5 0.826446 $     4.13
3 5 0.751315 $     3.76
4 5 0.683013 $     3.42
5 5 0.620921 $     3.10
6 4 0.564474 $     2.26
7 4 0.513158 $     2.05
8 4 0.466507 $     1.87
9 4 0.424098 $     1.70
10 4 0.385543 $     1.54
11 4 0.350494 $     1.40
12 4 0.318631 $     1.27
13 4 0.289664 $     1.16
14 4 0.263331 $     1.05
15 4 0.239392 $     0.96
16 4 0.217629 $     0.87
17 4 0.197845 $     0.79
18 4 0.179859 $     0.72
19 4 0.163508 $     0.65
20 4 0.148644 $     0.59
21 2 0.135131 $     0.27
22 2 0.122846 $     0.25
23 2 0.111678 $     0.22
24 2 0.101526 $     0.20
25 2 0.092296 $     0.18
26 2 0.083905 $     0.17
27 2 0.076278 $     0.15
28 2 0.069343 $     0.14
29 2 0.063039 $     0.13
30 2 0.057309 $     0.11
NPV = $     4.67
answer = $     4.67 million

Related Solutions

118. A 30 year project is estimated to cost $35 million dollars and provide annual cash...
118. A 30 year project is estimated to cost $35 million dollars and provide annual cash flows of $5 per year in years 1-5; $4 million per year in years 6-20 and $2 million per year in years 21-30. If the company's required rate of return is 10%, determine the discounted payback for the project.
You've estimated the following cash flows (in $ million) for two mutually exclusive projects: Year Project...
You've estimated the following cash flows (in $ million) for two mutually exclusive projects: Year Project A Project B 0 -29 -45 1 30 45 2 40 50 3 50 50 The appropriate discount rate is 9%. Part 1 What is the NPV of project A (in $ million)? Part 2 What is the NPV of project B (in $ million)?
Consider the below estimated cash flows for Project A. Assume the cost of capital is 8%.
  Consider the below estimated cash flows for Project A. Assume the cost of capital is 8%. Year Project A 0 ($30,000) 1 $8,000 2 $9,000 3 $7,000 4 $10,000 8. Find the net present value (NPV) of Project A’s projected cash flows. a. $4,000 b. ($3,200) c. ($1,824) d. $1,754 e. ($1,969) 9. Find the Internal Rate of Return (IRR) Project A’s projected cash flows. a. 13.3%       b. 8.0%       c. 6.3%    ...
A project is estimated to cost $463,565 and provide annual net cash flows of $115,000 for...
A project is estimated to cost $463,565 and provide annual net cash flows of $115,000 for nine years. Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 1.833 1.736 1.690 1.626 1.528 3 2.673 2.487 2.402 2.283 2.106 4 3.465 3.170 3.037 2.855 2.589 5 4.212 3.791 3.605 3.353 2.991 6 4.917 4.355 4.111 3.785 3.326 7 5.582 4.868 4.564 4.160 3.605 8 6.210 5.335 4.968...
The cash flows for the two projects are as follows? ($ million): Project Year 0 Year...
The cash flows for the two projects are as follows? ($ million): Project Year 0 Year 1 Year 2 Year 3 Year 4 A - $ 100 $26 $28 $42 $52 B -$ 100    $52 $42 $28    $18 a. What is the IRR of each? project? b. What is the NPV of each project at your cost of? capital? c. At what cost of capital are you indifferent between the two? projects? d. What should you? do?
1)you've estimated the following cash flows (in$) for a project A. B year. cash flow 0...
1)you've estimated the following cash flows (in$) for a project A. B year. cash flow 0 -5,300 1 1,325 2 2,148 3 2,209 what is the IRE for the project 2)you've estimated the following cash flows (in$) for 2 projects: A. B. C.    year. ProjectA. ProjectB 0. -78 -261 1 15 50 2 21 73 3 29 82 4 35 127 the required return is 7% for both projects What is the IRR for project B? What is the...
You have computed the NPV of a project to be $30 million, using expected cash flows...
You have computed the NPV of a project to be $30 million, using expected cash flows and a risk-adjusted discount rate. You are, however, concerned that you may have made errors on estimating the cash flows and the discount rate. Which of the following make you feel more comfortable with taking the project, given this fear? Select one: a. The project NPV is very sensitive to changes in your discount rate b. In your best case scenario, the project has...
You've estimated the following cash flows (in $) for two mutually exclusive projects: Year Project A...
You've estimated the following cash flows (in $) for two mutually exclusive projects: Year Project A Project B 0 -5,200 -7,800 1 1,325 1,325 2 2,148 2,148 3 3,640 7,360 The required return for both projects is 8%. 1. What is the IRR for project A? 2. What is the IRR for project B? 3. Which project seems better according to the IRR method? 4. What is the NPV for project A? 5. What is the NPV for project B?...
You've estimated the following cash flows (in $) for two mutually exclusive projects: Year Project A...
You've estimated the following cash flows (in $) for two mutually exclusive projects: Year Project A Project B 0 -5,700 -8,550 1 1,325 1,325 2 2,148 2,148 3 4,325 8,384 The required return for both projects is 8%. What is the IRR for project A? What is the IRR for project B? Which project seems better according to the IRR method? Project A Project B What is the NPV for project A? What is the NPV for project B? Which...
•You are looking at a new project and you have estimated the following cash flows: Year...
•You are looking at a new project and you have estimated the following cash flows: Year 0: CF = -$150,000 Year 1-2: CF = $80,000 Year 3-4: CF = $50,000 Year 5-6: CF = $30,000 Year 7: CF = -$180,000 Your cost of capital is 10% Please calculate NPV and IRR, and decide whether we should take this project?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT