Janet Lopez wishes to establish a trust fund from which her son can withdraw $15,000 every six months for 21 years, when he reaches 25 years old. At the end of which time, he will receive the remaining money in the trust, which she would like to be $100,000. The trust will be invested at 7% per annum compounded semi-annually. How large should the trust be?

Janet Lopez wishes to establish a trust fund from which her son can withdraw $15,000 every six months for 21 years, when he reaches 25 years old. At the end of which time, he will receive the remaining money in the trust, which she would like to be $100,000. The trust will be invested at 7% per annum compounded semi-annually. How large should the trust be?

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

Your friend has a trust fund that will pay her the following amounts at the given interest rate for the given number of years. Calculate the current (present) value of your friends trust fund payments. For further instructions on present value in Excel, see Appendix C.
Abigail wishes to establish a trust fund from which her daughter can withdraw $6,000 every six months for 15 years, when she reaches 16 years old. At the end of which time, she will receive the remaining money in the trust, which she would like to be $25,000. The trust will be invested at 6% per annum compounded semi-annually. How large should the trust be?
Shauna wishes to establish a trust fund from which her son can withdraw $50,000 every six months for 18 years, when he reaches 30 years old. After 8 years, he will receive $500,000 for college. The trust will be invested at 8.7% per annum compounded semi-annually. How large should the trust be?
sonia which to establish a trust fund from which her son can withdrew $6000 every six months for 15 years , when he reach 16 years old.At the end of which time he will receive the remaining money in the trust,which you would like to be $25000. The trust will be invested at 6% per annum compounded semi-annual .How large should the trust be ?
1. Abbigail wish to establish a trust fund from which her daughter can withdraw $6,000 every six months for 15 years, when she reach 16 years old. At the end of which time she will receive the remaining money in the trust, which you would like to be $25,000. The trust will be invested at 6% per annum compounded semi-annually. How large should the trust be? 2. Dennis McDonald has just started working with the NCB as a sales representative and is just trying to catch up on having money for retirement. NCB offers him a pension plan with an annuity that is guaranteed to earn 11% interest compounded annually. She plans to work for 12 years before retiring and would then like to be able to draw an income of $110,000 per annum for 16 years. How much must be deposited per annum into his retirement fund to accomplish this? DO NOT USE EXCEL TO ANSWER DO NOT USE EXCEL SHOW ALL WORKINGS
Your grandparents would like to establish a trust fund that will pay you and your heirs $210,000 per year forever with the first payment 13 years from today. If the trust fund earns an annual return of 41 percent, how much must your grandparents deposit today?
nAsma plans to retire in exactly 20 years. After retirement her goal is to invest in a fund that will allow her to receive Rs. 20,000 at the end of each year for the next 30 years after retirement. She will be able to earn 11% per year during the 30-year retirement period. How large a fund will Asma need when she retires in 20 years to provide for the 30-year, Rs, 20,000 retirement annuity?
Walter and Skyler wish to set up a trust fund for their new daughter, Holly, which will provide her with $2,700 at the end of every 6 months for 26 years. The first payment will be 18 years, 6 months from now and interest on the fund is 4.04% compounded semi-annually. How much should Walter and Skyler set aside today for Holly? $0.00 Round to the nearest cent
Carla Lopez deposits $5, 200 a year into her retirement account. If these funds have an average eaning of 6 percent over the 40 years until her retirement, what will be the value of her retirement account?
An engineer planning for her retirement will deposit 15% of her salary each year into a stock fund. If her salary this year is $88000(end of year 1) and she expects her salary to increase by 12% each year, what will be the future worth of the fund after 16 years if it earns 10% per year?
Ginger Rogers deposits $3,000 a year into her retirement account. If these funds have an average earning of 8 percent over the 40 years until her retirement, what will be the value of her retirement account?
A civil engineer planning for her retirement places 11% of her salary each year into a high-technology stock fund. If her salary this year (end of year 1) is $180,000 and she expects her salary to increase by 2% each year, what will be the future worth of her retirement fund after 13 years provided it earns 11% per year? The future worth of her retirement fund will be what