Compound interest formula with Increasing interest each year HELP!

Looking for help on figuring out compound interest formula with Increasing interest each year.

so for example.

Start with $100. first year pays 3%. each year, the 3% increases by 5%.

so year 1, on $100, you are paid 3%, or $3. total $103. NOTE--THE VALUE COMPOUNDS ONCE A YEAR.

second year, you start with $103, but the 3% interest jumps to 3.15%. you end the year with $106.24.

and so forth.

someone helped me with the formula of this.

=ROUND(B2*PRODUCT(INDEX(1+B3*(1+B4)^(ROW(1:20)-1),0)),2)

and it works fine. my goal is to find the resulting value after 20 years. you can see in the sheet it is correct, at $262.85.

heres my question....how can i change this formula to where the interest COMPOUNDS 4 times a year, and splits the initial 3% 4 times a year, like a dividend. but the Interest increase only increases once a year (like originally).

so to be more specific. in the original example, 3% is paid in interest once a year. in the new question, the scenario is 3%/4 = 0.75% is paid after 3 months, then 0.75% at 6 months, another 0.75% at 9 months, then last 0.75% at 12 months (total 3%). at the end of the year, the 3% is increased 5% to 3.15%

Bo-_Ry---so polite and so accurate!!!

thank you! worked perfectly!

Is there anyway to alter this formula to add in another variable? i changed things up a tad bit.
i want to add a third variable - "Stock performance". the other two from before similar, but now called "Dividend % Gain" - which is the same as the previous Interest rate heading, and Dividend Increased Rate.

as you can see from the new worksheet, i want the value in B6 to match the value in cell Z25. if the stock performance cell, B3 is kept at zero, then the current formula works of course.

but if i change the stock value in B3 to something else, of course it doesnt match.

how would i alter the formula to include changes in B3?

thank you.