Project revenue recognition and cash flow analysis


Joined
Nov 27, 2018
Messages
1
Reaction score
0
Country
se
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?
 

Attachments


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top