( Cash budgeting) At the beginning of January, the south Carolina sportsplex has 150,000 of cash on hand. The firms forecasts of the cash flows for the first six months of the year are given here (in thousands 1000s). The S.C sportsplex wants to maintain a cash balance of at least 100,000 at all times. If the balance falls below that level, the firm will borrow to bring its balance up to 100,000. If more than 100,000 of cash is available, it will use the excess to reduce its short term borrowing.

Show the monthly net cash flow, borrowing (if any), loan repayments, cash balance, and cumulative borrowing balance.

Jan. Feb. Mar. Apr. May. Jun.

Cash inflows 100 120 150 320 350 240

Cash outflows 150 180 200 290 240 180