Help with formula for a overdraft facility in cash flow

Occasional Visitor


Can anybody help me with a formula that will calculate an overdraft facility in a cash flow sheet?

I need a formula that calculates that when cash flow is below 0, that it borrows from the overdraft and says how much I need to be in 0 at the end. Or just to calculate how much I need to be in 0 if the cash flow is negative.


Cash flow-                    350.000   
Overdraft               10.000.000   
Need                     350.000   


Thank you!


1 Reply
You have to attach your file with the cash flow sheet.