Compounding Annually with any date

[smartpat19]

Can't figure out how to make this formula work. I have a start date and an annual increase % from that start date.

For example: In row 2 I want the annual increase to happen every April and row 3 I want the increase every August. These should compound as the years go on.
The start date will be any date and not always the first of the month. The schedule of months will always be the end of the month

Thank you ahead of time for your help

 

[_Nemo_]

What is the reason for having each month listed as separate column when each row increase only happens once per year? In other words why not have the top column as years instead of months?

 

[Dave Patton]

T202011b.xlsm
	A	B	C	D	E	F	G
1	Start	Rent	Annual Increase	31-Jan-19	28-Feb-19	31-Mar-19	30-Apr-19
2	1-Apr-19	15000	3%	0.00	0.00	0.00	1,250.00
3	1-Jan-19	12000	3%	1,000.00	1,000.00	1,000.00	1,000.00
2a

Cell Formulas
Range	Formula
D2:G3	D2	=IF($A2<D$1,FV($C2,DATEDIF($A2,D$1,"Y"),0,-$B2)/12,0)