the underlying formula that you want to use here for compound interest is
A = P(1 + r/n)^(nt)
solving that for the variable "P" yields
P = A / (1 + r/n)^nt
for this scenario that means taking
P = 500000 / (1 + 0.04/12)^(12*10)
P = 335,383.04
meaning that to have $500,000 available for retirement in 10 years, you would need to invest a principal of $335,383.04 today
Jared A.
06/24/18