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.