Answer:
Joe will need to save at an interest rate of:
C. 18%
Step-by-step explanation:
a) Data and Calculations:
Working life = 30 years
Annual investment = $5,000
Future expected savings = $3,954,750
Joe will need an annual return rate of 18.000% to reach the future value of $3,954,750.00. 
 
FV (Future Value) $3,954,752.25 
PV (Present Value) $27,584.01 
N (Number of Periods) 30.000 
I/Y (Interest Rate) 18.000% 
PMT (Periodic Payment) $5,000.00 
Starting Investment $0.00 
Total Principal $150,000.00 
Total Interest $3,804,752.25