You plan to buy a new car in three years and begin depositing $250 per month into a savings account that earns 4.5% annual interest, compounded monthly. After three years of deposits, how much money is in the account? What would you need to enter in Excel to help you answer this question? O=FV(4.5/12%,3,-250) O=FV((4.5%/12),36,-250) O=FV(4.5%, 3..-250) O=FV(4.5/12,36,,250)

You plan to buy a new car in three years and begin depositing $250 per month into a savings account that earns 4.5% annual interest, compounded monthly. After three years of deposits, how much money is in the account? What would you need to enter in Excel to help you answer this question? O=FV(4.5/12%,3,-250) O=FV((4.5%/12),36,-250) O=FV(4.5%, 3..-250) O=FV(4.5/12,36,,250)

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter4: Managing Your Cash And Savings

Section: Chapter Questions

Problem 7FPE: Calculating interest earned and future value of savings account. If you put 6,000 in a savings...

See similar textbooks

Similar questions

You put $600 in the bank for 3 years at 15%. A. If Interest Is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the third year. B. Use the future value of $1 table In Appendix B and verify that your answer is correct.
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $2,500 over the next 4 years when the interest rate is 15%, how much do you need to deposit in the account? B. If you place $6,200 in a savings account, how much will you have at the end of 7 years with a 12% interest rate? C. You invest $8,000 per year for 10 years at 12% interest, how much will you have at the end of 10 years? D. You win the lottery and can either receive $750,000 as a lump sum or $50,000 per year for 20 years. Assuming you can earn 8% interest, which do you recommend and why?
You put $250 in the bank for S years at 12%. A. If interest is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the fifth year. B. Use the future value of $1 table in Appendix B and verity that your answer is correct.
Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.
Calculating interest earned and future value of savings account. If you put 6,000 in a savings account that pays interest at the rate of 3 percent, compounded annually, how much will you have in five years? (Hint: Use the future value formula.) How much interest will you earn during the five years? If you put 6,000 each year into a savings account that pays interest at the rate of 4 percent a year, how much would you have after five years?
Refer to the present value table information on the previous page. What amount should Brett have in his bank account today, before withdrawal, if he needs 2,000 each year for 4 years, with the first withdrawal to be made today and each subsequent withdrawal at 1-year intervals? (Brett is to have exactly a zero balance in his bank account after the fourth withdrawal.) a. 2,000 + (2,000 0.926) + (2,000 0. 857) + (2,000 0.794) b. 2,0000.7354 c. (2,000 0.926) + (2,000 0.857) + (2,000 0.794) + (2,000 0.735) d. 2,0000.9264
Suppose you want to have $600, 000 for retirement in 15 years. Your account earns 9% interest. Feel free to use the Online Basic Financial Calculator a) How much would you need to deposit in the account each month? $ b) How much interest will you earn? $
You put $250 in the bank for 5 years at 12% a. if interest is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the fifth year. b. use the future value of $1 table in the textbook to verify that your answer is correct. (https://cnx.org/contents/kg0cimBs@14.13:vq8rrTZQ@6/Time-Value-of-Money)
Starting next year, you will need $25,000 annually for 4 years to complete your education. (One year from today you will withdraw the first $25,000.) Your uncle deposits an amount today in a bank paying 4% annual Interest, which will provide the needed $25,000 payments. a. How large must the deposit be? Do not round Intermediate calculations. Round your answer to the nearest cent. $ b. How much will be in the account immediately after you make the first withdrawal? Do not round intermediate calculations. Round your answer to the nearest cent. $
Suppose you want to have $600,000 for retirement in 25 years. Your account earns 4% interest. How muc would you need to deposit in the account each month? Submit Question /course/showcalendar.php?cid=179278 Search
You want to be able to withdraw $50,000 each year for 30 years. Your account earns 6% interest. a) How much do you need in your account at the beginning? b) How much total money will you pull out of the account? c) How much of that money is interest? Question Help: Video