Question
You value education and you want your child to receive the best possible education. But sending a child to private schools and Ivy League colleges
You value education and you want your child to receive the best possible education. But sending a child to private schools and Ivy League colleges is not cheap. You want to start saving money so that when you child need the money, you can support him/her. The current assumption is you will have your 1st child in 5 years and you wish to have $200,000 in todays dollars when he/she is 15 years old. Based on current situation, you expect inflation to be stable at 2% in the foreseeable future. Your plan is to put down savings each year and you can save every year an amount thats 2% more than the previous year. All your savings go to a stock fund that is expected to return 10% annually, of which 1.5% will be dividends and 8.5% will be capital gains. You pay 15% tax on dividend income as you receive them at the end of each year. You re-balance your fund every year, in other words, you sell all your positions and re-invest at the beginning of a new year, so capital gains are also realized every year, you pay 15% tax on capital gains as well. To have enough money for your childs education in 20 years, how much money do you have to save in the first year?
Please Show it completed in Excel along with formulas!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started