Project revenue recognition and cash flow analysis

Discussion in 'General Accountancy Discussion' started by Taachan, Nov 27, 2018.

  1. Taachan

    Taachan

    Joined:
    Nov 27, 2018
    Messages:
    1
    Likes Received:
    0
    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?
     

    Attached Files:

    Taachan, Nov 27, 2018
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.