Question

In: Finance

You start a savings account today by depositing $1,000 in an account. Each year you add...

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

Solutions

Expert Solution

You started in saving account from today by depositng $1000 each year. Each year your deposit will increase by 3% per annum and you will deposit a total of 21 paymnets in 20 years including the one today.

Since you make 21 payments in 20 years, we can seperate them by calaculating Future value of 1st payment today and then future value of last 20 payments.

- Future Value in 20 years of 1st payment today:-

Future Value = Payment*(1+r)^n

Where, Payment = $1,000

r = Periodic Interest rate = 6%

n= no of periods = 20

Future Value = $1,000*(1+0.06)^20

Future Value = $1000*3.20713547221

Future Value in 20 years of 1st payment made today= $3207.14

Now, the second paymnet will increase by 3%

Second payment = $1000*(1+3%) = $1030

Calculating the Future value at the end of year 20 of last 20 paymnets using FV of growing annuity formula:-

Where, C= Second payments = $1030

r = Periodic Interest rate = 6%

g = growth rate of payments = 3%

n= no of periods = 20

Future Value = $48,101.83

So, Total Future Value of all 21 payments at the end of 20 years = $3207.14 + $48,101.83

= $51,308.97

So, amount you will have at bank at the end of 20 years is $51,308.97

If you need any clarification, you can ask in comments.     

If you like my answer, then please up-vote as it will be motivating     


Related Solutions

John starts a savings account by depositing $1,000 today and thenincreases the deposit by $50...
John starts a savings account by depositing $1,000 today and then increases the deposit by $50 each year until Year 20. If the bank pays an interest of 12% per year compounded yearly, what is the account balance at the end of 25 years?
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 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
You have an initial investment today of $10,000. Each year you add to the account 2.6%...
You have an initial investment today of $10,000. Each year you add to the account 2.6% more than the previous year. If the interest rate is 5.3% what is the future value of this income stream at the end of 25 years?
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).
Suppose you start saving for retirement by depositing $4,000 EVERY YEAR into your retirement account. If...
Suppose you start saving for retirement by depositing $4,000 EVERY YEAR into your retirement account. If your annual return is 8%, how much will you have in 45 years? How much would you have if all deposits were made on the FIRST of the year (as opposed to the last day of the year)? (please solve by hand and not excel)
Please show cash flow diagram and steps a) Today you deposited $1,000 in a savings account...
Please show cash flow diagram and steps a) Today you deposited $1,000 in a savings account paying 5% annual interest. How much should you have at the end of three years? b) You are paying into a mutual fund that earns 6%. If the payments are $10,000 per year, how much will be in the funds in 15 years? c) Your company is required to pay into a sinking fund each year in order to replace an industrial equipment costing...
Suppose you open today (year 0) a savings account with $5,000; the account earns an interest...
Suppose you open today (year 0) a savings account with $5,000; the account earns an interest of 3% APR annually. At the end of year 2 you deposit an additional $5,000 in the savings account, and then at the end of year 7 you deposit another $5,000 in the account. There is a total of 3 deposits made so far. If you did not make any withdrawals or additional deposits, then approximately what is the balance (FV) in the account...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT