Hi all!
I have a following problem.
Please see the Excel attached.
Sheet1 = Acc based, in which revenue and hence costs are recognized according to the project finalisation phase (%).
Sheet2 = Cash based, in which I want to have a look at the cash in and outflows every month. Revenue is recognized according to the project finalisation phase and costs are recognized according to the payment plan (cost percentages).
However I am more interested in the cash based one. With the information in the Excel file, am I calculating NWC correctly? Do the items behave like that in the selected balance sheet items?
Thank you very much in advance, really appreciated!
Taachan
PS. Why no Excel files can be uploaded?
I have a following problem.
Please see the Excel attached.
Sheet1 = Acc based, in which revenue and hence costs are recognized according to the project finalisation phase (%).
Sheet2 = Cash based, in which I want to have a look at the cash in and outflows every month. Revenue is recognized according to the project finalisation phase and costs are recognized according to the payment plan (cost percentages).
However I am more interested in the cash based one. With the information in the Excel file, am I calculating NWC correctly? Do the items behave like that in the selected balance sheet items?
Thank you very much in advance, really appreciated!
Taachan
PS. Why no Excel files can be uploaded?
