•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Cashflow calculation in Excel
I am trying to work cashflow calculation given following information:
Sales for each month.
DSO (say 30,45 days etc.)
Using these two data (not weekly or daily data but only monthly data available), I would like to work out cashflow for each month. For simplicity, let us assume we start in Jan, ignore Dec prior year sales or receivables.
Seems straightforward to work out but quite complex to reduce it to formulas! Esp if DSO > 30 or even negative. Such as businesses that collect in advance.
Any help would be much appreciated!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#Excel compatibility
#rows.com
#Cashflow
#Calculation
#Excel
#Sales
#DSO
#Monthly data
#Formulas
#Receivables
#Collect in advance
#Business
#Financial calculation