Interest compounded on a 3 monthly basis

I have values that I need to apply interest to as below

1 April 16 to 1 November 17 1.25%
2 November 17 to 1 August 17 1.50%
2 August 17 to 31 August 18 1.75%

The problem I have is that it has to be compounded on a 3 monthly basis. Can anybody help with a formula/function to do this?

Thanks

=sumproduct(lookup(row(index($a:$a,d2):index($a:$a,e2)),$a$2:$b$5)/(365+(mod(year(row(index($a:$a,d2):index($a:$a,e2))),4)=0)))

Thanks for your help, tim201110. Still playing with this and getting slightly different answers doing the calculation manually. Will keep trying.