You estimate you will need $3,548,041 in 30 years. How much do you need to save on a yearly basis in order to achieve your goal? Consider that the prevailing interest rate is 5%.

I would like to see the process done manually, without Excel.