Im simulating business cash flows out 13 months, and primarily I am looking to model the cash flow impliactions between creidt grnated by suppliers and invoices /payemnt made.
I woudl like to have an input cell for both:
– Creidt grnated, in whoch i can input 2/4/6 weeks etc
– payment recived in whoch i can input 2/4/6 weeks etc
I woudl like the inputs made in these cells to to adjust the scheduling of the payments made and payemnt recived for every week in my cash flow. (i have already got invoice values in each week, but they need to be scheduled differently dependant on the payment terms above)
Thanks for your help.