How much you should invest

Assignment Help Accounting Basics

Reference no: EM132125172

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.

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

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?

Information related to above question is enclosed below:

Attachment:- FM-Assignment1onEXCEL.rar

Reference no: EM132125172

Questions Cloud

Define professional skepticism in detail : Sarbanes-Oxley prohibits professional service firms from performing services for audit client in which the auditors may find themselves making management.

Prepare the general ledger journal entries : Prepare the General Ledger journal entries for the General Fund for the Village of Bath for the year ended December 31, 2017.

Interest payments are tax deductible : Interest payments are tax deductible and thus it is in the interests of the shareholders that the company's management implement

Post your evaluation of the impact of organizational stress : Post your evaluation of the impact of organizational stress on the health of an organization.

How much you should invest : 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.

Bond prices when interest rates : What do you think happened to bond prices when interest rates went down in the US after the GFC?

Develop a leadership and strategy plan for health problem : Final Project - Leadership and Strategy Plan. select a pressing health problem affecting a community and develop a leadership and strategy plan for problem

Summarize your idea of a good leader : Analyze which communication style and leadership style are most suitable for your workplace and culture. Discuss what areas can be improved.

Consumption and materialism impact the physical environment : Describe how consumption and materialism impact the physical environment? Give a few examples.

User Account

All Pages