Tri-County Social Service Agency is a not-for-profit organization in the Midwest. Use the following information to complete the cash budget for the year ending December 31.

• The Board of Trustees requires that Tri-County maintain a minimum cash balance of $9,000.
• If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $9,000 minimum.
• It is anticipated that the year will begin with an $12,000 cash balance.
• Contract revenue is received evenly during the year.
• Mental health income is expected to grow by $3,000 in the second and third quarters; no change is expected in the fourth quarter.

***. Complete the cash budget for each quarter and the year as a whole. and. Determine the amount that the agency will owe the endowment fund at year-end.

How would I go about solving?

Cash balance, beginnin 12 12 Receipts Grants Contracts Mental health income Charitable donations 293 60 227 53 470 450 Total cash available 525 365 Less Disbursements Salaries and benefits Office expenses Equipment purchases & maintenance Specific assistance 1,713 335 25 80 375 103 76 60 Total disbursements (68) 130 Excess (deficiency) of cash available over disbursements Financing 145 Borrowings from endowment fund Repayments (27) Total financing effects Cash balance, ending