Suppose you want to buy a home after 3 years and you will need $15,000 for that. You open a savings account and deposit a lump sum amount of $2,000. You want to make a monthly payment at an interest rate of 4.5%. What should be the constant monthly payment you should make to reach the goal of $15,000 after 3 years? Explain in excel

Suppose you want to buy a home after 3 years and you will need $15,000 for that. You open a savings account and deposit a lump sum amount of $2,000. You want to make a monthly payment at an interest rate of 4.5%. What should be the constant monthly payment you should make to reach the goal of $15,000 after 3 years? Explain in excel

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

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?
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?
If you are saving the same amount each month in order to buy a new sports car when the new models are released, which of the following will help you determine the savings needed? A. future value of one dollar ($1) B. present value of one dollar ($1) C. future value of an ordinary annuity D. present value of an ordinary annuity
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?
Suppose you decide to wait 5 years to save up before buying the house. You are able to put a down payment of $30,000 on the house, so that you only need to borrow $170,000 from the bank. Assume the interest rate is still the same, but you are now in a better financial position, and you can pay off the loan in 240 equal monthly payments. Answer the following questions about this loan. After making 240 monthly payments, how much of what you paid the bank was interest? $ . ROUND TO THE NEAREST CENT. THANKS APPRECIATE THE HELP!!!
Pls help on ur own.Suppose you take out a car loan that requires you to pay $8,000 now, $5,000 at the end of year 1, and $7,000 at the end of year 2. The interest rate is 5% now and increases to 9% in the next year. What is the present value of the payments?
Suppose you invest $130 a month for 5 years into an account earning 8% compounded monthly. After 5 years, you leave the money, without making additional deposits, in the account for another 29 years. How much will younhave in the end? Suppose instead you didn't invest anything for the first 5 years, then deposited $130 a month for 29 years into an account earning 8% compounded monthly. How much will you have in the end? Question Help: D Video Submit Question
Suppose you would like to save enough money to pay cash for your next car. The goal to save an extra $26,000 over the next 6 years. What amount of quarterly payments must you make into an account that earns 5.5% interest in order to reach your goal?
You want to have $35,000 in cash to buy a car 3 years from today. You expect to earn 3.6 percent, compounded annually, on your savings. How much do you need to deposit today if this is the only money you save for this purpose? Can the excel and calculator solution be provided?
You have $100 and a bank is offering 5% interest on deposits. If you deposit the money in the bank, how much will you have in one year? How do you do calculate this on a calculator. This would be a future value problem correct?
Assume that you plan to buy an apartment 5 years from now and you need to save for a down payment. You plan to save RM2,500 per year with the first deposit made immediately (at the beginning of the year), and you will deposit the funds in a bank account that pays 4% interest. How much will you have after 5 years? How much will you have after 5 years if you make the deposits at the end of each year? Even if the bank provided the same interest rate, which option (at beginning of each year or at end of each year) would give a higher total savings after 5 years? Explain.
Solve the following problems. Round your results to the nearest cent as needed. You need a loan to purchase a car. After the down payment, you need to borrow $24, 200. If a bank offers you a loan at 6.9% for 6 years, how much will your monthly payment be? How much will you pay in interest? Your monthly payment will be $ dollars You will pay a total of $ dollars TVM Calculator in interest