Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Crypto Asset Investing In The Age Of Autonomy

Authors: Jake Ryan

1st Edition

1119705363, 978-1119705369

More Books

Students also viewed these Finance questions