Question
You are planning on having your first child next month and your parents have told you that they are going to open an account with
You are planning on having your first child next month and your parents have told you that they are going to open an account with $3,000 on the day your child is born. The money is to be used for college.
You plan to also put $1,500 of your own money into the same account on the day your child is born, and then another $1,500 into the account each year on your child's birthday, through his/her 18th birthday.
If the account averages an 8% annual return, what will the account balance be on your child's 18th birthday?
PLEASE show work in excel using appropriate excel 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