E$10-38(10$pt$)$

$1$

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

$10$

points

$-$ The Board of Trustees requires that Trl$-$County maintaln a minImum cash balance of $\backslash (\backslash$$ $15\backslash ).$

$-$ If cash is short, the agency may borrow from an endowment fund the amount required to malntain the $\backslash (\backslash$$ $15\backslash )$ minimum.

$-$ It is anticipated that the year will begin with an $\backslash (\backslash$$ $18\backslash )$ cash balance.

$-$ Contract revenue is recelved evenly during the year.

$-$ Mental health income is expected to grow by $\backslash (\backslash$$ $4\backslash )$ in the second and third quarters; no change is expected in the fourth quarter.

Complete this question by entering your answers in the tabs below.

Required $2$

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

Note: Cash deficiency shoould be entered as negative values. Enter your answers in thousands.

References

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$c$|\}\{$Cash Budget for Tri$-$County Social Service Agency$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$c$|\}\{($in thousands$)\}\backslash \backslash$

$\backslash$hline & $\backslash$multicolumn$\{4\}\{|$c$|\}\{$Quarters$\}$ & $\backslash$multirow$\{2\}\{*\}\{$Year$\}\backslash \backslash$

$\backslash$hline & I & II & III & IV & $\backslash \backslash$

$\backslash$hline Cash balance, beginning & $\backslash$$ $18$ & & & & $\backslash$$ $18\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$l$|\}\{$Receipts:$\}\backslash \backslash$

$\backslash$hline Grants & $75$ & $96$ & & & $253\backslash \backslash$

$\backslash$hline Contracts & & & & & $120\backslash \backslash$

$\backslash$hline Mental health income & $52$ & & & & $228\backslash \backslash$

$\backslash$hline Charitable donations & $480$ & & $290$ & $510$ & $\backslash \backslash$

$\backslash$hline Total cash available & & $561$ & $436$ & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$l$|\}\{$Less Disbursements:$\}\backslash \backslash$

$\backslash$hline Salaries and benefits & & $384$ & & & $1,800\backslash \backslash$

$\backslash$hline Office expenses & $102$ & & $85$ & $72$ & $362\backslash \backslash$

$\backslash$hline Equipment purchases $\backslash$& maintenance & $3$ & $7$ & $9$ & & $27\backslash \backslash$

$\backslash$hline Specific assistance & $22$ & $16$ & $18$ & & $86\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$l$|\}\{$Total disbursements$\}\backslash \backslash$

$\backslash$hline Excess $($deficiency$)$ of cash available over disbursements & $(65)$ & & & $145$ & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$l$|\}\{$Financing:$\}\backslash \backslash$

$\backslash$hline Borrowings from endowment fund & & & $113$ & & $\backslash \backslash$

$\backslash$hline Repayments & & $(36)$ & & & $\backslash \backslash$

$\backslash$hline Total financing effects & & & & & $\backslash \backslash$

$\backslash$hline Cash balance, ending & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

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 $\backslash (\backslash$$ $15\backslash ).$

$-$ If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $\backslash (\backslash$$ $15\backslash )$ minimum.

$-$ It is anticipated that the year will begin with an $\backslash (\backslash$$ $18\backslash )$ cash balance.

$-$ Contract revenue is received evenly during the year.

$-$ Mental health income is expected to grow by $\backslash (\backslash$$ $4\backslash )$ in the second and third quarters; no change is expected in the fourth quarter.

Complete this question by entering your answers in the tabs below.

Determine the amount that the agency will owe the endowment fund at year$-$end.

Note: Enter your answer in thousands.