Question

Dave makes 3 deposits of $9000 to his saving account over 8 years. The first deposit...

Dave makes 3 deposits of $9000 to his saving account over 8 years. The first deposit happens at Year 0, the second in 3 years, and the final deposit 1 year after that. For the first 3 years the effective yearly rate is 6%. For the 1 year after that, the rate is 11%. For remaining years, the rate is only 9%. How much is at the end if the 8 years?

Can you please use excel and show formulas.
Business   Economics   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Using Excel

First Deposit at EOY 0 9000
Second Deposit at EOY 3 9000
Third Deposit at EOY 4 9000
interest rate for 3 yr 6%
interest rate for 4th yr 11%
interest rate from 5th to 8th yr 9%
Value of deposit at EOY 3 19,719.14
Value of deposit at EOY 4 30,888.25
Value of deposit at EOY 8 43,601.29

Showing formula in excel

First Deposit at EOY 0 9000
Second Deposit at EOY 3 9000
Third Deposit at EOY 4 9000
interest rate for 3 yr 0.06
interest rate for 4th yr 0.11
interest rate from 5th to 8th yr 0.09
Value of deposit at EOY 3 =FV(C5,3,,-C2)+C3
Value of deposit at EOY 4 =FV(C6,1,,-C8)+C4
Value of deposit at EOY 8 =FV(C7,4,,-C9)
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The current account balance of Mr. A’s saving account is $45000. He makes a deposit at...
The current account balance of Mr. A’s saving account is $45000. He makes a deposit at the end of every month. You are given that • The amount of the first deposit, which is made one month after today, is ? and the amount is increased by (100?)% every month afterward. That is, the amount of the second deposit is ?(1+?), the amount of the third deposit is ?(1+?)2, and so on. • The saving account earns interest at a...
Betty deposits $5,000 now and deposits $3,000 after 1 year and deposits $2,000 after 2 years....
Betty deposits $5,000 now and deposits $3,000 after 1 year and deposits $2,000 after 2 years. 3 years after the initial deposit her account balance is $12,713.74. Bob deposits $8,000 now and withdraws $2,500 after 1 year and deposits $1,000 after 2 years. 3 years after his initial deposit his account balance is $8,895.17. Bertha deposits $6,000 now and withdraws $1,500 after 1 year and withdraws $3,000 after 2 years. 3 years after her initial deposit her account balance is...
Karen makes deposits of X at the beginning of each year for 10 years. She uses...
Karen makes deposits of X at the beginning of each year for 10 years. She uses the funds in her account to purchase an annuity with 10 payments of 70 starting six years after the final deposit of X. The annual effective interest rate is 8%. Calculate X.
An annual deposits of A1=$1,900 in a saving account is made for 6 years starting years...
An annual deposits of A1=$1,900 in a saving account is made for 6 years starting years 2. In year 8, a one- time withdrawal of $3,400 is made. In year 12, a one-time deposit of $2,200 is made. Then another series of annual deposits of A2 for 7 years started in year 14, increasing by $160 every year. If a one-time withdrawal of $1,100 was made in year 21 and the present worth of the whole amounts of deposits and...
Q5) Selima deposits $5000 ( t = 0 years) in an account paying r(2) = 3.00%.At...
Q5) Selima deposits $5000 ( t = 0 years) in an account paying r(2) = 3.00%.At the end of 4 years (t = 4 years) she adds another $9000 to her account and the interest rate changes to r(2) = X%. After another 3 years ( t = 7 years) she adds another $7000 to her account and the interest changes to r(2) = 3.00%. At the end of 11 years, she has $27567.44 in her account. a) How much...
A couple have a 3-year-old child; they decided to make annual deposits into a savings account...
A couple have a 3-year-old child; they decided to make annual deposits into a savings account to fund his 4-year university education. With the first deposit being made on his fourth birthday and the last deposit being made on his 15th birthday. Then, starting on his 18th birthday, 4 withdrawals are required, starting at $3000 and increasing at a rate of 11%. If the effective annual interest rate is 6% during the whole period of time, what are the annual...
Bob deposits the amount of $105 in his bank account today, and plans to deposit the...
Bob deposits the amount of $105 in his bank account today, and plans to deposit the amount of $175 in the same account one year from today, and finally plans to deposit the amount of $225 in the same account two years from now. If the interest rate is 6.95%, how much will Bob have accumulated in his account three years from today?
(1) A couple have a 3-year-old child; they decided to make annual deposits into a savings...
(1) A couple have a 3-year-old child; they decided to make annual deposits into a savings account to fund his 4-year university education. With the first deposit being made on his fourth birthday and the last deposit being made on his 15th birthday. Then, starting on his 18th birthday, 4 withdrawals are required, starting at $4000 and increasing at a rate of 11%. If the effective annual interest rate is 25% during the whole period of time, what are the...
Katie makes deposits of $500.00 at the end of each month for 5 years into an...
Katie makes deposits of $500.00 at the end of each month for 5 years into an account earning 9.5% annually, then lets the money sit in the account for another 8 years after the last deposit. Find Katie'S balance after this 13 year period.
You are interested in saving money for your first house.  Your plan is to make regular deposits...
You are interested in saving money for your first house.  Your plan is to make regular deposits into a brokerage account which will earn 14 percent. Your first deposit of $5,000 will be made today.  You also plan to make four additional deposits at the beginning of each of the next four years.  Your plan is to increase your deposits by 10 percent a year.  (That is, you plan to deposit $5,500 at t = 1, and $6,050 at t = 2, etc.)  How much...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT