Michael is updating his estate plan for himself and his family. He would like to provide an income of $ 3000 every month starting 10 1 2 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 percent compounded monthly ?

Michael is updating his estate plan for himself and his family. He would like to provide an income of $ 3000 every month starting 10 1 2 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 percent compounded monthly ?

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

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 ?
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.
Mr. Lau 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, Mr. Lau has decided to make monthly deposits in the account. How much should each deposit be if all interest is computed at 6 percent compounded monthly? Functions: Ordinary Annuities: Sinking Funds and Ordinary annuities: Amortization Note: Cannot use Excel/Spreadsheet
Donald 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, Donald has decided to make monthly deposits in the account. How much should each deposit be if all interest is computed at 6 percent compounded monthly?
Michael is updating his estate plan for himself and his family. He would like to provide an income of $ 3000 every month starting 10 1/2 (Ten and a half) 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 percent compounded monthly?
Mr. White is updating his estate plan for himself and his family. He would like to provide an income of $3000 every month starting 10 1/2 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 , Mr. White has decided to make monthly deposits in the account. How much should each deposit be if all interest is computed at 6% compounded monthly?
Your best friend Sam is in discussion with you about saving for his retirement. You are to advise him on how much he should deposit annually to meet his retirement needs. Assume that he will deposit a fixed annual amount for the next 20 years into a retirement savings account, starting one year from now. Sam has a son who will be attending college and plans to make 5 withdrawals (starting one year after making his final deposit into the retirement account) of $35,500 to pay for his 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 Sam on how much he should place in the account annually to cover his retirement needs. (Answer rounded to 2 decimal dollar)
Your best friend Sam is in discussion with you about saving for his retirement. You are to advisehim on how much he should deposit annually to meet his retirement needs. Assume that he willdeposit a fixed annual amount for the next 20 years into a retirement savings account, startingone year from now. Sam has a son who will be attending college and plans to make 5 withdrawals(starting one year after making his final deposit into the retirement account) of $35,000 each topay for his annual tuition for the following 5 years. Commercial Banks will be paying 6 percenton such retirement accounts for the next 25 years. Kindly advise Sam on how much he shouldplace in the account annually to cover his retirement needs.
Your best friend Samis in discussion with you about saving for his retirement.You areto advise him on how much he should deposit annually to meet his retirement needs. Assume that he will deposit a fixed annual amount for the next 20 years into a retirement savings account, starting one year from now. Sam has a son who will be attendingcollege and plans to make 5 withdrawals(starting one year after making his final deposit into the retirement account)of$35,000eachto pay for his annual tuition forthe following 5 years. Commercial Banks will be paying 6 percent on such retirement accountsfor the next 25 years. KindlyadviseSam on how much he should place in the account annually to cover his retirement needs.
Mark is in discussion with you about saving for his retirement. You are to advise him on how much he should deposit annually to meet his retirement needs. Assume that he will deposit a fixed annual amount for the next 20 years into a retirement savings account, starting one year from now. Mark has a son who will be attending college and plans to make 5 withdrawals (starting one year after making his final deposit into the retirement account) of $35,000 each to pay for his annual tuition for the following 5 years. Commercial Banks will be paying 6 percent on such retirement accounts for the next 25 years. How much should Mark place in the account annually to cover his retirement needs.
Justin is saving for his retirement 21 years from now by setting up a savings plan. He has set up a savings plan wherein he will deposit $104.00 at the end of every six months for the next 11 years. Interest is 7% compounded semi-annually. (a) How much money will be in his account on the date of his retirement? (b) How much will Justin contribute? (c) How much will be interest?
Cameron is saving for his retirement 22 years from now by setting up a savings plan. He has set up a savings plan wherein he will deposit $97.00 at the end of every three months for the next 12 years. Interest is 10% compounded quarterly. (a) How much money will be in his account on the date of his retirement? (b) How much will Cameron contribute? (c) How much will be interest? (a) The future value will be $ (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.)