Mike and Beth would like to have an opportunity to buy a home in the next five years. They currently have $15,000 saved toward this goal in an investment account that is paying 7% annual interest, compounded on a monthly basis. In addition to this, Mike and Beth add an additional $250 every month at the end of the month. Given this information, what amount can you tell Mike and Beth that they will have for a down payment when they are ready to purchase their home? $45,733.58 $39,162.60 $21,398.45 $37,465.87

Mike and Beth would like to have an opportunity to buy a home in the next five years. They currently have $15,000 saved toward this goal in an investment account that is paying 7% annual interest, compounded on a monthly basis. In addition to this, Mike and Beth add an additional $250 every month at the end of the month. Given this information, what amount can you tell Mike and Beth that they will have for a down payment when they are ready to purchase their home? $45,733.58 $39,162.60 $21,398.45 $37,465.87

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 6E

See similar textbooks

Similar questions

Frances plans to save money for a down payment on a house using an investment account that pays an interest rate of 5.3% per year. She wants to have $425, 000 available five years from today. Frances intends to deposit an amount today and at the end of each of the next five years into her investment account (i. e. she will make a total of six deposits, all of the same amount). How much will each of these deposits be? (Enter your answer to two decimal places)
Your best friend Mary is in discussion with you about saving for her retirement. You are to advise her on how much she should deposit annually to meet her retirement needs. Assume that she will deposit a fixed annual amount for the next 20 years into a retirement savings account, starting one year from now. Mary has a daughter who will be attending college and plans to make 5 withdrawals (starting one year after making her final deposit into the retirement account) of $35,000 each to pay for her annual tuition for the following 5 years. Commercial Banks will be paying 6 percent on such retirement accounts for the next 25 years. Kindly advise Mary on how much she should place in the account annually to cover her retirement needs.
Julieta and Eric are purchasing a home. They wish to save money for 12 years and purchase a house that has a value of $170,000 with cash. If they deposit money into an account paying 7 % interest, compounded monthly, how much do they need to deposit each month in order to make the purchase? Round your answer to the nearest cent, if necessary.
After paying for their children's college education, Amy and Randy have $15,000 in annual savings. They deposit $15,000 at the end of each year into a retirement account that pays 7.5% interest per year compounded annually. How much money will they have in that account at the end of the 15th year? (answer in whole number)
Alexis and Will are purchasing a home. They wish to save money for 10 years and purchase a house that has a value of $180,000 with cash. If they deposit money into an account paying 12% interest, how much do they need to deposit each month in order to make the purchase?
Garrett and Erin are borrowing $170,000 to purchase a new home. They have been approved for a 30-year loan with an interest rate of 5.75%. What will be their monthly payment?
Chen's family is saving for a home renovation that they would like to pay for with cash. They would like to begin the renovations at the end of 12 years. At the end of each year, the family deposits money into an account that earns 5% compounded annually. At the end of year 1, they save $10,000. They plan to increase the amount that they save by a constant amount, X. What will be the correct value of X, assuming their renovation costs $150,000?
Michael is updating his estate plan for himself and his family. He would like to provide an income of $3000 every month starting 10.5 years from now and continuing for the next 20 years. He has started his account with an initial deposit of $10,000 and he knows his life insurance, maturing in 5 years, will have a cash value of $150,000. To make up the difference, Michael has decided to make monthly deposits in the account. How much should eachdeposit be if all interest is computed at 6% compounded monthly? Note: Cannot use Excel/Spreadsheet.
Michael is updating his estate plan for himself and his family. He would like to provide an income of $3000 every month starting 10.5 years from now and continuing for the next 20 years. He has started his account with an initial deposit of $10,000 and he knows his life insurance, maturing in five years, will have a cash value of $150,000. To make up the difference , Michael has decided to make monthly deposits in the account. How much should each deposit be if all interest is computed at 6% compounded monthly ?
Jenny and Leo plan to purchase a new house and the couple is able to obtain a 25-year 3.6% (per annum, compounded monthly) amortised loan but they must put down 20% deposit. The loan requires end-of-month repayments of $2,500 where the first payment is due a month after the loan is taken. Assuming that the couple has enough savings for the down payment, what is the cost of the house that they want to purchase? a. 494,068.50 b. 2,470,342.49 c. 750,000 Od. 617,585.62
Grandparents plan to open an account on their grandchild's birthday and contribute each month until she goes to college. How much must they contribute at the beginning of each month in an investment that pays 5%, compounded monthly, if they want the balance to be $200,000 at the end of 18 years? Solve the problem. (Round your answer to the nearest cent.)
Answer the following questions. Show your complete solution. 1. Aylene is preparing for an income fund for her retirement. She wants to receive 15,000 pesos quarterly for the next 25 years starting 1 month from now. The income fund pays 10.5% compounded monthly. How much Aylene deposit now to pay for the annuity? 2. Cheska is saving for her dream cellphone. She deposits 2,000 pesos at the end of each month that earns 5% per year compounded semi-annually. Find the amount in the account after 1 1⁄2 years. 3. Janine wants to but a lot which cost 1 million pesos. She plans to give a down payment of 20% of the cost, and the rest will be paid by financing at monthly interest rate of 2% for 10 years in equal monthly installments. What will be the monthly payment? 4. Christopher wants to have 50,000 pesos in 4 years by saving equal regular payments. He can make a deposit at the end of each month in account that earns 8.5% per year compounded quarterly. How much must he deposit to achieve his…