Register
IRR in Excel!(CHAPTER 9) Your company is considering a new project opportunity. It would immediately receive $200. In return, in the next 4 years it will need to pay the following amounts of money: In
222,284 views
1 vote
1 vote
IRR in Excel!(CHAPTER 9) Your company is considering a new project opportunity. It would immediately receive $200. In return, in the next 4 years it will need to pay the following amounts of money: In 1 year: $80 In 2 years: $70 In 3 years: $60 In 4 years: $50 The required annual rate of return is 19%. Answer the following questions: (a) The Internal Rate of Return for this project is . %. (Round your answer to TWO decimal places. Put your answer in percent, NOT in decimals. For example, if your answer is 12.34 percent, then you need to put 12.34, and NOT 0.12)

User Ssbarbee
by
3.1k points

1 Answer

23 votes
23 votes

Answer:

12.44%

Step-by-step explanation:

Internal rate of return is the discount rate that equates the after-tax cash flows from an investment to the amount invested

IRR can be calculated with a financial calculator

cash floe in yer0 = 200

cash flow in year 1 = -80

cash flow in year 2 = - 70

cash flow in year 2 = - 60

cash flow in year 2 = - 40

irr = 12.44%

To find the IRR using a financial calculator:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. After inputting all the cash flows, press the IRR button and then press the compute button.

User Astery
by
3.4k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

1.6m questions

2.0m answers

Other Questions

If the rate of inflation in Japan dramatically increases while the rate of inflation in the United States remains constant, then a. the demand curve for dollars shifts to the left. b. the demand curve
If you buy a one-year bond for $4,000 and the issuer pays you back $5,000 at the end of one year, the interest rate on the bond is
Kylie is risk averse and has $1,000 with which to make a financial investment. She has three options. Option A is a risk-free government bond that pays 5 percent interest each year for two years. Option
Elroy Rocket is entering his senior year as an accounting major and has a number of options for his summer break. His options for the 3 month break follow: (1) Work full time at a local accounting firm
Jillian Diaz receives a regular salary of $1,500 a month and is entitled to overtime pay at the rate of one and one-half times the regular hourly rate for any time worked in excess of 40 hours per week.
Link Copied!