Question

In: Finance

Iri is a newborn. Her parents are planning to contribute $4,000 a year (or possibly less)...

Iri is a newborn. Her parents are planning to contribute $4,000 a year (or possibly less) towards her college fund into an account that will grow at a constant rate of 4.5% a year. Both parents work for the same company that offered to match parental contributions dollar for dollar for the first 5 parental deposits and 30 cents for every parental dollar for subsequent parental deposits until Iri reaches 19. Once she reaches 19, both the company and parents stop their contributions. College costs are expected to be $40,000 a year and Jane spends 4 years in college once she reaches 19. Assume that the beginning balance on the account is $25,000(a)What is the smallest amount parents should contribute each year to make Iri's college affordable? The complete table below and solve the problem (15 points).

Inputs
Beginning Balance (at age 0)
Annual parental contribution
Interest rate
Annual college cost
Account Deposit or withdrawal at Interest Total in
Jane's balance the beginning earned account
age beg. year of year during year end of year
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

Solutions

Expert Solution

Answer:

The smallest amount parents should contribute each year to make Iri's college affordable = $1,967.46

Completed table is as follows:

The formulas are built in the respective cells and the value of 'Annual parental contribution' is calculated through 'Goal Seek':

This excel with 'show formula' is also given below this table:

The above excel with 'show formula':

--------------------------------------------------------------------------------------------------------------------------------------

1. I have keyed in 'annual parental contribution' as $4000 initially as given:

The results are as follows:

2. With annual parental contribution of $4000, we find account balance of $113,663.67 (at age 22). Smallest amount parents should contribute each year is the amount at which this account balance (in the row at age 22) can be zero.

Use 'Goal seek' to get the appropriate amount of "annual parental contribution" to make this account balance (in the row at age 22) = 0 as follows:

3. On clicking 'OK' on goal seek pop up, you will get the following, which is the answer:


Related Solutions

Jane is a newborn. Her parents are planning to contribute $4,000 a year (or possibly less)...
Jane is a newborn. Her parents are planning to contribute $4,000 a year (or possibly less) towards her college fund into an account that will grow at a constant rate of 4.5% a year. Both parents work for the same company that offered to match parental contributions dollar for dollar for the first 5 parental deposits and 30 cents for every parental dollar for subsequent parental deposits, until Jane reaches 19. Once she reaches 19, both the company and parents...
A newborn baby receives $2,000 on her birthday from her parents which is deposited into an...
A newborn baby receives $2,000 on her birthday from her parents which is deposited into an account and invested in the Vanguard S&P 500 Index Fund. That is $2,000 deposited at t=0. Assume that on every subsequent birthday up to and including her 16th birthday, the baby's parents deposit an additional $1,000 into the same account and invest the money in the Vanguard S&P 500 Index Fund. That is $1,000 deposited on each of t=1 through t=16. There are no...
Taylor, age 18, is a dependent of her parents. In the current year, she has the following income: $4,000 wages from a summer job
Taylor, age 18, is a dependent of her parents. In the current year, she has the following income: $4,000 wages from a summer job, $1,800 interest from a money market account, and $2,000 interest from City of Boston bonds. a. What is Taylor’s taxable income for the year? b. What is Taylor’s Federal income tax liability for the year?
Salina is a 7-year-old who lives with her parents in a suburban community. Her parents brought...
Salina is a 7-year-old who lives with her parents in a suburban community. Her parents brought Salina to the United States from their homeland in Greece when she was 1 year old. At the age of 3, Salina was in the 10th percentile for height and weight, pale, and her hemoglobin was 5.8 g/dL. Following further diagnostic studies, she was diagnosed with beta-thalassemia major. Over the course of the next 4 years, Salina was hospitalized every 1–2 months so she...
A seven-year-old girl has wandered off away from her parents in Disney World. Her parents have...
A seven-year-old girl has wandered off away from her parents in Disney World. Her parents have filed a case with Disney, and the search for their daughter has commenced. The girl is in the Magic Kingdom with probability 1/2, she is in Animal Kingdom with probability 1/3, and she is in Epcot Center with probability 1/6. If she is in the Magic Kingdom, the chance of finding the girl is 1/5. If she is in Animal Kingdom, the chance of...
A friend with a newborn is wondering how much to contribute to a529 plan to...
A friend with a newborn is wondering how much to contribute to a 529 plan to help fund college for the child in 18 years. She wants to have $125,000 in the account to help pay for the child’s four years of college. You believe the fund can earn 7% annually and that inflation will average 3%. How much must be contributed at the end of each year to fund this account? A. $6,900. B. $3,680. C. $2,980. D. $4,050....
In 2017, Sheryl is claimed as a dependent on her parents’ tax return. Her parents’ ordinary...
In 2017, Sheryl is claimed as a dependent on her parents’ tax return. Her parents’ ordinary income marginal tax rate is 35 percent. Sheryl did not provide more than half her own support. What is Sheryl’s tax liability for the year in each of the following alternative circumstances? a) She received $7,000 from a part-time job. This was her only source of income. She is 16 years old at year-end. b) She received $7,000 of interest income from corporate bonds...
In 2020, Sheryl is claimed as a dependent on her parents' tax return. Her parents report...
In 2020, Sheryl is claimed as a dependent on her parents' tax return. Her parents report taxable income of $500,000 (married filing jointly). Sheryl did not provide more than half her own support. What is Sheryl's tax liability for the year in each of the following alternative circumstances? b. She received $6,800 of interest income from corporate bonds she received several years ago. This is her only source of income. She is 16 years old at year-end. c. She received...
4. A 4-year-old girl presents with her parents to the emergency room you work at. Her...
4. A 4-year-old girl presents with her parents to the emergency room you work at. Her parents explain that the flu is going around her daycare and that their daughter began to feel sick 4 days ago. She has been unable to eat since then, with prolonged vomiting for 3 days. She is admitted to the hospital for rehydration and correction of her acid-base disturbance. a. Her parents are highly concerned about how she could have developed an acid-base disturbance...
Shelly is a 4-year-old preschooler who lives with her parents and younger brother. She and her...
Shelly is a 4-year-old preschooler who lives with her parents and younger brother. She and her brother attend a local daycare center during the week while their parents are at work. In the evenings she and her brother take a bath and then their parents read to them before bedtime at 8:00 P.M. Shelly's daycare class includes many children her age and she enjoys playing outside with them, Although snack times are planned, Shelly would rather play and does not...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT