Question

Solve the following questions by using Excel formula. Show me your data

1-      If you deposit $20,000 in a bank account that pays 15% interest annually, how much will be in your account after 6 years?

2-      If you are planning to invest your money today in a secuirty that pay you $5,000,000 in 15 years with rate of return on your investment of 10% annually. How much you should invest?

3-      What's the future value of 7%, 7-year ordinary annuity that pays $500 each year? If this was annuity due, what would its future value be?

4-      You borrow $85,000 from a bank, the annual loan payments are $8,273.59 for 15 years. What interest are you being charged?

5-      Your father asked you to begin a habit of saving money early in your life. He suggested that you put $6 a day into an envelope. Your grandfather further suggested that you take that money at the end of each year ( after 365 days) and invest it in an online brokerage mutual fund account that has an annual expected return of 9%%.

Today you are 18 years old. If you start following your father’s advice today, and continue saving in this way for the rest of your life, how much do you expect to have in the brokerage account when you are 62 years old

Find the present value of the following cash flow streams at 8% compounded annually.

6- You have a chance to invest $3,615.14 in a fund that pays fixed payment at the beginning of each period for 4 years. You could earn 6% on your money compounded semiannually. How much you expect to receive at the beginning of each period for the annuity?

Answer 1

1.
If you deposit $20,000 in a bank account that pays 15% interest annually, how much will be in your account after 6 years?
=FV(15%,6,0,-20000)=46261.2153125

2.
If you are planning to invest your money today in a secuirty that pay you $5,000,000 in 15 years with rate of return on your investment of 10% annually. How much you should invest?
=PV(10%,15,0,-5000000)=1196960.24684582

3.
What's the future value of 7%, 7-year ordinary annuity that pays $500 each year?
Ordinary annuity=FV(7%,7,-500)=4327.0105462745

If this was annuity due, what would its future value be?
Annuity due=FV(7%,7,-500,0,1)=4629.90128451372

4.
You borrow $85,000 from a bank, the annual loan payments are $8,273.59 for 15 years. What interest are you being charged?
=RATE(15,-8273.59,85000)=0.0515225904312506

5.
Today you are 18 years old. If you start following your father’s advice today, and continue saving in this way for the rest of your life, how much do you expect to have in the brokerage account when you are 62 years old
=FV(9%,44,-6*365)=1054532.68673843

6.
You have a chance to invest $3,615.14 in a fund that pays fixed payment at the beginning of each period for 4 years. You could earn 6% on your money compounded semiannually. How much you expect to receive at the beginning of each period for the annuity?
=PMT(6%/2,2*4,-3615.14,0,1)
=499.999796