Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer #2 & #3 below in an Excel Spreadsheet. Using the fact scenario below, please respond in Excel to the following exercises: 2. Prepare

Please answer #2 & #3 below in an Excel Spreadsheet.

image text in transcribed

Using the fact scenario below, please respond in Excel to the following exercises: 2. Prepare the journal entries to record revenues and disbursements if the city treats the program as an enterprise fund. 3. Prepare the journal entries to record revenues and disbursements if the city treats the program as a special revenue fund. Facts: The City of Duluth teamed with a professional football franchise to offer one day "Learn to Play Football" clinics for kids during the summer. The City provided the Town Green as a location, and the franchise covered all costs. 1,500 kids registered for the Duluth clinics during 2018. The franchise contributed upfront $100 per registered child to the city to cover expenses. Each child attending received a replica jersey of the team. The city also had a four-year loan from the bank for $24,000 at a 7% interest rate. Cash disbursements occurred for wages of clinic workers and on-site medical staff in the amount of $31,000, advertising and promotional items $40,000, payroll taxes $9,300, insurance $10,000, equipment rentals $12,800, interest on banknote paid semi-annually $840, landscaping repairs and clean up services $6,700, refreshments, $20,400, and parking for volunteers $2,300. All disbursements occurred at year end except $5,000 of wages and $1,500 of payroll taxes. Using the fact scenario below, please respond in Excel to the following exercises: 2. Prepare the journal entries to record revenues and disbursements if the city treats the program as an enterprise fund. 3. Prepare the journal entries to record revenues and disbursements if the city treats the program as a special revenue fund. Facts: The City of Duluth teamed with a professional football franchise to offer one day "Learn to Play Football" clinics for kids during the summer. The City provided the Town Green as a location, and the franchise covered all costs. 1,500 kids registered for the Duluth clinics during 2018. The franchise contributed upfront $100 per registered child to the city to cover expenses. Each child attending received a replica jersey of the team. The city also had a four-year loan from the bank for $24,000 at a 7% interest rate. Cash disbursements occurred for wages of clinic workers and on-site medical staff in the amount of $31,000, advertising and promotional items $40,000, payroll taxes $9,300, insurance $10,000, equipment rentals $12,800, interest on banknote paid semi-annually $840, landscaping repairs and clean up services $6,700, refreshments, $20,400, and parking for volunteers $2,300. All disbursements occurred at year end except $5,000 of wages and $1,500 of payroll taxes

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Libby, Patricia Libby, Frank Hodge

11th Edition

1264229739, 9781264229734

More Books

Students also viewed these Accounting questions

Question

1. Maintain my own perspective and my opinions

Answered: 1 week ago

Question

2. What do the others in the network want to achieve?

Answered: 1 week ago