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.

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)
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
Active Questions
  • In a survey, 11 people were asked how much they spent on their child's last birthday...
    asked 11 minutes ago
  • Discussion 7.1: Practice Critical Thinking How well do you understand this material? Reading the material is...
    asked 12 minutes ago
  • A credit score measures a​ person's creditworthiness. Assume the average credit score for Americans is 709....
    asked 15 minutes ago
  • A Database Administrator (DBA) is play both managerial role and technical role in a modern organization;...
    asked 30 minutes ago
  • The Federal Election Commission collects information about campaign contributions and disbursements for candidates and political committees...
    asked 30 minutes ago
  • In the week before and the week after a​ holiday, there were 10,000 total​ deaths, and...
    asked 33 minutes ago
  • 1. Identify the vertex of the quadratic equation y=2x2+8x-10. using the formula 2. Write the equation...
    asked 49 minutes ago
  • How well do you understand this material? Reading the material is separate than understanding it; further,...
    asked 51 minutes ago
  • Analyze the behavior of capacitors under steady state direct current and high frequency AC current (500...
    asked 51 minutes ago
  • Traffic on the eastbound approach of a signalized intersection is traveling at 48 km/h, with a...
    asked 1 hour ago
  • Students in a chemistry class convince their teacher to use the following "group grading" scenario. Students...
    asked 1 hour ago
  • The letters of the word "REARRANGE" are randomly rearranged. What is the probability that this rearrangement...
    asked 1 hour ago