Bonnie's Batting Cages and Softball Services
	BALANCE SHEET
	December 31, 2015
	Assets			Liabilities
	Bank			Accounts Payable
	Accounts Receivable			Cannon Sports
	Infield Flyers			Ewert Equipment
	Remdal Red Sox			Sandhu Sporting Goods
	Supplies			Bank Loan
	Equipment			Total liabilities
				Owner's Equity
				B. Birch, Capital
	Total Assets	$0.00		Total liabilities and Equity	$0.00
	hint total assets = 248600

Assets Bank Accounts Receivable - Infield Flyers - Remdal Red Sox Supplies Equipment Total Assets Bonnie's Batting Cages and Softball Services BALANCE SHEET November 30, 2015 $ 56 450 3 300 1 500 13 500 52 000 $126 750 Liabilities Accounts Payable - Cannon Sports - Ewert Equipment - Sandhu Sporting Goods Bank Loan Total Liabilities Owner's Equity. B. Birch, Capital Total liabilities and Owner's Equity $ 20 000 32 000 2 500 45 000 $99 500 27 250 $126 750 1. Using the T-accounts Template U2A5 set up the T-accounts with the balances from the Balance Sheet below. 2. Input the transactions below into each account. Do not add the transaction reference number. 3. Calculate the balance of each account at the end of the December transactions. Use the function feature of your spreadsheet. 4. Create a trial balance to make sure your debits = credits. Use the template provided in the 2nd tab in the spreadsheet. 5. Create a new Balance Sheet dated December 31, 2015. Use the template provided in the 3rd tab in the spreadsheet. Transactions for December: 1. B. Birch, the owner, invested $40 000 in the business. 2. Borrowed $45 000 from the bank, which was deposited in the business' bank account. 3. Paid $7 500 to Turtle Dove Properties Ltd. for the monthly rent. 4. Purchased office and various sport supplies for $6 000 cash. 5. Purchased $13 000 worth of bats, helmets, and other sports equipment from Cannon Sports on account. The amount is due in 30 days. 6. Bought pitching machines from Ewert Equipment for $12 000 on account and have 30 days to pay. 7. Bought $8 800 of miscellaneous sports supplies on account from Sandhu Sporting Goods. 8. Sold a one month team membership to the Infield Flyers for $1 300 on account. The amount is to be received in 15 days. 9. Sold a two-month team membership to the Remdal Red Sox for $2 600 on account. The bill is due in 30 days. 10. Cash sales for the month amounted to $7 200. 11. Bank charges for services fees and interest amounted to $550, which was taken directly out of the business' bank account