Question
In: Finance
•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?
Solutions
Expert Solution
| Project | ||||||||
| Discount rate | 10.000% | |||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Cash flow stream | -150000 | 80000 | 80000 | 50000 | 50000 | 30000 | 30000 | -180000 |
| Discounting factor | 1.000 | 1.100 | 1.210 | 1.331 | 1.464 | 1.611 | 1.772 | 1.949 |
| Discounted cash flows project | -150000.000 | 72727.273 | 66115.702 | 37565.740 | 34150.673 | 18627.640 | 16934.218 | -92368.461 |
| NPV = Sum of discounted cash flows | ||||||||
| NPV Project = | 3752.78 | |||||||
| Where | ||||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||||
| IRR is the rate at which NPV =0 | ||||||||
| IRR | 17.14% | |||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Cash flow stream | -150000.000 | 80000.000 | 80000.000 | 50000.000 | 50000.000 | 30000.000 | 30000.000 | -180000.000 |
| Discounting factor | 1.000 | 1.171 | 1.372 | 1.607 | 1.883 | 2.205 | 2.583 | 3.026 |
| Discounted cash flows project | -150000.000 | 68297.046 | 58306.081 | 31110.415 | 26559.368 | 13604.448 | 11614.295 | -59491.653 |
| NPV = Sum of discounted cash flows | ||||||||
| NPV Project = | 0.000 | |||||||
| Where | ||||||||
| Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||||
| Discounted Cashflow= | Cash flow stream/discounting factor | |||||||
| IRR= | 17.14% | |||||||
Accept project as NPV is positive and IRR> cost of capital
jeff jeffy answered 1 year agoRelated Solutions
A capital budget project is estimated to have the following after-tax cash flows, by year: 0...
A capital budget project is estimated to have the
following after-tax cash flows, by year:
0
1
2
3
4
-$35,000
$13,000
$15,000
$17,000
$19,000
Use the information in the table above for the following
questions 11a. through 11f. The company utilizes a discount rate of
9% to evaluate capital projects. You may have rounding errors in
your calculations so choose the closest answer.
1. Find NPV, IRR, MIRR, and PI for the project shown
above
2. Find Payback and...
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...
Costco, Inc. is conducting a new project with the following estimated cash flows. The initial outlay...
Costco, Inc. is conducting a new project with the
following estimated cash flows. The initial outlay is estimated to
be $1,950,000, and the incremental cash flows generated by this
project would be $650,000 per year for 7 years. The estimated
required rate of return of the project is 6%.
a. Calculate the NPV.
b. Calculate the PI.
c. Calculate the IRR.
d. Should this project be accepted?
You are considering a project with the following cash flows: YEAR PROJECT CASH FLOW ...
You are considering a project with the following cash
flows:
YEAR
PROJECT CASH FLOW
0
-60,000
1
25,000
2
25,000
3
25,000
4
25,000
If the appropriate discount rate is 11 percent, what is the
project's discounted payback period in years?
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...
1. Chronic Pain Clinic has estimated the following cash flows associated with a new project. The...
1. Chronic Pain Clinic has estimated the following cash flows
associated with a new project. The project cost of capital
(discount rate) is 8 percent.
Year 0: ($700,000)
Year 1: $400,000
Year 2: $400,000
Year 3: $400,000
2. What is the project’s net present value?
A. $186,897
B. $197,619
C. $208,225
D. $324,538
E. $330,839
Chronic Pain Clinic has estimated the following cash flows
associated with a new project. The project cost of capital
(discount rate) is 9 percent.
Year...
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)?
(Discounted payback period) You are considering a project with the following cash flows: YEAR PROJECT CASH...
(Discounted payback period) You are considering a project with
the following cash flows:
YEAR PROJECT
CASH FLOW
0 -40,000
1 15,000
2 15,000
3 15,000
4 15,000
If the appropriate discount rate is 12 percent, what is the
project's discounted payback period?
The project's discounted payback period is ___ years. (Round to
two decimal places.)
Risky Business is looking at a project with the following estimated cash flow: Initial investment at...
Risky Business is looking at a project with the following
estimated cash flow:
Initial investment at start of project: $10,000,000
Cash flow at end of year one: $1,700,000
Cash flow at end of years two through six: $2,000 each
year
Cash flow at end of years seven through nine: $2,040,000 each
year
Cash flow at end of year ten: $1,569,231
Risky Business wants to know the payback period, NPV, IRR,
MIRR, and PI of this project. The
appropriate discount rate...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Gives the following four numbers: a.01101010 b.11110001 c.10001000 d.00100010 then answer the questions: (i) What's the...
- Weez Ltd is a GST registered retailer of widgets with monthly accounting periods. The following is...
- explain the relationship between the SEC and the various private sector standard setting bodies that have,...
- You have been asked to prepare a December cash budget for Ashton Company, a distributor of...
- Holly bought a 7-year bond, with a 3% coupon paid semi annually. It was priced to...
- METAR Abbreviations METAR (Meteorological Aviation Report) is a format for reporting weather information, either for pilots...
- The data below are the heights of fathers and sons (inches). There are 8 rows in...
ADVERTISEMENT