In: Finance
|
You are evaluating a project that costs $69,000 today. The project has an inflow of $148,000 in one year and an outflow of $59,000 in two years. |
|
What are the IRRs for the project? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) |
| IRR | |
| Smallest | % |
| Largest | % |
|
What discount rate results in the maximum NPV for this project? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) |
| IRR | % |
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Please note: Excel solver used to calculate Discount rate for Maximum NPV of Project.
