If the NCP is more than the minimum cash needed and some debt is owed at the beginning of the year, you must pay off as much debt as possible (without taking the cash below the minimum amount required to start the next year). Repayments reduce cash on hand, of course.
The NCP is $34,000
Mini. Cash $10,000
Debt Owed $50,000
I need help with an Excel "IF" formula.