Question

An investment costs $465 and is expected to produce cash flows of $100 at the end...

An investment costs $465 and is expected to produce cash flows of $100 at the end of each of the next 4 years, then an extra lump sum payment of $200 at the end of the fourth year. What is the expected rate of return on this investment?

Please show me how to work this problem on Excel. Thank you.

Homework Answers

Answer #1

The expected rate of return on this investment is calculated using the excel function IRR.

IRR takes the cashflows as the input.

IRR = 9.053429%

The expected rate of return on this investment is 9.053429%

Screenshot with formulas

Know the answer?
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
Similar Questions
An investment costs $3,298 today and provides cash flows at the end of each year for...
An investment costs $3,298 today and provides cash flows at the end of each year for 21 years. The investments expected return is 11.4%. The projected cash flows for Years 1, 2, and 3 are $188, $272, and $396, respectively. What is the annual cash flow received for each of Years 4 through 21 (i.e., 18 years)? Assume the same payment for each of these years. (Round answer to 2 decimal places. Do not round intermediate calculations).
An investment costs $2,756 today and provides cash flows at the end of each year for...
An investment costs $2,756 today and provides cash flows at the end of each year for 21 years. The investments expected return is 9.6%. The projected cash flows for Years 1, 2, and 3 are $194, $294, and $374, respectively. What is the annual cash flow received for each of Years 4 through 21 (i.e., 18 years)? Assume the same payment for each of these years. (Round answer to 2 decimal places. Do not round intermediate calculations).
an investment offers the following annual cash flows: end of years 1 thru 10, $5,000 years...
an investment offers the following annual cash flows: end of years 1 thru 10, $5,000 years 11 thru 20, $7500 if your required return on investment is 6%, what is it worth today? answer is $67,624.19 please show how this is worked out, preferrably on excel
An investment is expected to produce $2,000, $800, $0, $3,000, $5,000, and $5,000 at the end...
An investment is expected to produce $2,000, $800, $0, $3,000, $5,000, and $5,000 at the end of first, second, third, fourth, fifth, and sixth year, respectively. Today, the investment costs $12,500. Is this investment profitable? What will be the annual investment yield or rate of return?
The Colby Corporation has been presented with an investment opportunity, which will yield end-of-year cash flows...
The Colby Corporation has been presented with an investment opportunity, which will yield end-of-year cash flows of $10,000 per year in Years 1 through 3, $15,000 per year in Years 4 through 8, and $20,000 in Years 9 & 10. This investment will cost the firm $50,000 today, and the firm's cost of capital is 9 percent. What is the NPV for this investment? Please show work. Thank you.
1. An investment that costs $6,900 will produce annual cash flows of $3,140 for a period...
1. An investment that costs $6,900 will produce annual cash flows of $3,140 for a period of 4 years. Given a desired rate of return of 8%, the investment will generate a present value index of (Do not round your PV factors and intermediate calculations): 2.197. 1.507. 1.971. 0.664. 2. Mountain Brook Company is considering two investment opportunities whose cash flows are provided below: Year Investment A Investment B 0 $ (16,750)         $ (11,100)         1 5,630         5,630...
A skating rink is expected to produce regular annual cash flows of 18,787 dollars with the...
A skating rink is expected to produce regular annual cash flows of 18,787 dollars with the first regular cash flow expected later today and the last regular cash flow expected in 8 years from today. In addition to the regular cash flows of 18,787 dollars, the skating rink is also expected to produce an extra cash flow of 63,836 dollars in 9 years from today. The cost of capital for the skating rink is 5.79 percent. What is the value...
a firm is evaluating a potential investment that is expected to generate cash flows of $100...
a firm is evaluating a potential investment that is expected to generate cash flows of $100 in years 1 thru 4 and $400 in years 5 thru 7. The initial investment is $750. What is the payback for this investment ?
If an investment project is described by the sequence of cash flows: Year Cash flow 0...
If an investment project is described by the sequence of cash flows: Year Cash flow 0 -300 1 -900 2 1100 3 500                 Calculate the MIRR, we will assume a finance rate of 8% and a reinvestment rate of 10%   [5] Find the IRR (using 7%, 10%, 11%) of an investment having initial cash outflow of $3,000. The cash inflows during the first, second, third and fourth years are expected to be $700, $800, $900 and $1,200 respectively            [5]...
Suppose a project costs $300 and produce cash flows of $100 over each of the following...
Suppose a project costs $300 and produce cash flows of $100 over each of the following six years. What is the IRR?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT