Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer the following problems in an Excel file. Please upload only one Excel file with all of your answers, including #3 (which requires an explanation
Answer the following problems in an Excel file. Please upload only one Excel file with all of your answers, including #3 (which requires an explanation rather than a calculation). All problems must be solved using the PV and FV functions in Excel.
- 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?
- 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?
- 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.
- You graduate from 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?
- 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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started