Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Assume you invest $1,000 today in exchange for $220 in one year, $600 in two years, and $400 in three years. What is the
3. Assume you invest $1,000 today in exchange for $220 in one year, $600 in two years, and $400 in three years. What is the annual rate of return on your investment? Put -1000 in cell Al. Put 220 in cell A2, 600 in cell A3, and 400 in cell A4. Go to any other cell in the spreadsheet and use the IRR function. Put in cell A1:A4 for the cell range. You do not need to enter a guess. (Excel asks for this as it uses trial and error to find the correct annual internal rate of return on the investment. If you don't enter a guess it simply starts with 10% as its first trial.) Be sure you answer is in % format and carry it out to the nearest hundredth of a percent
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started