Planning for Harold’s College Education

James Street wants to ensure that his son, Harold, has enough money to cover his college expenses when he turns 18. To achieve this goal, Street plans to make eight annual deposits into an account that earns 10% interest annually. He needs to determine the amount he should deposit each year to meet Harold’s college expenses.

Harold’s college expenses are estimated to be $18,000 for his freshman year, $19,000 for his sophomore year, $20,000 for his junior year, and $21,000 for his senior year. These expenses will occur at the beginning of each of these four years.

To calculate how much Street should deposit annually, we can use the future value of an annuity formula:

��=���×[(1+�)�−1�]FV=PMT×[r(1+r)n−1​]

Where:

• $FV$ is the future value of the annuity (total amount needed for Harold’s education).
• $PMT$ is the annual deposit.
• $r$ is the annual interest rate (10% or 0.10).
• $n$ is the number of years (8 years in this case).

We need to calculate $PMT$, which is the annual deposit Street needs to make:

��=���×[(1+0.10)8−10.10]FV=PMT×[0.10(1+0.10)8−1​]

Now, plug in the values:

��=���×[2.14470.10]FV=PMT×[0.102.1447​]

Solving for $PMT$:

���=��2.1447PMT=2.1447FV​

Now, calculate $FV$, which is the total amount needed for Harold’s education:

$FV=18,000+19,000+20,000+21,000=78,000$

Now, calculate the annual deposit $PMT$:

���=78,0002.1447≈36,367.42PMT=2.144778,000​≈36,367.42

So, James Street should deposit approximately $36,367.42 annually for eight years to provide for Harold’s education.

Problem 2: Planning for College and Retirement

You are 30 years old and have two children with college expenses and retirement goals. Let’s break down the calculations for each goal:

College Expenses for Child 1 (10 years from now)

You need to make four annual payments for college expenses, and the interest rate is 13% annually. To calculate the annual deposit, you can use the future value of an annuity formula as follows:

��=���×[(1+�)�−1�]FV=PMT×[r(1+r)n−1​]

Where:

• $FV$ is the future value of the annuity (total amount needed for college expenses).
• $PMT$ is the annual deposit.
• $r$ is the annual interest rate (13% or 0.13).
• $n$ is the number of years (10 years in this case).

Calculate the total college expenses (FV):

$FV=10,000+11,000+12,000+13,000=46,000$

Now, calculate the annual deposit (PMT):

���=46,000[(1+0.13)10−10.13]PMT=[0.13(1+0.13)10−1​]46,000​

Solving for PMT:

���≈46,0003.8697≈11,876.97PMT≈3.869746,000​≈11,876.97

You should save approximately $11,876.97 annually for ten years to meet the first child’s college expenses.

College Expenses for Child 2 (15 years from now)

Similar to Child 1, you need to make four annual payments for Child 2’s college expenses. The total expenses are $15,000 + $16,000 + $17,000 + $18,000 = $66,000. Using the same formula with a 13% interest rate and 15 years:

���=66,000[(1+0.13)15−10.13]PMT=[0.13(1+0.13)15−1​]66,000​

Solving for PMT:

���≈66,0007.3766≈8,948.78PMT≈7.376666,000​≈8,948.78

You should save approximately $8,948.78 annually for fifteen years to meet the second child’s college expenses.

Retirement Savings

You plan to retire in 30 years and need to withdraw $50,000 per year for 20 years with the first withdrawal on your 61st birthday. To calculate the annual deposit for retirement, you can use the present value of an annuity formula:

��=���×[1−1(1+�)�]×1�PV=PMT×[1−(1+r)n1​]×r1​

Where:

• $PV$ is the present value (the amount you need to save).
• $PMT$ is the annual withdrawal amount ($50,000).
• $r$ is the annual interest rate (13% or 0.13).
• $n$ is the number of years you will withdraw (20 years).

Calculate the present value (PV):

��=50,000×[1−1(1+0.13)20]×10.13PV=50,000×[1−(1+0.13)201​]×0.131​

Solving for PV:

$PV\approx 50,000\times 9.4557\times 7.6923\approx 3,631,692.31$

You need to accumulate approximately $3,631,692.31 by your 60th birthday to support your retirement.

Annual Savings for Retirement

Assuming you currently have $10,000 available to meet your retirement goal, you need to calculate the annual savings required to reach $3,631,692.31 in 30 years. You can use the future value of a lump sum formula:

��=��×(1+�)�FV=PV×(1+r)n

Where:

• $FV$ is the future value ($3,631,692.31).
• $PV$ is the present value ($10,000).
• $r$ is the annual interest rate (13% or 0.13).
• $n$ is the number of years (30 years).

Rearrange the formula to solve for the annual savings (PMT):

���=��(1+�)�−��PMT=(1+r)nFV​−PV

Plug in the values:

���=3,631,692.31(1+0.13)30−10,000PMT=(1+0.13)303,631,692.31​−10,000

Solving for PMT:

���≈3,631,692.3124.5488−10,000≈147,866.98PMT≈24.54883,631,692.31​−10,000≈147,866.98

You need to save approximately $147,866.98 annually for 30 years to meet your retirement goal, assuming you have $10,000 available now.

Problem 3: Retirement Planning

You are 30 years old and want to retire at age 60 with a 20-year, $100,000 beginning-of-the-year annuity, with the first payment to be received on your 60th birthday. You expect your investments to earn 12% per year over the next 15 years and 10% per year thereafter. Let’s calculate the necessary accumulation and the annual savings:

Part A: Accumulation by Age 45

To find out how much you need to accumulate by age 45, you can use the future value formula:

��=��×(1+�1)1�×(1+�2)2�FV=PV×(1+r1​)1n​×(1+r2​)2n​

Where:

• $FV$ is the future value ($100,000 for 20 years).
• $PV$ is the present value (amount to accumulate by age 45).
• �1r1​ is the interest rate for the first 15 years (12% or 0.12).
• �1n1​ is the number of years for the first period (15 years).
• �2r2​ is the interest rate for the remaining years (10% or 0.10).
• �2n2​ is the number of years for the second period (20 years).

Plug in the values:

100,000=��×(1+0.12)15×(1+0.10)20100,000=PV×(1+0.12)15×(1+0.10)20

Solving for PV:

��=100,000(1.1215×1.1020)PV=(1.1215×1.1020)100,000​

Calculate PV:

��≈100,00017.8913×6.7275≈877.48PV≈17.8913×6.7275100,000​≈877.48

You need to accumulate approximately $877.48 by the time you reach age 45.

Part B: Equal Annual Savings for 15 Years

Now, let’s calculate the equal, annual amount you must save at the end of each of the next 15 years to achieve your objective. We already know you need to accumulate $877.48 by age 45, and you currently have $10,000 available.

Using the future value of a lump sum formula:

��=��×(1+�)�FV=PV×(1+r)n

Where:

• $FV$ is the future value ($877.48).
• $PV$ is the present value ($10,000).
• $r$ is the annual interest rate (12% or 0.12).
• $n$ is the number of years (15 years).

Rearrange the formula to solve for the annual savings (PMT):

���=��(1+�)�−��PMT=(1+r)nFV​−PV

Plug in the values:

���=877.48(1+0.12)15−10,000PMT=(1+0.12)15877.48​−10,000

Solving for PMT:

���≈877.485.6528−10,000≈1,547.14PMT≈5.6528877.48​−10,000≈1,547.14

You should save approximately $1,547.14 at the end of each of the next 15 years to achieve your retirement goal, assuming you currently have $10,000 available.

In summary, by strategically calculating the necessary savings and annual contributions for both college and retirement goals, you can better plan your financial future and secure your family’s education and retirement needs.