Answer:
The retirement account will be $1,049,913.57 in 40 years.
Step-by-step explanation:
a) Data and Calculations:
Monthly deposits = $400
Interest rate = 7% compounded monthly
Annualized interest rate = 0.5833% (7%/12) monthly
Period of contribution = 40 years (40 x 12 = 480 months)
FV (Future Value) $1,049,913.57
PV (Present Value) $64,367.84
N (Number of Periods) 480.000
I/Y (Interest Rate) 0.583%
PMT (Periodic Payment) $400.00
Starting Investment $0.00
Total Principal $192,000.00
Total Interest $857,913.57