Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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 $5,000. If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $5,000 minimum. It is anticipated that the year will begin with an $8,000 cash balance. Contract revenue is received evenly during the year. Mental health income is expected to grow by $6,000 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 3 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.) IV Year $ $ 8 256 100 218 410 380 508 Cash Budget for Tri-County Social Service Agency (in thousands) Quarters 1 II Cash balance, beginning $ 8 Receipts: Grants 81 97 Contracts Mental health income 47 Charitable donations 430 Total cash available 501 Less Disbursements: Salaries and benefits 369 Office expenses 97 Equipment purchases & maintenance 4 12 Specific assistance 28 18 Total disbursements Excess (deficiency) of cash available over disbursements (64) Financing Borrowings from endowment fund Repayments (21) Total financing effects Cash balance, ending 98 52 1,767 323 24 76 4 21 120 139 Required 2 Required 3 Determine the amount that the agency will owe the endowment fund at year-end. Amount owed to endowment fund

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Her Majestys Auditor An Adventure Novel With Steampunk Elements

Authors: Markus Pfeiler

1st Edition

164953339X, 978-1649533395

More Books

Students also viewed these Accounting questions

Question

Write formal proposal requests.

Answered: 1 week ago

Question

Write an effective news release.

Answered: 1 week ago

Question

Identify the different types of proposals.

Answered: 1 week ago