Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 thet Tri-County maintain a minimum cash balance of $18. If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $18 minimum. . It is anticipated that the year will begin with an $21 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. Complete this question by entering your answers in the tabs below. Required 2 Required) 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.) Cash Budget for Tri-County Social Service Agency (In thousanda) Quartere 1 Il S 21 IV Year S 21 Cash balance, beginning Receipts. Grants 75 85 238 100 Contracts 170 Mental health income Charitable donations 35 350 300 500 483 429 357 1,624 296 70 85 6 24 86 7 8 25 16 19 83 Total cash available Less Disbursements: Salaries and benefits Office expenses Equipment purchases & maintenance Specific assistance Tatal disbursements Excess (deficiency) of cash available aver disbursements Financing Barrowings from endowment fund Repayments Tatal financing effects Cash balance, ending (56) 137 127 (29)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started