Hi,
I need to prepare a cash flow which uses deferred payments from customers based on numbers of days. So we invoice customer day 0; then customer pays 45 to 60 days later. But these number of days may vary in different cash flows. Is there any function/formula which can be used to project this in a monthly cash flow for different scenarios i.e. by changing value of deferment days?
Hi and welcome to the forum.
Yes, I don't see any difficulties. However we need to see the request in context. You need to upload your workbook and manually add the results you expect to see. Be sure to clearly identify the data you start with and which are the results.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks v much. Attached file TestCashFlow
This may be of some help.
1) Row 2 is populated by actual purchase dates,
2) The payment to supplier row is populated using: =SUMIFS($A3:A3,$A2:A2,"<="&EOMONTH(B1,0)-$B12)-SUM($A5:A5)
3) The credit received from customer row is populated using: =SUMIFS($A3:A3,$A2:A2,"<="&EOMONTH(B1,0)-$B13)-SUM($A7:A7)
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks