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