A tricky one....

[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

 

[Scott T]

Duplicate
https://www.mrexcel.com/forum/excel...eriods-full-contract-dates-payment-terms.html

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).