Modeling Case Study - Balancing the Balance Sheet

How to wire the ending balance of the cash flow statement into the balance sheet using min and max functions. How to handle positive and negative cash balances and how they affect the cash and revolver lines.