In: Accounting
XYZ Football Club is a small professional football team owned by Singh Corporation. | ||||||||||
On the worksheet tab are the November 30, 2019, account balances of XYZ Football as of | ||||||||||
November 30, 2019. The revenue and expense account balances represent the results | ||||||||||
of transactions recorded during the first 11 months of 2018. XYZ currently has 7,000 shares of | ||||||||||
stock. All income tax effects are to be ignored for this project. | ||||||||||
On November 30, 2019, XYZ Football ledger showed the following accounts: cash $238,000, | ||||||||||
concessions inventory $10,200, supplies inventory $8,200, prepaid stadium rental $12,800, | ||||||||||
equipment $250,000, accumulated depreciation - equipment $117,200, building $400,000, | ||||||||||
accumulated depreciation - building $115,500, accounts payable $20,220, wages payable $0, | ||||||||||
utilities payable $0, interest payable $0, unearned admission revenue $3,300, long-term notes | ||||||||||
payable $43,000, common stock ($10 par value per share) $70,000, | ||||||||||
Retained earnings at 1/1/19 $280,860, dividends $0, admission revenue $512,600, concessions | ||||||||||
revenue $528,650, wages expense $430,200, stadium rental expense $187,000, concessions | ||||||||||
expense $118,230, supplies expense $0, utilities expense $16,600, advertising expense $6,300, | ||||||||||
maintenance expense $13,800, depreciation expense - equipment $0, depreciation | ||||||||||
expense - building $0, interest expense $0. | ||||||||||
Instructions: | ||||||||||
1. Prepare the three basic financial statements; income statement, statement of retained earnings, | ||||||||||
and balance sheet. | ||||||||||
December Transactions | ||||||||||
Dec. | 5 | Paid accounts payable of $4,950. | ||||||||
6 | Paid stadium rental of $8,500 in advance. | |||||||||
6 | Purchased supplies, $720, on account. | |||||||||
7 | Deposited $16,000 of admissions receipts. | |||||||||
9 | Unearned admissions revenue is for gift certificates purchased for admission into future | |||||||||
shows. $480 more of these gift certificates were sold to a local restaurant business, for cash. | ||||||||||
10 | Purchased $2,150 of concessions items on credit. | |||||||||
12 | Acquired additional equipment worth $34,000 by paying $500 cash and giving a long-term | |||||||||
note payable for the balance. | ||||||||||
14 | Paid wages of $14,200 for the period December 1 through 14. | |||||||||
16 | Paid for the supplies purchased on December 6. | |||||||||
17 | Purchased $1,800 of supplies on credit. | |||||||||
19 | Sold 600 shares of $10 par value common stock for $10 a share. | |||||||||
21 | Deposited $22,750 from concessions sales and $10,660 of admissions receipts. | |||||||||
24 | Paid $1,600 for repairs to roof for weather damage. | |||||||||
25 | Purchased $8,200 of concessions items on account. | |||||||||
27 | Paid for the supplies purchased on December 17. | |||||||||
28 | Paid wages of $17,720 for the period December 15 through 28. | |||||||||
30 | Paid $2,500 to the newspaper for advertisements that appeared in December. | |||||||||
31 | Deposited $23,000 for admissions receipts and $17,850 from concessions sales. | |||||||||
31 | Declared and paid the annual dividend, amounting to $7,600. | |||||||||
XYZ Football Club | ||
Income Statement | ||
for the period ended November 30, 2019 | ||
Revenues | ||
Admission Revenue | $512,600 | |
Concessions Revenue | $528,650 | |
Total Revenues | $1,041,250 | |
Expenses | ||
Wages Expense | $430,200 | |
Stadium Rental Expense | $187,000 | |
Concessions Expense | $118,230 | |
Supplies Expense | $0 | |
Utilities Expense | $16,600 | |
Advertising Expense | $6,300 | |
Maintenance Expense | $13,800 | |
Depreciation Expense - Equipment | $0 | |
Depreciation Expense - Building | $0 | |
Interest Expense | $0 | |
Total Expenses | $772,130 | |
Net Income | $269,120 | |
XYZ Football Club | ||
Statement of Retained Earnings | ||
for the period ended November 30, 2019 | ||
Retained Earnings as at 1/1/19 | $280,860 | |
Add: Net Income | $269,120 | |
Less: Dividend | $0 | |
Retained Earnings as at 30/11/19 | $549,980 | |
XYZ Football Club | ||
Balance Sheet | ||
as at November 30, 2019 | ||
Assets | ||
Current Assets | ||
Cash | $238,000 | |
Concessions Inventory | $10,200 | |
Supplies Inventory | $8,200 | |
Prepaid Stadium Rental | $12,800 | |
Total Current Assets | $269,200 | |
Non-Current Assets | ||
Equipment | $250,000 | |
Less: Accumulated Depreciation - Equipment | ($117,200) | |
$132,800 | ||
Building | $400,000 | |
Less: Accumulated Depreciation - Building | ($115,500) | |
$284,500 | ||
Total Assets | $686,500 | |
Liabilities and Stockholders' Equity | ||
Liabilities | ||
Current Liabilities | ||
Accounts Payable | $20,220 | |
Wages Payable | $0 | |
Utilities Payable | $0 | |
Interest Payable | $0 | |
Unearned Admission Revenue | $3,300 | |
$23,520 | ||
Non-Current Liabilities | ||
Long-term Notes Payable | $43,000 | |
$43,000 | ||
Stockholders' Equity | ||
Common Stock | $70,000 | |
Retained Earnings | $549,980 | |
Total Stockholders' Equity | $619,980 | |
Total Liabilities and Stockholders' Equity | $686,500 |