Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. whats the discount rate results in the max npv? ho

whats the Discount rate results in the max NPV? how to calculate that in excel?...

90.2K

Verified Solution

Question

Finance

image
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!
Become a Member

Other questions asked by students