Question: I don't know where to start so any help would be appreciated thank you! Tri-County Social Service Agency is a not-for-profit organization in the Midwest.


I don't know where to start so any help would be appreciated thank you!
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 $16. If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $16 minimum. It is anticipated that the year will begin with an $19 cash balance. Contract revenue is received evenly during the year. Mental health income is expected to grow by $5 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. Complete this question by entering your answers in the tabs below. Cash Budget for Tri-County Social Service Agency (in thousands) Quarters II IV Year $ 19 $ 19 Cash balance, beginning Receipts: Grants 100 82 280 Contracts 80 Mental health income 32 153 Charitable donations 330 280 480 Total cash available 481 407 Less Disbursements: 354 1,588 82 83 66 288 5 7 6 22 23 16 19 81 Salaries and benefits Office expenses Equipment purchases & maintenance Specific assistance Total disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings from endowment fund Repayments Total financing effects Cash balance, ending (54) 132 124 (31) Complete this question by entering your answers in the tabs below. Required 2 Required 3 Determine the amount that the agency will owe the endowment fund at year-end. (Enter your answer in thousands.) Amount owed to endowment fund
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
