Question

Charlene is going to save her $5,000 year-end bonus, putting the money in a CD offering...

Charlene is going to save her $5,000 year-end bonus, putting the money in a CD offering an APR of 4.50% with quarterly compounding and 4 years to maturity. How much money will she have when the CD matures?

Round your answer to the nearest penny. For example, $2,371.243 should be entered as 2371.24

Homework Answers

Answer #1

Ans:- we will first find the EAR (Effective annual rate) and then we will use the FV function of excel to find the Future Value.

EAR=(1+r/m)^m-1, where r is the annual rate, and m is the number of times compounding.

For FV, Rate=4.58% (EAR), Nper=4, Pmt=0 PV=-5000

Therefore, the FV at the end of year 4 will be $5980. (approx).

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Ansh plans to save for her retirement savings at the end of each quarter for 11...
Ansh plans to save for her retirement savings at the end of each quarter for 11 years. The first investment is $2500 and she plans to increase the investment amount by 0.5% per quarter thereafter. Assume her investments can earn 9% compounded quarterly. Round final answers to the nearest cent. a) How much money will Ansh have at the end of 11years? b) What will be the investment amount of her last savings contribution?
Doris plans to save $5,000 per year for the next 35 years. Her money will be...
Doris plans to save $5,000 per year for the next 35 years. Her money will be deposited in a stock market index fund that has a 0.5% annual management fee. If this fund earns 6% per year, how much will Doris save by investing in this fund instead of an actively managed mutual fund that has a 1% annual fee? Compute your answer as a future amount at the end of year 35.
Doris plans to save $5,000 per year for the next 35 years. Her money will be...
Doris plans to save $5,000 per year for the next 35 years. Her money will be deposited in a stock market index fund that has a 0.5% annual management fee. If this fund earns 6% per year, how much will Doris save by investing in this fund instead of an actively managed mutual fund that has a 1% annual fee? Compute your answer as a future amount at the end of year 35.
Eva will put $5,000 in her tax deferred retirement account each year beginning one year from...
Eva will put $5,000 in her tax deferred retirement account each year beginning one year from today and continuing for a total of 25 years. If her investment earns 8.00% per year, how much will she have at the end of 25 years? Round your answer to the nearest whole dollar. For example, $2,371.24 should be entered as 2,371.
Sofia just graduated from college and she is starting her new job today. Her new employer...
Sofia just graduated from college and she is starting her new job today. Her new employer gave her a $15,000 signing bonus that she will invest today. She plans to retire 50 years from today (i.e., at the end of year 50). Once she retires, she would like to be able to withdraw from her retirement account $180,000 at the end of each year, starting the year after she retires (i.e., year 51). She expects that her retirement will last...
Sofia just graduated from college and she is starting her new job today. Her new employer...
Sofia just graduated from college and she is starting her new job today. Her new employer gave her a $15,000 signing bonus that she will invest today. She plans to retire 50 years from today (i.e., at the end of year 50). Once she retires, she would like to be able to withdraw from her retirement account $180,000 at the end of each year, starting the year after she retires (i.e., year 51). She expects that her retirement will last...
You are a young personal financial adviser. Molly, one of your clients approached you for a...
You are a young personal financial adviser. Molly, one of your clients approached you for a consultation about her plan to save aside $450,000 for her child’s higher education in the United States 15 years from now. Molly has a saving of $120,000 and is considering different alternative options: Investment 1: Investing that $120,000 in savings account for 15 years. There are two banks for her choice. Bank A pays a rate of return of 8.5% annually, compounding semi-annually. Bank...
1. Suppose you are the executor of your Aunt's estate, and she desires to provide her...
1. Suppose you are the executor of your Aunt's estate, and she desires to provide her daughter with $25,000 at the end of each year for the next 32 years. If the bank provides a guaranteed account which earns 5.1% per year simple interest, how much money should be deposited into this guaranteed account to fully fund this request? (Answer to the nearest dollar) 2. If you deposit $2,000 at the end of each year into an IRA account that...
You are a young personal financial adviser. Molly, one of your clients approached you for a...
You are a young personal financial adviser. Molly, one of your clients approached you for a consultation about her plan to save aside $450,000 for her child’s higher education in the United States 15 years from now. Molly has a saving of $120,000 and is considering different alternative options: Investment 1: Investing that $120,000 in savings account for 15 years. There are two banks for her choice. Bank A pays a rate of return of 8.5% annually, compounding semi-annually. Bank...
Samantha plans to invest some money so that she has $4,700 at the end of three...
Samantha plans to invest some money so that she has $4,700 at the end of three years. How much should she invest today given the following choices? (Use 365 days for calculation. If you solve this problem with algebra round intermediate calculations to 4 decimal places, in all cases round your final answer to the nearest penny.) a. 4.2 percent compounded daily. Amount required to be invested $ b. 4.9 percent compounded monthly. Amount required to be invested $ c....