PRICE FOR BOTH PARTS PLEASE! Custodial Fund Accounting You will have 2 deliverables for this assignment: (1) Part A: Excel Spreadsheet and (2) Part B: a 2-3 slide presentation. Part A: The Snowflake

PRICE FOR BOTH PARTS PLEASE! 

Custodial Fund Accounting

You will have 2 deliverables for this assignment: (1) Part A: Excel Spreadsheet and (2) Part B: a 2-3 slide presentation.

Part A:

The Snowflake County tax collector is responsible for collecting all property taxes levied by funds and governments within the boundaries of the county. The tax collector deducts 1.5 percent from the collections for the other entities to reimburse the county for estimated administrative expenses associated with maintaining the custodial fund. The total amount deducted is added to the collections for the county and remitted to the Snowflake County General Fund.

1. Current year tax levies to be collected by the custodial fund were: Custodial Fund Tax LeviesAccountTax LeviesCounty General Fund$12,427,000Town of Ski Slope General Fund4,960,000Snowflake County Consolidated School District7,150,000Other towns3,240,000$27,777,000
2. The tax collector collected $14,800,000 during the first half of the year.
3. Liabilities to all funds and governments because of the first half-year collections were recorded. (You will need to prepare a schedule of amounts collected for each participant, showing the amount withheld for the County General fund and net amounts due to participants to determine amounts to be recorded for this transaction.)
4. All cash in the custodial fund was distributed.
5. All additions and deductions were recorded by the custodial fund. Additions and deductions are aggregated because resources are held for less than three months.

Part A Deliverable:

• In an Excel Spreadsheet, prepare journal entries of each of the foregoing transactions that affected the tax custodial fund. Label each section clearly based on the numbered bullets above. Include computations in a table and show work.

Part B:

1. Although proprietary funds are often compared to for-profit organizations, there are several differences between financial reporting for proprietary funds and for-profit organizations. Identify and discuss differences between each of the proprietary fund financial statements and its corporate counterpart.
2. The Snowflake County Sheriff's Office maintains a fund to which it transfers the phone company commissions it earns on inmates' pay-phone calls. The monies collected are used to provide inmate amenities such as books, magazines, writing paper, and postage stamps. The resources of the fund are periodically transferred to the general fund, from which they are appropriated and expended. Should the fund be accounted for as a private-purpose trust fund (a fiduciary fund) or a government fund, such as a special revenue fund? Why?

Part B Deliverable:

• PowerPoint presentation of 2-3 slides, speaker notes, not counting the title and reference list pages.

Required:

• Ensure your responses are well-written.
• Include at least 2 credible references