Help with formula for a overdraft facility in cash flow

Copper Contributor

Hello 

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.

Example:

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.