You deposit $25,000 in a bank, which offers an annual 5% compound interest rate. Which of...

Question

Question

You deposit $25,000 in a bank, which offers an annual 5% compound interest rate. Which of the following excel functions shoul

Answer 1

Answer #1

Correct option: (b) FV(0.05,8,,25000) Reason: Since the money will be taken out after 8 years, we need to calculate Future Va

Answer 2

Similar Homework Help Questions

A bank offers the following certificates of deposit: Terms in years Annual nominal interest rate, compounded...

A bank offers the following certificates of deposit: Terms in years Annual nominal interest rate, compounded semi-annually 1 5% 2 6% 3 7% 4 8% The bank requires that interest accumulate at the certificate’s interest rate, and does not permit early withdrawal. The certificates mature at the end of the term. During the next six years, the bank will continue to offer these certificates of deposit. Jeff invests 1000 in the bank. Calculate the maximum amount...
If you deposit $1,067 per month into a savings account that pays an annual rate of...

If you deposit $1,067 per month into a savings account that pays an annual rate of 4.7 percent, compounded monthly, how much will you have in the account after 31 years? Show using Excel Functions. Nper Rate PV FV PMT
Answer in Excel If I deposit $8,000 in a bank account that pays interest of 1.5%,...

Answer 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....

bank offers annual rate 2.13% compounded quarterly for deposit at least $25,000. What is APY?

bank offers annual rate 2.13% compounded quarterly for deposit at least $25,000. What is APY?
You decide to deposit $50 in the bank today and to make 10 additional deposits every...

You decide to deposit $50 in the bank today and to make 10 additional deposits every 6 months beginning 6 months from now, the first of which will be $50 and increasing $10 per deposit after that. A few minutes after making the last deposit, you decide to withdraw the all the money deposited. If the bank pays 8% nominal interest compounded semiannually, how much money will you receive? You decide to deposit $50 in the bank today and to...
deposit today 25,000 value 10 years from today 50,000 r please help with nuimber 6, but...

deposit today 25,000 value 10 years from today 50,000 r please help with nuimber 6, but only in EXCEL CHAPTER 2 The Time Value of Money 47 5. (PV single cash flow) Your friend comes to you with a $2,000 post-dated check. The check is due 2 years from today. If the interest rate is 5%, what is the value of the check today? 6. (PV single cash flow, finding r) If you deposit $25,000 today, Union Bank offers to...

You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....

You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly. The loan will be repaid in 5 years with monthly payments. What is your monthly payment (calculated with the equations on the next page)? Compare your answer to that obtained with the built in function, PMT. Be sure to label all cells appropriately. (There is no need to create a monthly payment table, simply use the equations on the next page.) Loans: where: and,...
One of the new deposit construction of our competitor credit bank offers 12% annual nominal interest...

One of the new deposit construction of our competitor credit bank offers 12% annual nominal interest rate but pays all interest semi-annually. Our bank wants to create a deposit, which pays quarterly, and its effective rate of return is 1% higher than the rival's effective rate of return. What nominal interest rate should we determine for the new product？
You decide to deposit $100 in the bank today and to make 10 additional deposits every...

You decide to deposit $100 in the bank today and to make 10 additional deposits every 6 months beginning 6 months from now, the first of which will be $75 and increasing $25 per deposit after that. A few minutes after making the last deposit, you decide to withdraw all the money deposited. If the bank pays 6% nominal interest compounded semiannually, how much money will you receive?

You agree to deposit $500 at the beginning of each month into a bank account for...

You agree to deposit $500 at the beginning of each month into a bank account for the next 24 months. At the end of the 24th month, you will have $13,000 in your account. If the bank compounds interest monthly, what annual interest rate will you have earned? Note: Only use the formula listed and show the steps of how you reached the answer, I don't need to know just the answer, I'm trying to learn. Thank you. Don't use...