Question

5) An investment scheme begins with a deposit of $25,000. At the end of the second year an additional deposit of $500 is made
0 0
Add a comment Improve this question Transcribed image text
Answer #1

к YEAR CASHFLOW 479 480 481 25000 482 500 483 484 485 -1000 486 487 -35000 488 489 IRR 5.12%

IRR=IRR(L480:L487)

I hope my efforts will be fruitful to you....??

Add a comment
Know the answer?
Add Answer to:
5) An investment scheme begins with a deposit of $25,000. At the end of the second...
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
  • At the beginning of the year an investment fund was established with an initial deposit of...

    At the beginning of the year an investment fund was established with an initial deposit of $1,000. A new deposit of $500 was made at the end of four months. Withdrawals of $200 and $100 were made at the end of six months and eight months, respectively. The amount in the fund at the end of the year is $1,272. Find the approximate effective rate of interest earned by the fund during the year using the dollar-weighted rate of return...

  • You deposit $5,000 per year at the end of each of the next 25 years into...

    You deposit $5,000 per year at the end of each of the next 25 years into an account that pays 8% compounded annually. How much could you withdraw at the end of each of the 20 years following your last deposit if all withdrawals are the same dollar amount? (The twenty-fifth and last deposit is made at the beginning of the 20-year period. the first withdrawal is made at the end of the first year in the 20-year period. A....

  • economic. asap Page 4 of 6 Problem 4 A capital investment of $25,000 is made in a project that will produce uniform...

    economic. asap Page 4 of 6 Problem 4 A capital investment of $25,000 is made in a project that will produce uniform annual revenues of $5,000 for 10 years, and then the project terminates. If the minimum attractive rate (MARR) is 10%. 1) Draw a cash flow diagram 2) What is the present worth of this project? 3) Find the internal rate of return (IRR) if a) Salvage value is zero. b) Salvage value is $8.000. 4) If the external...

  • deposit today 25,000 value 10 years from today 50,000 r please help with nuimber 6, but...

    deposit today 25,000 value 10 years from today 50,000 r please help with nuimber 6, but only in EXCEL CHAPTER 2 The Time Value of Money 47 5. (PV single cash flow) Your friend comes to you with a $2,000 post-dated check. The check is due 2 years from today. If the interest rate is 5%, what is the value of the check today? 6. (PV single cash flow, finding r) If you deposit $25,000 today, Union Bank offers to...

  • 6,7 pls 6. A person deposits $1,000 in an account each year for five years beginning...

    6,7 pls 6. A person deposits $1,000 in an account each year for five years beginning at the end of year 1). At the end of the fifth year (immediately after the deposit), one half of the account balance is withdrawn. $2,000 is deposited annually for five more years (starting at the end of year 6), and the total balance is withdrawn at the end of the 15th year. There are no additional deposits made in years 11 - 15....

  • deposit starts year 19 Calculate the value of FV's Investment Account as requested below Timing of...

    deposit starts year 19 Calculate the value of FV's Investment Account as requested below Timing of investment Assumptions Yield % Amount Frenquency Notes $150 Monthly Beginning of period Mom and Dad monthly investments 0 Nana and Papa periodic investments 8% $1,000 deposited at the beginning of year 6, year 11 and year 16 1,000 Yearly Beginning of period 8% 2 Tuition and expenses per year at XYZ University Starting in Year 19 25,000 3 4 5 6 1. What is...

  • Q: You are going to withdraw $1,000 at the end of each year for the next...

    Q: You are going to withdraw $1,000 at the end of each year for the next 6 years from an account that pays constant interest compounded annually. The account balance will reduce to zero when the last withdrawal is made. How much money will be in the account immediately after the fifth withdrawal is made? The interest rate on the account is 15%.

  • n A&E firm planning for a future expansion deposited $44,000 each year for 5 years into...

    n A&E firm planning for a future expansion deposited $44,000 each year for 5 years into a sinking (investment) fund that was to pay an unknown rate of return. If the account had a total of $457,000 immediately after the fifth deposit, what rate of return did the company make on these deposits? The rate of return that the company made was 7%

  • QUESTION 1 Consider an investment that will cost $25,000 and generate the following stream of cash...

    QUESTION 1 Consider an investment that will cost $25,000 and generate the following stream of cash flows in the future:   year $ 1 6,500 2 6,500 3 10,000 4 12,000 5 12,000 What is the net present value of this investment using an 18 percent discount rate? $22,000 $27,698 $2,698 -$5,007 QUESTION 2 What is the internal rate of return of an investment with the following cash flows? year $ 0 (2,000) 1 400 2 400 3 400 4 500...

  • Consider a deposit of $1,300 made today in an investment account. The account yields an annual...

    Consider a deposit of $1,300 made today in an investment account. The account yields an annual return of 3.90% for the next 3 years, then returns 6.90% annually for 9 years after that, and finally yields 2.30% annually for another 8 years, What will be the balance of this account (rounded to the nearest dollar) at the end of this 20 year period? Assume no additional withdrawals or deposits during this period.

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