Please do these problems on excel and by hand

7_____You invest $100,000 today at a rate of 5.6%. You take $800 a month out of your account and spend it. How much will you have in your account in 10 years?

$46,543

$96,596

$112,936

$303,135

8_____You have $50,000 to invest today. You hope to have $2,000,000 in forty years. If you do not plan on making any additional investments, what annual rate of return will you have to achieve on your investment to reach your goal?

9.66%

13.59%

18.21%

21.45%

1_____You have an opportunity to make an investment today that you estimate will generate a cash flow of $1,500 in year one, $1,600 in year two and $2,500 in year three. Assume all cash flows will occur at the end of each year and that the investment will have no value after year three. If you feel the appropriate rate of return on this investment is 15%, how large of an investment are you willing to make today in order to generate these cash flows?

$5,600

$4,782

$4,158

$3,992

2_____You make a $20,000 investment that gives you a cash flow of $1,900 in year one, $1,200 in year two, $5,800 in year three, and $18,500 in year four. What annual rate of return has your investment

generated? Assume all cash flows are received at the end of each year and no terminal value.

9.53%

8.46%

7.15%

6.43%

3 _____What is the present value of an annuity due that pays you $5,000 per month for the next 25 years? Assume no terminal value and a discount rate of 5%.

$858,864

$855,300

$850,222

$846,315

4_____What is the effective rate of interest on a savings account that pays you 3% compounded monthly?

4.00%

3.36%

3.04%

3.00%