Help Compounding Annual Returns for Periodic Cash Flows

[lex1]

I have periodic cash flows, not occurring at the start-end of a month or year(see sheet 3). I want to compound annually at 9%, but at the same time I want to be able to take into account that my cash inflows and outflows don’t occur at the beginning/end of the year so shouldn’t be earning the 9% interest for the entire period. I’m stumped. Can somebody please help? Thank you!