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

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the a

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the assignment requirements. Note: P1 below is the abbreviation for Part 1 of the TechWear Case Study Assignment. The same abbreviation pertains for subsequent Modules, too.  TechWear Case Study Parts I

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the a

Critical Thinking Assignment (75 Points)Important! Read First Complete the Critical Thinking Assignment. Review the rubric to confirm you are meeting the assignment requirements. Note: P1 below is the abbreviation for Part 1 of the TechWear Case Study Assignment. The same abbreviation pertains for subsequent Modules, too.  TechWear Case Study Parts I

Assignment Type: Essay (any type) Service: Writing Words: 3 pages / 800 words (Double spacing) Education Level: Undergraduate Language: English

Assignment Type: Essay (any type) Service: Writing Words: 3 pages / 800 words (Double spacing) Education Level: Undergraduate Language: English (US)  Assignment Topic: Accounting Tools and Techniques Subject: Accounting  Sources: 4 sources required Citation Style: APA 6th edition Instructions: How does managerial accounting contribute to strategic decision-making in modern organizations, and why is

Title: Exploring Global Inequality through the Dollar Street Project. Word Count: The essay to consists of approximately 1,900-2,100 words. Formatting

Title: Exploring Global Inequality through the Dollar Street Project. Word Count: The essay to consists of approximately 1,900-2,100 words. Formatting Style: Font and Size: Times New Roman, 12-point font Headings and Subheadings: Bold for headings (e.g., Introduction, Visual and Quantitative Analysis, Socioeconomic Analysis, Conclusion) and italicized for subheadings (e.g., Low-Income

English literature paragraph: Write a 250-word response to the week’s reading prompt: Set on a foreign planet inhabited by insect-like beings, “Bloodchild”

English literature paragraph: Write a 250-word response to the week’s reading prompt: Set on a foreign planet inhabited by insect-like beings, “Bloodchild” is a coming-of-age story, raising provocative questions about sex roles, self-sacrifice, colonization, and species- interdependence. How does this theme of the coming-of-age story function throughout the short story?

Academic Counseling  Assessment Desuсrіption: Educational institutions are evaluated on student outcomes, especially academic achievement. As such, school

Academic Counseling  Assessment Desuсrіption: Educational institutions are evaluated on student outcomes, especially academic achievement. As such, school counselors are tasked with supporting students in the area of academic development through the enhancement of knowledge, skills, and attitudes. The school counselor’s role in academic development focuses on fostering safe and inclusive learning

Wk 1 Environmental Disaster Memo Guide Use the following instructions to help you complete the Wk 1 – Summative Assessment: Environmental Disaster

Wk 1 Environmental Disaster Memo Guide Use the following instructions to help you complete the Wk 1 – Summative Assessment: Environmental Disaster Memo. Instructions Read “Environmental Disasters” from the University Library.   Choose1 environmental incident from “Environmental Disasters.”   Researchthe environmental incident you selected. ·         Find at least 5 additional resources related