Question

The investment is being offered to her at an initial purchase price of $459,000. After 5...

The investment is being offered to her at an initial purchase price of $459,000. After 5 years, she is hoping to sell this investment for $500,000. During the 5-year period, the client expects annual cash flows of $17,500, $85,000, $8,500, $9,000, and $10,000. What is the client’s internal rate of return (IRR) on the investment?

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Internal rate of return is the rate at which net present value of cash flow is zero.
Year Cash Flow
0 $        -4,59,000
1 17,500
2 85,000
3 8,500
4 9,000
5 5,10,000
IRR = =irr(C4:C9)

C4:C9 is the cash flows from year 0 to 5.

= 7.48%
Working:
Year 5 cash flow = $             10,000 + $       5,00,000
= $         5,10,000
Add a comment
Know the answer?
Add Answer to:
The investment is being offered to her at an initial purchase price of $459,000. After 5...
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
  • A client is considering making a significant investment in a partnership. The investment is being offered...

    A client is considering making a significant investment in a partnership. The investment is being offered to her at an initial purchase price of $259,000. After 5 years, she is hoping to sell this investment for $100,000. During the 5-year period, the client expects annual cash flows of $17,500, $88,000, $80,500, $90,000, and $10,000. If the client has a required rate of return of 10%, should she make this investment?

  • 16) You are offered an investment that will pay the following cash flows at the end...

    16) You are offered an investment that will pay the following cash flows at the end of each of the next five years at a cost of $800. What is the Net Present Value (NPV) if the required rate of return is 12% per year? Period Cash Flow 0 $0 1 $100 2 $200 3 $300 4 $400 5 $500 Remember that Excel’s NPV function doesn't really calculate the net present value. Instead, it simply calculates the present value of...

  • Investment Opportunity: Purchase Price: Useful Life: Cost of Capital: Zimboozy $17,500 5 years 8.00% YEAR Cash...

    Investment Opportunity: Purchase Price: Useful Life: Cost of Capital: Zimboozy $17,500 5 years 8.00% YEAR Cash in PV $ Data: 5,000 8,000 13,000 7,000 8,000 Cash out $17,500 2,500 4,000 5,200 4,800 3,000 Net Flow (17,500) 2,500 4,000 7,800 2,200 5,000 4,000 Summary of annual cash flows YEAR Cash in NPV $ Cash out $17,500 2,500 4,000 5,200 4,800 3,000 5,000 8,000 13,000 7,000 8,000 Net Flow (17,500) 2,500 4,000 7,800 2,200 5,000 4,000 IRR approach to capital budgeting Input...

  • QUESTION 28 5 point (5 points) A capital project has an initial investment of $100,000 and...

    QUESTION 28 5 point (5 points) A capital project has an initial investment of $100,000 and cash flows in years 16 of 525.000, 515.000, 550,000, 110,000, $10,000, and 500,000, respectively. Given a 15 percent cost of capital (a) compute the net present value • (b) compute the internal rate of return 1) should the project be accepted? Why or why not? 30

  • An heiress has a rich grandfather who set up a trust that will pay her $5...

    An heiress has a rich grandfather who set up a trust that will pay her $5 million per year for 20 years beginning on her 25th birthday. Assume her 25th birthday is 4 years from now. Further assume that you are a wealthy investor and this heiress is anxious to get her hands on some serious cash. You are offered the opportunity to purchase the rights to receive the promised cash flows from the trust. a.  If you were to pay...

  • investment is answer is a number and npv is a number answers too 5. Understanding the...

    investment is answer is a number and npv is a number answers too 5. Understanding the IRR and NPV Aa Aa The net present value (NPV) and internal rate of retum (IRR) methods of investment analysis are interrelated and are sometimes used together to make capital budgeting dedisions. Consider the case of Blue Hamster Manufacturing Inc.: Last Tuesday, Blue Hamster Manufacturing Inc. lost a portion ofits planning and financial data when bath its main and its backup servers crashed. The...

  • McCormick & Company is considering a project that requires an initial investment of $24 million to...

    McCormick & Company is considering a project that requires an initial investment of $24 million to build a new plant and purchase equipment. The investment will be depreciated as a modified accelerated cost recovery system (MACRS) seven-year class asset. The new plant will be built on some of the company's land, which has a current, after-tax market value of $4.3 million. The company will produce bulk units at a cost of $130 each and will sell them for $420 each....

  • Today is 1 January 2019. Kim is looking for an investment that will give her $500,000 in 5 years’ time so that she will have a sufficient deposit to purchase a $2.5m house in Sydney. Currently she has...

    Today is 1 January 2019. Kim is looking for an investment that will give her $500,000 in 5 years’ time so that she will have a sufficient deposit to purchase a $2.5m house in Sydney. Currently she has saved about $380,000 to contribute to the deposit. She has started looking at Treasury bonds as she thinks they are a relatively low risk investment. However, she did not study finance at University so does not have a good understanding of Treasury...

  • All scenarios are independent of all other scenarios. Assume that all cash flows are after-tax cash flows a. Kambry Da...

    All scenarios are independent of all other scenarios. Assume that all cash flows are after-tax cash flows a. Kambry Day is considering investing in one of the following two projects. Either project will require an investment of $20,000. The expected cash flows for the two projects follow. Assume that each project is depreciable. Year Project A ProjectB 6,000 6,000 2 8,000 8,000 3 10,000 10,000 4 10,000 3,000 10,000 5 3,000 b. Wilma Golding is retiring and has the option...

  • 5 Consider the investment project with the following net cash flows: Year Net Cash Flow 0...

    5 Consider the investment project with the following net cash flows: Year Net Cash Flow 0 $1,500 SX $650 SX What would be the value of X if the project's IRR is known to be 10%? The annual income from a rented house is $24,000. The annual expenses are $6000. If the house can be sold for $245,000 at the end of 10 years, how much could you afford to pay for it now, if you considered 900 to be...

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