Juan have a $100 investment, each week Juan recive 1% profit of that $100 investment, but Juan being smart want to get 1 to 1 margin on just the profit and reinvest it whith the initial investment.

How much money Juan going to have on the end of week 5? He just taking margin on the 1% profit he reciving each week.

I think the patterns go like this IDK

week 1 101

week 2 103.02

week 3 107.10

I need the formula, and if u can the excel formula too

PLS HELP