I would like to make an excel formula according to this situation:
Person A / Person B Person A invests 1000$ every year from 18 to 28, and then holds it until age 65. It compounds every year with 8%.
Person B invests 0$ every year from 18 to 28 but then starts to invest 1000$ every year until age 65. It compounds every with with 8%.
I want 47 rows (65-18) for Person A & B and finally a "total". I want to see it grow in every cell.
Anyone that could help me set it up and perhaps link it to a an upload service? I want to learn... :) Thanks! :)