Question

You invest $2,350 in stock and receive $24 , $26 , $26 , and $ 24...

You invest $2,350 in stock and receive $24 , $26 , $26 , and $ 24 in dividends over the following 4 years. At the end of the 4 years, you sell the stock for $3,000. What was the IRR on this investment?

The IRR on this investment is

0 0
Add a comment Improve this question Transcribed image text
Answer #1

To calculate IRR , we can use financial calculator.

Cash flows will be as follow:

CF0 = -2350 , CF1= 24 , F1=1 , CF2 = 26 , F2 =2 , CF3 = 3024 ( dividend + selling price of stock) , F3 =1 CPT IRR

IRR = 7.269%

To calculate in MS excel,

Write down all the cashflows as shown in figure below.

Formula for IRR =IRR(values, guess) as shown in figure.

.0 4 1 24 Cash flows2350 IRR 26 26 3024 7.269%)=IRR(G16:K16,10)

Add a comment
Know the answer?
Add Answer to:
You invest $2,350 in stock and receive $24 , $26 , $26 , and $ 24...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You invest $9,724 in stock and receive $105, $114, $114, and $105 in dividends over the...

    You invest $9,724 in stock and receive $105, $114, $114, and $105 in dividends over the following 4 years. At the end of the 4 years, you sell the stock for $13,000. What was the IRR on this investment? The IRR on this investment is %. (Round to the nearest whole percent.)

  • Suppose you invest $ 3,500 today and receive $ 9,000 in five years. a. What is...

    Suppose you invest $ 3,500 today and receive $ 9,000 in five years. a. What is the internal rate of return​ (IRR) of this​ opportunity? b. Suppose another investment opportunity also requires $ 3,500 ​upfront, but pays an equal amount at the end of each year for the next five years. If this investment has the same IRR as the first​ one, what is the amount you will receive each​ year?

  • Use growing annuity formula. You buy a share of Amazon stock and will receive $4 in dividends the following year. The d...

    Use growing annuity formula. You buy a share of Amazon stock and will receive $4 in dividends the following year. The dividends will grow at 5% for the next five years. You will sell the Amazon stock for $330 at the end of the five years when you get the dividends. What will be the cost of each stock if you require a 7 percent return on your initial investment?

  • If you invest $10,000 today and earn a 20% annual internal rate of return (IRR) over...

    If you invest $10,000 today and earn a 20% annual internal rate of return (IRR) over five years (with all of the proceeds received at the end of the fifth year), then the amount you will receive at the end of the fifth year is: How much would you pay today for an investment offering a lump sum of $100,000 in five years if you hoped to earn an annual rate of return of 25%? You invest $300,000 today and...

  • Your friend asks you to invest $15,000 in a business venture. Based on your estimates, you...

    Your friend asks you to invest $15,000 in a business venture. Based on your estimates, you would receive nothing for 3 years, at the end of year 4 you would receive $5,407 , and at the end of year 5 you would receive $18,083. If your estimates are correct, what would be the IRR on this investment?

  • 4. Bond Valuation Suppose you invest $3500 today and receive $9500 in five years. a. What...

    4. Bond Valuation Suppose you invest $3500 today and receive $9500 in five years. a. What is the IRR of this opportunity? b. Suppose another investment opportunity also requires $3500 upfront, but pays an equal amount at the end of each year for the next five years. If this investment has the same IRR as the first one, what is the mount you will receive each year? 5. Bond Valuation Suppose that Ally Financial Inc. issued a bond with 10...

  • There are three options of investment: If you invest 1000 now, you will receive 375 each...

    There are three options of investment: If you invest 1000 now, you will receive 375 each at the end of next three years. If you invest 1000 now, you will receive 1080 at the end of 1st year. If you invest 1000 now, you will receive 1100 at the end of 2nd year. Risk-free interest rate is assumed to be 5%. Would you invest any of them? Why? Which one would you pick?    Why?   

  • 2. Your friend asks you to invest $10,000 in a business venture. Based on your estimates,...

    2. Your friend asks you to invest $10,000 in a business venture. Based on your estimates, you would receive nothing for four years, at the end of year 5 you would receive interest on the investment compounded annually at 8%, and at the end of year 6 you would receive $14,500. If your estimates are correct, what would be the IRR on this investment?

  • 1. Your friend asks you to invest $10,000 in a business venture. Based on your estimates,...

    1. Your friend asks you to invest $10,000 in a business venture. Based on your estimates, you would receive nothing for four years, at the end of year 5 you would receive interest on the investment compounded annually at 8%, and at the end of year 6 you would receive $14,500. If your estimates are correct, what would be the IRR on this investment?

  • will be the cost of her investment? (Stock valuation) Janice plans to buy 300 shares of...

    will be the cost of her investment? (Stock valuation) Janice plans to buy 300 shares of common stock today and sell it in six years. She expects to receive a cash dividend of $3.10 over the next six years. Thereafter, dividends are expected to growth indefinitely at 1.5%. If she can invest in a similar stock with a cost of equity of 13.5%, what is the maximum that she should be willing to pay for each share of this stock?...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT