Calculating Accrual and Prepayment periods with full contract dates and payment terms

[kgray28]

Start Date End Date PF Paid on Day Lease Period Amount Accrue / Prepayment Period
01/11/2015 31/12/2022 1 LDOP 1,332,238 01/02/2019 31/03/2019
14/03/2013 13/03/2023 3 LDOP 325,000 14/03/2019 31/03/2019
03/12/2018 31/12/2023 3 FDOP 127,500 03/03/2019 31/03/2019
01/04/2007 30/03/2022 3 LDOP 45,101
07/01/2016 06/01/2031 12 FDOP 132,159

Hello,

I am not sure if this is possible, but i have data for numerous contracts that have their start date, end date, payment frequency and when it's paid.... So for example, 3 is every 3 months, 12 is annually, 1 is monthly... LDOP, last day of Period, FDOP, first day of period. I want to work out according to the contractual payment terms as at the end of March 19 what we should be accruing / Prepaying? Is this at all possible?

Thanks