Question
In: Finance
Suppose that a young couple has just had their first baby and they wish to insure...
Suppose that a young couple has just had their first baby and they wish to insure that enough money will be available to pay for their child's college education. They decide to make deposits into an educational savings account on each of their daughter's birthdays, starting with her first birthday. Assume that the educational savings account will return a constant 9%. The parents deposit $2400 on their daughter's first birthday and plan to increase the size of their deposits by 7% each year. Assuming that the parents have already made the deposit for their daughter's 18th birthday, then the amount available for the daughter's college expenses on her 18th birthday is closest to ________.
Solutions
Expert Solution
Answer:- 160462.577
Explanation:- To calculate the amount available on the daughter's 18th birthday the following should be taken into cognizance
First, the yearly deposit increases by 7% every year, therefore year one is $2,400 but year 2 is $2,400 x1.07= $2,568 and continuing like that.
Secondly, the total deposit pre year is calculated as annual deposit for the year x (1+interest rate)∧year on a descending basis.
Following is the excel sheet showing the calculation of the amount available for the daughter's college expenses on her 18th birthday:-
Following is the Formula Sheet of above excel sheet for easy understanding of the formulas used:-
jeff jeffy answered 1 year agoRelated Solutions
Suppose that a young couple has just had their first baby and they wish to insure...
Suppose that a young couple has just had their first baby and
they wish to insure that enough money will be available to pay for
their child's college education. They decide to make deposits into
an educational savings account on each of their daughter's
birthdays, starting with her first birthday. Assume that the
educational savings account will return a constant 7%. The parents
deposit $2000 on their daughter's first birthday and plan to
increase the size of their deposits by...
Suppose that a young couple has just had their first baby and they wish to ensure...
Suppose that a young couple has just had their first baby and
they wish to ensure that enough money will be available to pay for
their child's college education. They decide to make deposits into
an educational savings account on each of their daughter's
birthdays, starting with her first birthday. Assume that the
educational savings account will return a constant 7%. The parents
deposit $2000 on their daughter's first birthday and plan to
increase the size of their deposits by...
Suppose that a young couple has just had their first baby and they wish to ensure...
Suppose that a young
couple has just had their first baby and they wish to ensure that
enough money will be available to pay for their child's college
education. They decide to make deposits into an educational savings
account on each of their daughter's birthdays, starting with her
first birthday. Assume that the educational savings account will
return a constant 7%. The parents deposit $2000 on their daughter's
first birthday and plan to increase the size of their deposits by...
Suppose that a young couple has just had their first baby and they wish to ensure...
Suppose that a young couple has just had their first baby and
they wish to ensure that enough money will be available to pay for
their child's college education. Currently, college tuition, books,
fees, and other costs, average $12,500 per year. On average,
tuition and other costs have historically increased at a rate of 4%
per year.
Assuming that college costs continue to increase an average of
4% per year and that all her college savings are invested in an...
Suppose that a young couple has just had a baby boy, and they wish to have...
Suppose that a young couple has just had a baby boy, and they
wish to have enough saved to fund four years of college education
at a school like UCLA when their son is at the ages of 19-22.
Suppose this year’s total expense of an undergraduate student at
WashU, including tuition, room and board, books and supplies,
amounts to $74,000. This annual cost is expected to grow at 3.5% a
year. To simplify the timeline, they assume that all...
A young couple has just had their first child and they decide to make deposits into...
A young couple has just had their first child and they decide to
make deposits into an investment account on each of their
daughter’s birthdays, starting with her first birthday. Assume that
the account will earn an interest rate of 4% p.a. The parents
deposit $4,000 on their daughter’s first birthday and plan to
increase the size of their deposits by 6% every year. Assuming that
the parents make the last deposit on their daughter's 18th
birthday, the amount available...
Suppose that you just had your first baby, Oprah, and you wish to ensure that enough...
Suppose that you just had your first baby, Oprah, and you wish
to ensure that enough money will be available to pay for Oprah's
college education. Tuition and other fees today add up to $12,500
per year. Tuition and other costs are expected to increase at a
rate of 4 percent per year. Assuming that all of Oprah's college
savings are invested in an account paying 7 percent interest, then
the amount of money she will need to have available...
1.A couple just had a baby. How much should they invest now 5.9%compounded daily in order...
1.A couple just had a baby. How much should they invest now
5.9%compounded daily in order to have $45,000 for the child's
education 18 years from now? Compute the answer to the nearest
dollar. (Assume a 365-day year.)
2.Find the value $20,000 at the end of one year if it is
invested in an account that has an interest rate of 5.40% and is
compounded in accordance with the rules below.
a. compounded monthly
b.compounded daily (assuming a 365-day year)...
A young couple has made a nonrefundable deposit of the first month's rent (equal to $1,000)...
A young couple has made a nonrefundable deposit of the first
month's rent (equal to $1,000) on a 6-month apartment lease. The
next day they find a different apartment that they like just as
wekk, but its monthly rent is only $900. They plan to be in the
apartment only six months. Should they switch to the new apartment?
What if they plane to stay 1 year? Assume an interest rate of
12%.
Your brother and his wife just had a baby and they are wondering when their baby...
Your brother and his wife just had a baby and they are
wondering when their baby will begin talking. They hope soon, and
they have begun saying "mama" and "dada" to their baby. What can
you tell them about the course of language development during the
first year of life?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- explain how Texas Health Resource and Intel IT department complied with computer ethics?
- What is the signed decimal equivalent of the following signed-magnitude binary value? 11101010.1001 What is the...
- For each of the following situations provide the type of variable(s) that you would use to...
- C++ Text message decoder Use getline() to get a line of user input into a string:...
- Research aspects of the case; Janus vs. AFSCME. Know the type of union being discussed. Detail...
- When have you seen extremely creative tactics used in a communications campaign? Any successes? Any failures?
- What is the unsigned hexadecimal equivalent of the following unsigned octal value? Do NOT include in...
ADVERTISEMENT