Reference no: EM133059806

All problems must be solved using the PV and FV functions in Excel please explain what formulas to do on excel so that I can practice myself.

1. If I deposit $8,000 in a bank account that pays interest of 1.5%, compounded annually, how much will I have in the account after 10 years?
2. If I deposit $8,000 in a bank account that pays simple interest of 1.5%, how much will I have in the account after 10 years?
3. How would you explain the difference in the answers to the foregoing two problems, given that both banks pay interest at the same rate? Be specific.
4. You graduate from Berkeley College and obtain a job paying an annual salary of $35,000.  You estimate that you will receive a 10% salary increase each year. If you receive those salary increases, how much will you be earning after 4 years?
5. You deposit $5,000 in a bank account today that pays 2% interest, compound annually.  You make no withdrawals from the account until 4 years have passed and then you withdraw all of the money that has accumulated in that account and deposit it into another bank that pays 3% interest compounded annually.  You leave your money in the second bank for an additional 3 years.  How much money will you have after the 7 years?