Question

You plan to invest $350,000 every 6 months for the next 10 years. What annual rate...

You plan to invest $350,000 every 6 months for the next 10 years. What annual rate of return would you earn if you have $10,000,000 by the end of 10 years? (Round to 2 decimal places)

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

J 312 L 350000 313 half yearly Investment Period (No. of half years) Future value 201 314 10000000 315 316 L Rate(half yearly

Formulas used:-

Rate(half yearly)=RATE(L313,-L312,0,L314)

Annual Rate of Return =L316*2

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

Add a comment
Know the answer?
Add Answer to:
You plan to invest $350,000 every 6 months for the next 10 years. What annual rate...
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 have $17,500 you want to invest for the next 40 years. You are offered an...

    You have $17,500 you want to invest for the next 40 years. You are offered an investment plan that will pay you 6 percent per year for the next 20 years and 10 percent per year for the last 20 years. a. How much will you have at the end of the 40 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. If the investment plan pays you 10 percent per year...

  • You have $20,000 you want to invest for the next 40 years. You are offered an...

    You have $20,000 you want to invest for the next 40 years. You are offered an investment plan that will pay you 6 percent per year for the next 20 years and 10 percent per year for the last 20 years. a. How much will you have at the end of the 40 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. If the investment plan pays you 10 percent per year...

  • You have $16,500 you want to invest for the next 28 years. You are offered an...

    You have $16,500 you want to invest for the next 28 years. You are offered an investment plan that will pay you 6 percent per year for the next 14 years and 10 percent per year for the last 14 years. a. How much will you have at the end of the 28 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. If the investment plan pays you 10 percent per year...

  • 1. 2. You plan to make annual end-of-year deposits of $3,000 for the next 10 years...

    1. 2. You plan to make annual end-of-year deposits of $3,000 for the next 10 years followed by a final deposit of $11,000 at the end of year 11. The deposits earn interest of 4.0%. What will the account balance be by the end of 17 years? Round to the nearest cent. Numeric Answer: If $1,000 is invested in an account earning 6% interest compounded quarterly for 5 years, what is the periodic interest rate (i/m)? Provide the answer in...

  • in a mutual fund with a 7% load and expense ratio of 075%. You can Invest...

    in a mutual fund with a 7% load and expense ratio of 075%. You can Invest instead in a bank an CD paying 2% interest. a. If you plan to Invest for 4 years, what annual rate of return must the fund portfollo earn for you to be better off in the fund than in the CD? Assume annual compounding of returns. (Do not round Intermediate calculations. Round your answer to 2 declmal places.) b. What annual rate of return...

  • Need a help with a, b, and c please. Thank you. You are considering an investment...

    Need a help with a, b, and c please. Thank you. You are considering an investment in a mutual fund with a 4% load and an expense ratio of 0.55%. You can invest instead in a bank CD paying 6% interest. a. If you plan to invest for two years, what annual rate of return must the fund portfolio earn for you to be better off in the fund than in the CD? Assume annual compounding of returns (Do not...

  • your client intends to invest 3000 every 6 months for the next 4 1/2 years if...

    your client intends to invest 3000 every 6 months for the next 4 1/2 years if the investment earns 5% compounded monthly , what will be the total accumulated value after the 4 1/2 years if the first payment is made immediately ?

  • 1. Your current salary is $100,000 per year. Every year you save 10 percent of your...

    1. Your current salary is $100,000 per year. Every year you save 10 percent of your salary and invest it in a retirement plan which provides you a guaranteed return of 6 percent per year. Assume the deposits will be made at the end of each year for the next 40 years. a) How much will you have at the end of 40 years if your salary grows at 6 percent per year? b) What annual fixed amount will you...

  • 6 a. You plan to make 5 deposits of $1,000 each, one every 6 months, with...

    6 a. You plan to make 5 deposits of $1,000 each, one every 6 months, with the first payment being made in 6 months. You will then make no more deposits. If the bank pays 5 % nominal interest, compounded semiannually,how much will be in your account after 3 years? Round your answer to two decimal places at the end of the calculations. For example, if your answer is $345.667 enter as 345.67 and if your answer is .05718 or...

  • 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...

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
ADVERTISEMENT