Assignment: TVM
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 val ue 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 ch arged?
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 o f 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 ye ars old 6-
6- Find the present value of the following cash flow streams at 8% compounded an nually.
7- 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?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.