Special Webinar Question: Education needs analysis

Posted by Adam Scherer, CFP®, MS

May 14, 2020

This question is a part of BIF's Special Webinar series which was created to help students affected by the July 2020 CFP® Exam postponement to September 2020.


The Clark’s want to start saving for their daughter, Cari’s, college education. Cari turned age 3 today. The cost is currently $25,000. The CPI is currently 3% and college expenses are assumed to increase by 5% per year. Cari will begin college at age 18 and graduate in 4 years. The Clark's will fund their education savings at the end of each year and assume they can earn 8% per year.

Question 1: What will the cost for Cari’s first year in college be?

Question 2: What amount must the Clark's have accumulated by day one of Cari’s college attendance?

Question 3: How much must the Clark's invest each year to accumulate the needed amount by day one of Cari’s college attendance?


Scroll for keystrokes...

 

 

 

 

Question 1: What will the cost for Cari’s first year in college be?

Keystrokes:

HP 12c HP 10BII
[f] [CLX] [shift C ALL]
25000 [CHS] [PV] 25000 [+/-]
15 [n] 15 [N]
5 [i] 5 [I/YR]
Solve [FV] Solve [FV]
51973 51973


Question 2: What amount must the Clark's have accumulated by day one of Cari’s college attendance?

Keystrokes:

HP 12c HP 10BII
BEGin mode BEGin mode
51973 [PMT] 51973 [PMT]
4 [N] 4 [N]
0 [FV] 0 [FV]
1.08 [ENTER] [(1.08 ÷ 1.050) – 1] x 100 = 2.8571
1.05 [÷] [I/YR]
1 [-] Solve [PV] -199389
100 [x]  
[i]  
[f] [PV] -199389  
[(1.08 ÷ 1.050) – 1] x 100 = 2.8571  


Question 3: How much must the Clark's invest each year to accumulate the needed amount by day one of Cari’s college attendance?

Keystrokes:

HP 12c HP 10BII
END mode END mode
199389 [FV] 199389 [FV]
0 [PV] 0 [PV]
8 [i] 8 [I/YR]
15 [n] 15 [N]
Solve [PMT] Solve [PMT]
-7343 -7343



CFP® Exam insight:

When using the three-step, build a foundation of knowledge by committing the interest rate, calculator mode (BEG/END), and variable to solve for in each step. By understanding these core components, the remaining data to input is plug and play!

 

Topics: Practice Questions