Question

In: Finance

You plan to open a bank account by depositing $500 today and end of each year...

You plan to open a bank account by depositing $500 today and end of each year for the next nine years (year 1, year 2, ……. year 9). If the interest rate is 2%, what will be your balance in ten years? show workings in excel file

Solutions

Expert Solution

Present Value of annuity = PMT * ((1-(1+r)^(-n)) / r)

= 500 * ((1-(1+0.02)^(-10)) / 0.02)

= $4,491.29 (Approximately)


Related Solutions

Today, you open a new savings account and plan to begin depositing equal amounts at the...
Today, you open a new savings account and plan to begin depositing equal amounts at the beginning of each year for 5 years, including the deposit you make today. There will be only these 5 deposits and no withdrawals made to your account. Assume the interest rate you will earn is 8%. If you want your account balance to be exactly $40,000 at the end of 5 years, what must be the amount of each deposit?
Today, you open a new savings account and plan to begin depositing equal amounts at the...
Today, you open a new savings account and plan to begin depositing equal amounts at the beginning of each year for 10 years, including the deposit you make today. There will only be these 10 deposits and no withdrawals. Assume the interest rate you will earn is 3%. If you want your account balance to be exactly $15,000 at the end of 10 years, what must be the amount of each deposit?
Today, you open a new savings account and plan to begin depositing equal amounts at the...
Today, you open a new savings account and plan to begin depositing equal amounts at the beginning of each year for 9 years, including the deposit you make today. There will only be these 9 deposits and no withdrawals. Assume the interest rate you will earn is 4%. If you want your account balance to be exactly $20,000 at the end of 9 years, what must be the amount of each deposit?
You start a savings account today by depositing $1,000 in an account. Each year you add...
You start a savings account today by depositing $1,000 in an account. Each year you add 3% to the amount you deposited in the previous year. You do this for 20 years (21 total payments including the payment today.) The interest rate is 6%. How much will you have in the bank at the end of year 20.
5. You plan to deposit $500 into a bank account now (year 0), $300 in year...
5. You plan to deposit $500 into a bank account now (year 0), $300 in year 2, and $1000 in year 4. How much money will be in your account in year 7, if the annual interest rate is 5%? a. 2,345 b. 2,244 c. 2,175 d. 2,500 6. If the interest rate is 6.5%, calculate the present value of $5000 paid annually over the next 25 years a. 69,899 b. 65,798 c. 60,898 d. 60,989
You plan to make 15 deposits at the end of each year in an account that...
You plan to make 15 deposits at the end of each year in an account that pays 6% compound interest annually. If the first deposit is $ 1,000 and subsequently 500 are added each year to the amount deposited the previous year (1000, 1500, ...), the amount of the account at the end of the 15 years will be close to: a. $71,550 b. $97,777 c. $92,242 d. $87,021 e.No correct answer is provided.
Suppose you deposit $500 in an account at the end of this year, $400 at the...
Suppose you deposit $500 in an account at the end of this year, $400 at the end of next yer, and $300 at the end of the following year. The interest rate is 7.5%. How much will be in the account immediately after the third deposit is made? How much will be in the account at the end of three years if the deposits are made at the beginning of each year? Please show work and proper equation to use.
Suppose you were considering depositing money in a savings account at two different banks. Each bank...
Suppose you were considering depositing money in a savings account at two different banks. Each bank will pay 5% interest. However, bank A compounds annually and bank B compounds semiannually. Provide a detailed explanation with your investment amount, period of time and your resulting investment. In addition, provide details on how you calculated using Excel (with formula) or financial calculator inputs. Which bank would you choose and why? Be sure to cite your source(s).
You are considering an investment by depositing $25,000 to an account today and making monthly contributions...
You are considering an investment by depositing $25,000 to an account today and making monthly contributions of $300 into the account for 10 years. If you want to have $100,000 in the account after 10 years, what annual interest rate must you earn from the account? If you go ahead with the investment and decide to increase the monthly contribution to $400 after 5 years (deposit $25,000 today, $300 monthly for the first 5 years), how much will you have...
You are considering an investment by depositing $25,000 to an account today and making monthly contributions...
You are considering an investment by depositing $25,000 to an account today and making monthly contributions of $300 into the account for 10 years. If you want to have $100,000 in the account after 10 years, what annual interest rate must you earn from the account? If you go ahead with the investment and decide to increase the monthly contribution to $400 after 5 years (deposit $25,000 today, $300 monthly for the first 5 years), how much will you have...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT