Payment terms (formula) for P&L impact and Cash flow

[Adfinance]

Hi everyone, how are you?
Could I ask you to help me please?

I need to calculate automatically 2 things (see the link below - in the tab "Cost details"):
1/ The P&L impact (taking into account several variables - from cell L13 to cell S13
2/ the Cash position (cashout) based on payment terms, total cost expense, start month and date, etc.. The payment terms may change (from cell D28 to cell D37), so I need dynamic formulas.
Can anyone help me please?

All the details to help you are displayed in the Excel file, in the tab "Instructions". And your outcome will be in the tab "Cost details".
Thank you soooo much for your help, it would be really helpful to me.

Link to access the excel file here:

To send to Mr Excel - version 1.xlsx

docs.google.com

@maabadi

 

[maabadi]

Sorry. I'm on Work trip.
1. I don't know why formula at Formula assumption Tab changes each time you upload it again.
this is Formula I see at F14

=MATCH(EOMONTH('[39]Cost details'!$O14;'[39]Cost details'!$P14)-1;'[39]Cost details'!$A$13:$EY$13)

But it Should be without [39] :

=MATCH(EOMONTH('Cost details'!$O14;'Cost details'!$P14)-1;'Cost details'!$A$13:$EY$13)

And also for F44 & F74.

2. After I Correct formula at Formula Assumption Tab, I changed Values at L14 to R 14 & it Works.

File Updated Also.