Cash Distribution Exercise Complete the following cash distribution exercise. You are the executive director of a commun

[answerhappygod]

Cash Distribution Exercise Complete The Following Cash Distribution Exercise You Are The Executive Director Of A Commun 1 (692.95 KiB) Viewed 62 times

Cash Distribution Exercise Complete the following cash distribution exercise. You are the executive director of a community health agency in Arizona. Your operation is funded through a combination of cash contributions, federal government grants and city contracts. Your revenue budget for fiscal year is as shown in the table below. You know from past experience that not all of your revenue and support is collected when you earn it. Community Health Agency Cash Revenue Budget Source of Revenue 01 Q2 03 04 Cash Contributions $25,000 $35,000 $35,000 $50,000 Federal Grants $250,000 $375,000 $350,000 $250,000 City Contracts $240,000 $300,000 $320,000 $360,000 Total $515,000 $710,000 $705,000 $660,000 Community Cash Collection Scenario: . 1. Cash contributions are collected in the same quarter they are pledged. 2. Federal government grants are collected in the very next quarter after you send the granting agency a bill. 3. City contracts are collected as follows: 25% of the total amount owed is paid in the very next quarter after you send the bill. An additional 25% is collected two quarters after you send the bill. The remaining fifty-percent is paid three quarters after you send in the bill. 4. Starting with the revenue budget above, calculate and summarize in words the amount you can expect to collect in the fourth quarter. (Note: do not report total collections, only 4” qtr. collections) 5. Please check your work with the posted solution before submitting your assignment. th . Before submitting this assignment, please review the File titled "Example of Explaining Calculations and Context of Course Problems" to see how to document your work. Complete and submit your completed budget as an Excel file. To receive full credit for this assignment you must show and describe your work and summarize your findings.