In the graph NPV will be shown in the y axis and rate in the x axis. The rate of return will be that r at which NPV is 0.
We find NPV at i = 2% and get it as $14.43. At 10% NPV is -$4. Thus NPV is greater than 2% and less than 10%. We build a table and find the following:
| i | NPV |
| 2% | 14.43 |
| 3% | 11.80 |
| 4% | 9.28 |
| 5% | 6.85 |
| 6% | 4.52 |
| 7% | 2.27 |
| 8% | 0.10 |
| 8.047% | 0 |
| 9% | - 1.99 |
| 10% | - 4.00 |
Thus rate of return is 8.047%
Graph is shown below:

2. Consider the following cash flow. Year Cash Flow - 100 +50 نہ دیا و +40...
Solve using Excel please!
Determine the rate of return for the following cash flow. Year نہ سا Net cash flow -80000 -9000 40000 70000
(U15) value: 4.00 points A project has the following cash flows: Year نے نہ دیا Cash Flow -$16,200 6,900 8,200 6,700 What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations a round your answer to the nearest whole number, e.g., 32.) NPV What is the NPV at a discount rate of 10 percent? (Do not round intermediate calculations and roun your answer to 2 decimal places, e.g., 32.16.) NPV
Consider the following two projects: Discount Rate Project Year 0 Cash Flow -100 -73 Year 1 Cash Flow 40 30 30 Year 2 Cash Flow 50 30 Year 3 Cash Flow 60 30 Year 4 Cash Flow N/A 30 .15 B The payback period for project B is closest to: Select one: A.2.2 years B.2.5 years C.2.4 years D. 2.0 years
Consider the following timeline: Date 0 1 2 3 -$150 $40 $80 $100 Cash flow If the current market rate of interest is 12%, then the value of the cash flows in year 0 and year 2 as of year 1 is closest to: O A. $171 B. $79 C. - $70 OD. - $79
A project has the following cash flows: Cash Flow Year -$200 $50 0 1 X $90 $100 $130 5 Notice this project requires two cash outflows at Years 0 and 2, and produces positive cash inflows in the remaining periods. The project's appropriate WACC is 10% and its modified internal rate of return (MIR) is 13.43%. What is the project's cash outflow in Year 2? $100 $80 $65 $30 $10 OOOO
Calculate the Internal Rate of Return for the following cash flow. Year Cash Flow 0 -100 1 20 2 50 3 80 Option A: 16.98% Option B: 19.88% Option C: 18.79% Option D: 15.32%
Consider the following two projects: 763,088.5469 Proiect Year 0 Year 1 Year 2 Year 3 Year 4 Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow - 100 40 50 60 N/A - 7330 30 Discount Rate 0.14 0.14 30 The net present value (NPV) of project A is closest to: O A 17.6 O B. 15.5 O C. 14.1 OD 35.1 What is the internal rate of return (IRR) of an investment that requires an initial investment of...
Use the table for the question(s) below. Consider the following two projects: Year 4 Project Year 0 Cash Flow -100 -73 Year 1 Cash Flow 40 30 Year 2 Cash Flow 50 30 Year 3 Cash Flow 60 30 Cash Flow N/A 30 Discount Rate 15 15 A The internal rate of return (IRR) for project A is closest to: Select one: A. 21.6% B. 23.3% C. 42.9%
A capital budgeting project has the following cash flows: Year Cash Flow 0 ($100) 1 $20 2 $40 3 $60 Assume that the firm's reinvestment rate and the cost of capital are both 10% What is the Modified Internal rate of Return of the project? a 11.28% b 8.63% c 10% d 7.79%
Consider the following two projects: Project Year 0 Year 1 Year 2 Year 3 Year 4 Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow A - 100 40 50 60 N/A B -73 30 30 30 30 Discount Rate 0.1 0.1 The net present value (NPV) of project A is closest to: A. 28.5 B. 56.9 C. 25 D. 22.8