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
Not the answer you're looking for?
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.
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...
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 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.
ADVERTISEMENT
Active Questions
asked 7 minutes ago
asked 47 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago