1. Using the T-accounts template, 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. Bonnie's Batting Cages and Softball Services BALANCE SHEET November 30, 2015 Assets Liabilities Bank $ 56 450 Accounts Payable - Cannon Sports - Ewert Equipment $ 20 000 Accounts Receivable 3 300 - Infield Flyers 32 000 1 500 - Remdal Red Sox 2 500 - Sandhu Sporting Goods 13 500 45 000 Bank Loan Supplies Equipment $99 500 Total Liabilities 52 000 Owner's Equity B. Birch, Capital Total liabilities and Owner's Equity 27 250 $126 750 Total Assets $126 750 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