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

Instructions >> To fill in (in tab "Cost details") From line 13 to 24: this is for Profit and loss impact From line 26 to 38 : this is for Cash flow impact Hi everyone, I need to calculate automatically 2 things (in the tab "Cost details"): 1/ The P&L impact (taking into account several variabl...

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.