whats the Discount rate results in the max NPV? how to calculate that in excel?...
90.2K
Verified Solution
Link Copied!
Question
Finance
whats the Discount rate results in the max NPV? how to calculate that in excel? thanks
You are evaluating a project that costs $70,000 today. The project has an inflow of $150,000 in one year and an outflow of $60,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.) Smallest Largest IRR -47.001% 61.07% 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 61.07%
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
