Your home has a value today of $160,000. You expect prices to increase at 8% per year (compounded annually) for the next 4 years. After that, you expect prices to increase at 5% per year (compounded annually) for the next 6 years. What do you expect your home to be worth 10 years from now? Enter your answer as a positive number.

An investor plans to invest $500 a year and expects to get a 10.5% return. If the investor makes these contributions at the end of the next 20 years, what is the present value of this investment today?

You decided to deposit $300 each month starting next month for the next 10 years. If your account will grow to be $100,000 by year 10, what rate of return per month are you earning on your deposits?

2. You plan to purchase an office space in Chamblee's Chinatown for $50,000 at the end of year 2021. You estimate that by renting out that office space, you will receive a stream of rental income for the coming eight years at the end of each year as shown in below. After eight years, you estimate that you can still sell the office space for $45,000 at the end of the eighth year. Is this project a good investment if you project that the normal rate of return in this line of business is 12%? How about if the general rate of return is 15% ? 8%? Year 1 $6,000 Year 5 $7,500 Year 2 $6,500 Year 6 $8,500 Year 3 $7,000 Year 7 $8,500 Year 4 $7,500 Year 8 $8,500 3. Based on the information provided in Step 2 above, compute the Internal Rate of Return for the investment. 4. While you were waiting for your first job interview results to come, you spent several dollars to buy a Georgia Educational Lotto and were lucky enough to win a $1 million prize. The prize is to be awarded in 20 annual payments…

use excel and explain why

You are offered an investment that requires you to put up $5,000 today in exchange for $12,000 10 years from now. What is the annual rate of return on this investment?

1. How much would $10,000 due in 100 years be worth today if the discount rate were 9%? 2. You have a chance to buy an annuity that pays $2,000 at the end of each year for 5 years. You could earn 7% on your money in other investments with equal risk. What is the most you should pay for the annuity? 3. You want to buy a condo 5 years from now, and you plan to save $3,000 per year, beginning one year from today. You will deposit the money in an account that pays 8% interest. How much will you have just after you make the 5th deposit, 5 years from now?

6. An investor is considering an investment that will pay $2,150 at the end of each year for the next 10 years. He expects to earn an annual return of 18 percent on his investment. How much should he pay today for the investment? How much should he pay if the investment returns are paid at the beginning of each year?

You have just retired with savings of $10 million. If you expect to live for 60 years and to earn 8% a year on your savings, how much can you afford to spend each year (in $ dollars)? (Assume that you spend the money at the start of each year.) $

If you expect to receive $100 in one year from now, $200 two years from now, and $150 three years from now, how much this cash flow is worth today if the interest rate is 10%?