P&L impact and Cash flow impact (for expenses) - with payment terms

[Adfinance]

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

I need to calculate automatically 2 things (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 with this 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

drive.google.com

Best,
Adam

 

[Adfinance]

@maabadi ... @CA_Punit Any idea? Thank you so much.