I could use some help with the following assignment. Below are the instructions.

Your clients, Jerry and Jenny, are 25 years old. They have come to you for assistance with planning for the cost their child's education and their retirement. They would like to know if they are on track to reach these two goals. Below are the facts about the family.

Jenny currently earns $150,000 and they expect to need $150,000 per year in today's dollars in retirement. Jerry is a stay-at-home dad.

Jenny plans to retire at age 67, and they expect to live until age 100.

They also expect that Social Security will provide $40,000 of benefits in today's dollars at age 67.

Jenny has been saving $5,000 annually in her 401(k) plan.

Their son, Jazz, was just born and is expected to go to college in 18 years.

They want to save for Jazz's college education, which they expect will cost $20,000 in today's dollars per year and they are willing to fund 5 years of college.They want all funds needed for Jazz's college education available the first year Jazz starts college.

They were told that college costs are increasing at 7% per year, while general inflation is 3%.

They currently have $100,000 saved in total and they are averaging a 10% rate of return and expect to continue to earn the same return over time.

1. Calculate the current cost of Jazz's college education.

2. Calculate the capital needs of the couple at retirement and the current value (today's value) of their retirement needs.

3. Provide the couple with a summary of their goals with the current total amount needed to reach their goals, showing how you arrived at the total.

And here is the work I have thus far.

1.Calculate the current cost of Jazz's education. $20,000 tuition compounded annually at 7% comes to a total of $115,014.78 for 5 years of education.

2.Calculate the capital needs of the couple at retirement and the current value (today's value) of their retirement needs.

Current Value of retirement needs = $3,630,000.00

Capital needs at retirement = $4,961,708.86

3.Provide the couple with a summary of their goals with the current total amount needed to reach their goals, showing how you arrived at the total.

As listed above, the couple's two main goals are retirement savings and education savings. The couple's capital needs at retirement = $4,961,708.86

N = 504 (12 x 42 years to retirement)

I = .83333 (10% / 12 months)

PV = -100,000.00 (current savings)

PMT = $205.54 (Savings needed per month, at month's end)

In addition, the costs of Jazz's education are needed. Jerry and Jenny need to save $7,018.84 per year to save enough to fund all of Jazz's 5-year education by his freshman year. This is calculated in 2 steps as...

1. CFj = 0

CFj = 0

N = 17

CFj = -20,000.00

NJ = 5

I/YR = 2.80 (1.10 / 1.07 - 1 * 100)

NPV = $57, 564.38

2. N = 18

I/YR = 10

PV = 57,564.38

FV = 0

PMT = $7,018.84