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 $$21.$

If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $$21$ minimum.

It is anticipated that the year will begin with an $$24$ cash balance.

Contract revenue is received evenly during the year.

Mental health income is expected to grow by $$6$ in the second and third quarters; no change is expected in the fourth quarter.

Required:

$2.$ Complete the cash budget for each quarter and the year as a whole.

$3.$ Determine the amount that the agency will owe the endowment fund at year$-$end. Cash Budget for Tri$-$County Social Service Agency

$\backslash$table$[[($in thousands$)],[,$Quarters,Year$],[,$I,II$,$III,IV$],[$Cash balance, beginning,$24,24],[$Receipts:$],[$Assessment Tool iFrame,$60,93,,,245],[,,,,60],[$Mental health income,$46,,,,214],[$Charitable donations,$390,,350,570,],[$Total cash available,,$512,490,,],[$Less Disbursements:$],[$Salaries and benefits,,$349,,,1,772],[$Office expenses,$96,,94,84,,344],[$Equipment purchases & maintenance,$6,10,5,,28],[$Specific assistance,$25,17,19,,77],[$Total disbursements$],[$Excess $($deficiency$)$ of cash available over disbursements,$(62),,,123,],[$Financing:$],[$Borrowings from endowment fund,,,$122,,],[$Repayments$,,(45)|,$ in$,,,],[$Total financing effects$],[$Cash balance, ending,,,,,$]]$ Determine the amount that the agency will owe the endowment fund at year$-$end. $($Enter your answer in thousands.$)$

Amount owed to endowment fund. Complete the cash budget for each quarter and the year as a whole. $($Cash deficiency and repayments should be indicated by a minus sign. Enter your answers in thousands.$)$