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 $8,000. If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $8,000 minimum. It is anticipated that the year will begin with an $11,000 cash balance. Contract revenue is received evenly during the year. Mental health income is expected to grow by $5,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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

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 $8,000.
  • If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $8,000 minimum.
  • It is anticipated that the year will begin with an $11,000 cash balance.
  • Contract revenue is received evenly during the year.
  • Mental health income is expected to grow by $5,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.

 

 

 

Cash balance, beginning
Receipts:
Grants
Contracts
Mental health income
Charitable donations
Total cash available
Less Disbursements:
Salaries and benefits
Office expenses
Equipment purchases & maintenance
Specific assistance
Total disbursements
Excess (deficit) of cash available over disbursements
Financing:
Borrowings from endowment fund
Repayments
TRI-COUNTY SOCIAL SERVICE AGENCY
Quarterly and Annual Cash Budget (in thousands)
Quarters
Total financing effects
Cash balance, ending
I
11 $
80
20
250
70
2
20
(46)
||
8
70
473
342
4
15
(39)
$
CA
8
200
333
71
6
18
112
$
GA
IV
8 $
400
50
112
Year
11
300
80
105
1,365
256
17
73
Transcribed Image Text:Cash balance, beginning Receipts: Grants Contracts Mental health income Charitable donations Total cash available Less Disbursements: Salaries and benefits Office expenses Equipment purchases & maintenance Specific assistance Total disbursements Excess (deficit) of cash available over disbursements Financing: Borrowings from endowment fund Repayments TRI-COUNTY SOCIAL SERVICE AGENCY Quarterly and Annual Cash Budget (in thousands) Quarters Total financing effects Cash balance, ending I 11 $ 80 20 250 70 2 20 (46) || 8 70 473 342 4 15 (39) $ CA 8 200 333 71 6 18 112 $ GA IV 8 $ 400 50 112 Year 11 300 80 105 1,365 256 17 73
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education