Please don't give image format Cash balance, beginningReceiptsGrants-ContractsMental health incomeCharitable donationsTotal cash availableLess DisbursementsSalaries and benefits.Office expensesEquipment purchases & maintenanceSpecific assistanceTotal disbursementsExcess (deficiency) of cash available over disbursementsFinancingBorrowings from endowment fundRepaymentsTotal financing effectsCash balance, endingShow Transcribed Text$Required 3118Amount owed to endowment fund75< Required 252480102322(65)11Complete this question by entering your answers in the tabs below.96561384Required: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.716(36)III290436Required 3 >85918113IV51072145• The Board of Trustees requires that Tri-County maintain a minimum cash balance of $15.• If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $15 minimum.. It is anticipated that the year will begin with an $18 cash balance.• Contract revenue is received evenly during the year.• Mental health income is expected to grow by $4 in the second and third quarters; no change is expected in the fourth quartRequired 2Determine the amount that the agency will owe the endowment fund at year-end. (Enter your answer in thousands.)$Year182531202281,8003622786 Tri-County Social Service Agency is a not-for-profit organization in the Midwest. Use the following information to complete the cashbudget for the year ending December 31.The Board of Trustees requires that Tri-County maintain a minimum cash balance of $15.If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $15 minimum.It is anticipated that the year will begin with an $18 cash balance.• Contract revenue is received evenly during the year.• Mental health income is expected to grow by $4 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 3Complete the cash budget for each quarter and the year as a whole. (Cash deficiency and repayments should be indicated by a minussign. Enter your answers in thousands.)Cash balance, beginningCash Budget for Tri-County Social Service Agency(in thousands)$1811QuartersIIIMEIV$Year18

Cash Budget refers to the statement which is an estimation of the cash related transaction of a…

Less Disbursements 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 Show Transcribed Text 2 102 3 22 (65) C < Required 2 384 7 16 Complete this question by entering your answers in the tabs below. (36) 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. 85 9 18 113 The Board of Trustees requires that Tri-County maintain a minimum cash balance of $15. • If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $15 minimum. 72 . It is anticipated that the year will begin with an $18 cash balance. . Contract revenue is received evenly during the year. • Mental health income is expected to grow by $4 in the second and third quarters; no change is expected in the fourth quart Required 3 145 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 1,800 362 27 86

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q