Question

In: Finance

A man begins setting aside money for a child's college expenses, sadly due to rises in...

A man begins setting aside money for a child's college expenses, sadly due to rises in tuition there really isn't much room for a graduation gift. What should the value of the annuity be if he begins depositing on year 1 and deposits a total of 15 annuities at 6.1%. The child will draw 9835 dollars at year 18 since they have scholarships, 15203 dollars on years 19 and 20 since they have lost their scholarships, and 19888 dollars on year 21 since they are in excess credit hours and have changed their major from engineering to communications. Afterwards, the parents can be considered to have no more money to give said child. He or she is now left to deal with predatory student loan companies since America has done little in the way subsidizing higher education.

Solutions

Expert Solution

Answer:

Let us assume deposit starts on start of year 1.

Total of 15 annual deposits are made.

Rate of interest = 6.1%

Withdrawals:

1. At the start of year 18 = $9,835

Value at the start of year 16 will be = Future Value / (1 + Interest rate) n = $9,835 /(1 + 6.1%)2

2. At the start of year 19 = $15,203

Value at the start of year 16 will be = Future Value / (1 + Interest rate) n = $15,203 /(1 + 6.1%)3

3. At the start of year 20 = $15,203

Value at the start of year 16 will be = Future Value / (1 + Interest rate) n = $15,203 /(1 + 6.1%)4

4.At the start of year 21 = $19,888

Value at the start of year 16 will be = Future Value / (1 + Interest rate) n = $19,888 /(1 + 6.1%)5

As such value of all withdrawals as on start of year 16 = $9835 / (1 + 6.1%) 2 + $15,203/ (1 + 6.1%) 3 + $15,203 / (1 + 6.1%) 4 + $19,888 / (1 + 6.1%) 5

= $48,253.73

Now we can use PMT function of excel to get value of annuity:

PMT (rate, nper, pv, fv, type)

PMT (6.1%, 15, 0, -48253.73, 1)

=$1,939.09

Required value of the annuity = $1,939.09


Related Solutions

2. A couple wants to save money for their child's college education. They deposit their money...
2. A couple wants to save money for their child's college education. They deposit their money in the bank at 6% interest. How many thousand dollars should be deposited in the bank annually from the age of 2 to the age of 17 so that a child from 18 to 21 years old can receive $ 501072 worth of money each year? (Interest will continue to be applied to the money other than the amount withdrawn from the account.)
Linda is considering setting money aside for her retirement and would like to minimize her taxable...
Linda is considering setting money aside for her retirement and would like to minimize her taxable income at the time of distribution. Which distribution will increase her taxable income?
Henry is a 60 year-old, white college man who woke due to intense and worsening pain...
Henry is a 60 year-old, white college man who woke due to intense and worsening pain in his right flank this morning. He came to your emergency room in a state of distress, with diaphoresis (sweating) and pallor (pale appearance). He was unable to sit still or become comfortable in the ER cot, groaning and stating that he was nauseated. His past medical history includes diabetes, gout, and controlled hypertension. He takes medications for his diabetes, gout, and hypertension; he...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT