For simplicity's sake, suppose I have an investment that earns 1% daily return on average.
The following day, that 1% earning is immediately rolled over into an account that earns 10% yearly compounding daily.
So suppose I had $1000 as an initial investment, by day two I would have $1010. That $10 would then be rolled into the 10% APY account. This cycle would repeat every day.
How would I calculate the ending yield and total overall APY % if I plugged it into a spreadsheet?