Use spreadsheet for the ease in computations. Enter values and formulas in the spreadsheet as shown in the image below.
The obtained result is provided below.
Page 1: Question 20 (1 point) David has a savings account with a 4,000 balance today....
Question 1 (0.2 points) David has a savings account with a 9,000 balance today. The account earns an annual percentage rate of interest of 1.50%, compounded monthly. David plans to make no other deposits or withdrawals. How many years will it take David's account balance to double? Your Answer: Answer
David has a savings account with a 8,000 balance today. The account earns an annual percentage rate of interest of 1.75%, compounded monthly. David plans to make no other deposits or withdrawals. How many years will it take David's account balance to double? Your Answer: Answer
Pei's savings account balance is $12,000 today. Pei opened the account exactly 7 years ago with a $10,000 deposit. Pei has made no other deposits or withdrawals. What annual interest rate (compounded annually) has the account earned? (Enter your answers as a decimal rounded to 4 decimal places, not a percentage. For example, enter 0.0843 instead of 8.43%)
Daniel plans to deposit $450 into a savings account at regular intervals of 3 months. He continues this for 5 years and then stops with the deposits. What is the value of the account after 10 years if the savings account earns interest at an annual interest rate of 5.5% compounded monthly Daniel plans to deposit $450 into a savings account at regular intervals of 3 months. He continues this for 5 years and then stops with the deposits. What...
Today you deposit 100$ today an account that earns 12% annual interest. If you do not make any additional deposits or withdrawals how long does it take to double your money ?
4- Beginning 1 month from today David B. will deposit each month $200 into an account paying 15 6% nominal interest. He will make a total of 240 deposits (20 years). After the last deposit the money in the account will begin to earn 4% interest compounded annually. After another 10 years David will begin to withdraw annual amounts for a total of 10 years. How much can be withdrawn each year if the account is to be depleted (zero...
Suppose you deposit 4859 today in a savings account that earns an annual interest rate of 4.53% which is compounded annually. Assuming no withdrawals, how much would you have at the end of 8 years?
$5,000 is deposited today into a bank account. The account earns 3.2% per annum compounded half yearly for the first 7 years, then 8.2% per annum compounded quarterly thereafter. Assuming no further deposits or withdrawals are made, (d) Calculate the account balance 10 years from today. A loan of $100,000 is made today. The borrower will make equal repayments of $3800.75 per month with the first payment being exactly one month from today. The interest being charged on this loan...
8-One year from now, you deposit $300 in a savings account. You deposit $1,800 the next year. Then you wait two more years (until 4 years from now) and deposit $1,000. If your account always earns 6% annual interest and you make no withdrawals, how much will be in the account 11 years from now? 9-You deposit $5000 for 5 years at 4% annual interest. In 5 years, you add $15,000 to your account, but the rate on your account...
$2,000 is deposited today into a bank account. The account earns 4.3% per annum compounded quarterly for the first 4 years, then 6.3% per annum compounded monthly thereafter. Assuming no further deposits or withdrawals are made, (a) Calculate the account balance six months from today. (b) Calculate the account balance 4 years from today. (c) Calculate the account balance 4.25 years from today. (d) Calculate the account balance 13 years from today.