Question

you plan to open a savings account by depositing $1,000.00 in the bank today and continuing...

you plan to open a savings account by depositing $1,000.00 in the bank today and continuing to deposit the same amount every year for a total of 10 deposits. if the bank pays 3% interest rate, how much will you have in the bank 10 years from now?
- please write down the formually youd use to solve it manually but solve it using excel
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Merge & Center - 9 % , : Number Font Alignment fx =FV(0.03,10,1000,0) D E C Annual Deposit 1,000 10 0.03 1/Y FV $-11,463.88

FV = [PV = 0, N = 10, PMT = 1,000, I = 0.03]

FV = $11,463.88

Add a comment
Know the answer?
Add Answer to:
you plan to open a savings account by depositing $1,000.00 in the bank today and continuing...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Uriah Heep celebrated his 18th birthday by opening a savings account at the Thames River Bank and depositing 54,800...

    Uriah Heep celebrated his 18th birthday by opening a savings account at the Thames River Bank and depositing 54,800. He continued to deposit the same amount on every subsequent birthday will be was 26 years old. Aher depositing 54,600 on his 26th birthday Uriah decided to abandon his savings plan. He never saved again, but he left the accumulated savings in the bank account. The bank paid interest of 546 When Uriah tumed 65, he withdrew the money from the...

  • When you start your first full-time job, you plan to open a retirement savings account. Your...

    When you start your first full-time job, you plan to open a retirement savings account. Your goal is to retire 25 years from the day you start working. You will use a retirement investment account that pays 5.5% nominal interest, compounded annually, and you want to have exactly $400,000 in that account when you retire. You will make end of year deposits every year for the 25 years working, and you expect your income will increase 4% per year throughout...

  • You decide to deposit $50 in the bank today and to make 10 additional deposits every...

    You decide to deposit $50 in the bank today and to make 10 additional deposits every 6 months beginning 6 months from now, the first of which will be $50 and increasing $10 per deposit after that. A few minutes after making the last deposit, you decide to withdraw the all the money deposited. If the bank pays 8% nominal interest compounded semiannually, how much money will you receive? You decide to deposit $50 in the bank today and to...

  • How much would be in your savings account in eight years after depositing $240 today if...

    How much would be in your savings account in eight years after depositing $240 today if the bank pays 8 percent per year? (Do not d cales a Round your "rower to 2 decmai piace%)

  • 8-One year from now, you deposit $300 in a savings account. You deposit $1,800 the next...

    8-One year from now, you deposit $300 in a savings account. You deposit $1,800 the next year. Then you wait two more years (until 4 years from now) and deposit $1,000. If your account always earns 6% annual interest and you make no withdrawals, how much will be in the account 11 years from now? 9-You deposit $5000 for 5 years at 4% annual interest. In 5 years, you add $15,000 to your account, but the rate on your account...

  • Amy’s grandparents have been depositing $120 into a savings account every month since she is born....

    Amy’s grandparents have been depositing $120 into a savings account every month since she is born. The 1st payment was made the day Amy was born. The account pays 6% interest annually. Immediately after Amy’s grandparents make the monthly deposit on her 18th birthday, Amy went to the bank to check her bank balance. What should be Amy’s bank balance?

  • please help with number 3! show work with excel Note: The data for these exercises can...

    please help with number 3! show work with excel Note: The data for these exercises can be found on the Benninga, Principles of Finance with Excel, Third Edition companion website (www.oup.com/us/Benninga). 1. (FV single cash flow) You just put $600 in the bank, and you intend to leave it there for 10 years. If the bank pays you 15% interest per year, how much will you have at the end of 10 years? 2. (FV single cash flow, finding r)...

  • You plan to make two deposits to your bank account - one deposit today for $X...

    You plan to make two deposits to your bank account - one deposit today for $X and one deposit in four years for $3X. You would like to withdraw $20,000 from this bank account in 6 years, and another $10,000 in 12 years. You can earn an effective rate of 5% per year. What is $X? (8 points) You want to have enough money in the bank to pay for your daughter’s education when the time comes. You expect to...

  • You decide to deposit $100 in the bank today and to make 10 additional deposits every...

    You decide to deposit $100 in the bank today and to make 10 additional deposits every 6 months beginning 6 months from now, the first of which will be $75 and increasing $25 per deposit after that. A few minutes after making the last deposit, you decide to withdraw all the money deposited. If the bank pays 6% nominal interest compounded semiannually, how much money will you receive?

  • Assume that you wish to make annual deposits into a savings account. The interest rate offered...

    Assume that you wish to make annual deposits into a savings account. The interest rate offered by the bank is 13%, and you plan to save for the next 13 years. If your goal is for the present value of your savings to be equal to $3746, how much money must you deposit every year?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT