Help with formula for a overdraft facility in cash flow

Question

Hello&nbsp;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-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 350.000&nbsp;&nbsp;&nbsp;Overdraft&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10.000.000&nbsp;&nbsp;&nbsp;Need&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 350.000&nbsp;&nbsp;&nbsp;&nbsp;Thank you!&nbsp;

twifoo · Answer

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

Forum Discussion

Help with formula for a overdraft facility in cash flow

1 Reply

Cash flow	- 350.000
Overdraft	10.000.000
Need	350.000