Question

The following table shows the cash flows for a project. The required rate of return in...

The following table shows the cash flows for a project. The required rate of return in 20%. Compute the IRR.

Year Project cash flow
0 -$120,000
1 $100,000
2 $40,000
3 $10,000

Group of answer choices

17%

20%

18%

19%

Homework Answers

Answer #1

IRR is that Discount rate, at which NPV is 0

NPV is sum of present value of all cash flows.

Present value of cash flows = cash flows * PVF

PVF = 1/(1+discount rate)^year

Assume irr is 17%

year Cash flows P.V.F.@ 17%
Year 0 -120000 1 -120000
Year 1 100000 0.8547008547 85470.08547
Year 2 40000 0.730513551 29220.54204
Year 3 10000 0.6243705564 6243.705564
NPV 934.3330755

Assume irr is 18%

year Cash flows P.V.F.@ 18%
Year 0 -120000 1 -120000
Year 1 100000 0.8474576271 84745.76271
Year 2 40000 0.7181844298 28727.37719
Year 3 10000 0.6086308727 6086.308727
NPV -440.5513709

IRR = Lower rate + (higher rate - lower rate)*(NPV at lower rate - 0)/(NPV at lower rate - NPV at higher rate)

17%+((18%-17%)*(934.3330755-0) /(934.3330755-(-440.5513709))

=0.1767957207 or 17.68%

So irr is 17.68% or 18%

answer is 18%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You've estimated the following cash flows (in $) for a project: The required return is 8.5%....
You've estimated the following cash flows (in $) for a project: The required return is 8.5%. What is the IRR for the project? What is the NPV of the project? A B 1 Year Cash flow 2 0 -3,320 3 1 974 4 2 1,281 5 3 1,875
A project will generate the following cash flows. If the required rate of return is 15%,...
A project will generate the following cash flows. If the required rate of return is 15%, what is the project’s net present value? Year Cash flow 0 –$50,000 1 $15,000 2 $16,000 3 $17,000 4 $18,000 5 $19,000 Select one: a. $16,790.47 b. $6,057.47 c. $3,460.47 d. $1,487.21 e. –$3,072.47 Question 5 Not yet answered Marked out of 1.00 Flag question Question text A project will generate the following cash flows. The required rate of return is 15%. If the...
You are considering an investment with the following cash flows. If the required rate of return...
You are considering an investment with the following cash flows. If the required rate of return for this investment is 16.5 percent, should you accept the investment based solely on the internal rate of return rule? Why or why not? Year: 0, 1, 2, 3 Cash Flow: -152000, 98,200, 102,300, -4,900 A. Yes; The IRR exceeds the required return. B. Yes; The IRR is less than the required return. C. No; The IRR is less than the required return. D....
Given the following end of year cash flows (CF) estimate the internal rate of return (IRR)...
Given the following end of year cash flows (CF) estimate the internal rate of return (IRR) of this project. If the project’s cost of capital is 10%, would you undertake this project? Timeline 0 1 2 3 4 CF 0 700 700 700 -3,000 Group of answer choices No; IRR = 18.93% Yes; IRR = 18.93% No; IRR = 7.50% Yes, IRR is greater than the cost of capital
Starwood Inc. is investigating a project with the following cash flows and its cost of capital...
Starwood Inc. is investigating a project with the following cash flows and its cost of capital is 13%. Year                Cash Flow 0                      -$34,000,000 1                      $ 9,000,000 2                      $ 9,000,000 3                      $ 9,000,000 4                      $ 9,000,000 5                      $ 9,000,000 6                      $ 9,000,000 7                      $ 9,000,000 What is the internal rate of return (IRR) of this project? Group of answer choices 18.84% 26.47% 15.57% 18.31% 9.21%
Consider the following cash flows for two mutually exclusive capital investment projects. The required rate of...
Consider the following cash flows for two mutually exclusive capital investment projects. The required rate of return is 16%. Use this information for the next 3 questions. Year         Project A Cash Flow        Project B Cash Flow 0                         ($50,000)                      ($20,000) 1                           15,000                           6,000 2                           15,000                           6,000 3                           15,000                           6,000 4                           13,500                           5,400 5                           13,500                           5,400 6                             6,750                           5,400 What is the profitability index of project B? Group of answer choices 1.09 1.01 .94 1.06 1.03 then calculate the net present...
Given the following cash flows for a capital project, calculate the NPV and IRR. The required...
Given the following cash flows for a capital project, calculate the NPV and IRR. The required rate of return is 8 percent. Year 0 1 2 3 4 5 Cash Flows $-37004 $11550 $12750 $16800 $10700 $5350 NPV=4947. IRR=18.0% NPV=4947. IRR=9.9% NPV=9464. IRR=9.9% NPV=9464. IRR=18.0%
A project has the following total (or net) cash flows.                ________________________________________             
A project has the following total (or net) cash flows.                ________________________________________                 Year         Total (or net) cash flow                ________________________________________ 1 $50,000 2 70,000 3 80,000 4 100,000 _______________________________________    The required rate of return on the project is 13 percent. The initial investment (or initial cost or initial outlay) of the project is $100,000. a) Find the (regular) payback period of the project. b) Compute the discounted payback period of the project.
A project has the following total (or net) cash flows.                ________________________________________             
A project has the following total (or net) cash flows.                ________________________________________                 Year         Total (or net) cash flow                ________________________________________ 1 $50,000 2 70,000 3 80,000 4 100,000 _______________________________________    The required rate of return on the project is 13 percent. The initial investment (or initial cost or initial outlay) of the project is $100,000. a) Find the (regular) payback period of the project. b) Compute the discounted payback period of the project.
A project has the following cash flows. What is the internal rate of return?                Year             ...
A project has the following cash flows. What is the internal rate of return?                Year                 0                      1                        2                     3                Cash flow     -$782,100        $219,500             $348,600           $348,600