+ Reply to Thread
Results 1 to 4 of 4

uncertain cash-flows timing. create monthly cash report

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    Riyadh
    MS-Off Ver
    Office 365 Subscription
    Posts
    47

    Angry uncertain cash-flows timing. create monthly cash report

    i am creating a monthly cashflow model from income statement. The problem is timing of the cash receipts & payments is not certain. sometime i receive 3 months advance from customers whereas sometime i get after 2 months etc. similarly with cash outflows sometimes i pay 2 months in advance of the recipt of goods. SOmetime i get 4 months credit.

    I wanna create a sheet where i just change the number of months i am getting credit & number of months i am giving credits to customers and the whole spreadsheet automatically get updated.

    PLease suggest what is the best way to do it.

    e.g. If i get 2 months advance from customers. i select 2 months in column A and my cashflows sheet automatcilly take the next two months sales

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: uncertain cash-flows timing. create monthly cash report

    I suggest posting a sample workbook with sample data and a sample layout of your proposed idea for a solution. You will be much more likely to get help this way.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    06-03-2013
    Location
    Riyadh
    MS-Off Ver
    Office 365 Subscription
    Posts
    47

    Re: uncertain cash-flows timing. create monthly cash report

    HElp.xlsxOK the workbook is attached

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: uncertain cash-flows timing. create monthly cash report

    This should give you a start.

    1. Change the dates in row 3 to real dates like 1/1/2014, 1/2/2014 and format as MMM.

    2. Turn on Automatic Calculation in the Excel Options and enter this formula in D6 and copy across.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Monthly to Quarterly Cash Flows
    By Spewart in forum Excel General
    Replies: 1
    Last Post: 05-13-2014, 04:56 AM
  2. Replies: 6
    Last Post: 03-19-2012, 05:39 AM
  3. NPV Formula Using Uneven, Monthly Cash Flows
    By DanoT in forum Excel General
    Replies: 1
    Last Post: 02-20-2012, 05:02 PM
  4. Waterfall Cash Model, dividing up cash flows based on IRR
    By tomservo2009 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-21-2008, 05:57 PM
  5. IRR formula for monthly cash flows
    By MB Burgis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-11-2006, 11:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1