darwin X B Jack and the X Ashwa Jamax Astra Jamax Sie.com/document/d/10PC_DOZIO-XSQTML.02XQTXrm.nl . Ook150errm7nPs4/edit Connie's Batting Cages Assignment and Rubric o cert Format Tools Add-ons Help Last edit was 2 days ago 12 + BIVA Normal text Artal .= = 1. Using the T-accounts template that has been provided for you, 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, 2020. Use the template provided in the 3 tab in the spreadsheet com/document/d/10PcC_Dozio-XSMU nie's Batting Cages Assignment and Rubric # 1 Format Tools Add-ons Help Last edit was 2 days ago HD . E w 12 + Arial Normal text BIVA 5 67 1 2 314 Transactions for December 2020 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. DOLL ument/d/10PCC DOzfo-XSqrM02XQTXrmmt. Ook1 50errm7nP54/edit atting Cages Assignment and Rubrico t Tools Add-ons Help Last edit was 2 days ago nal text A Arial 12 + G D - EE 2 5 6 3M Unit 2 Balance Sheet & Transactions T-Accounts, Trial Balance, Balance Sheet 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 DOLL mat Tools Add-ons Help Last edit was 2 days ago formal text Arial - 12 + - 19 E- - 2 3 5 co - Bonnie's Barung cages ana sondan Services BALANCE SHEET November 30,2020 Assets Llabilities Bank $ 56 450 Accounts Payable - Cannon Sports Accounts Receivable $ 20 000 3 300 32 000 Ewert Equipment Sandhu Sporting Goods 1 500 2 500 - Infield Flyers Remdal Red Sox Supplies Equipment 13 500 Bank Loan 45 000 52 000 Total Liabilities $99 500 Owner's Equity 27 250 B. Birch, Capital Total liabilities and Owner's Equity Total Assets $126 750 $126 750 DOLL c % 7 100% Arial * . .00 123 10 + BISA A21 fx B c D E F G H K 1 2 ASSETS Bank LIABILITIES OWNER'S EQUITY 3 4 A/P - Cannon Sports B. Birch, Capital 5 6 7 g 10 AJP - Ewert Equipment 12 A/R - Infield Flyers AJR - Remdal Red Sox VP - Sandhu Sporting Goods 14 15 16 17 18 19 20 Supplies Equipment Bank Loan 22 23 24 + E T accounts Trial Balance Balance Sheet O 100% S Arial 10 % 0.00 123- BIS F A B D E F G H Bonnie's Batting Cages and Softball Services Trial Balance December 31, 2015 Account DR CR IN T accounts Trial Balance Balance Sheet - D E F G H 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 Birch, Capital Total Assets Total liabilities and Equity IN T accounts - Trial Balance Balance Sheet O darwin X B Jack and the X Ashwa Jamax Astra Jamax Sie.com/document/d/10PC_DOZIO-XSQTML.02XQTXrm.nl . Ook150errm7nPs4/edit Connie's Batting Cages Assignment and Rubric o cert Format Tools Add-ons Help Last edit was 2 days ago 12 + BIVA Normal text Artal .= = 1. Using the T-accounts template that has been provided for you, 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, 2020. Use the template provided in the 3 tab in the spreadsheet com/document/d/10PcC_Dozio-XSMU nie's Batting Cages Assignment and Rubric # 1 Format Tools Add-ons Help Last edit was 2 days ago HD . E w 12 + Arial Normal text BIVA 5 67 1 2 314 Transactions for December 2020 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. DOLL ument/d/10PCC DOzfo-XSqrM02XQTXrmmt. Ook1 50errm7nP54/edit atting Cages Assignment and Rubrico t Tools Add-ons Help Last edit was 2 days ago nal text A Arial 12 + G D - EE 2 5 6 3M Unit 2 Balance Sheet & Transactions T-Accounts, Trial Balance, Balance Sheet 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 DOLL mat Tools Add-ons Help Last edit was 2 days ago formal text Arial - 12 + - 19 E- - 2 3 5 co - Bonnie's Barung cages ana sondan Services BALANCE SHEET November 30,2020 Assets Llabilities Bank $ 56 450 Accounts Payable - Cannon Sports Accounts Receivable $ 20 000 3 300 32 000 Ewert Equipment Sandhu Sporting Goods 1 500 2 500 - Infield Flyers Remdal Red Sox Supplies Equipment 13 500 Bank Loan 45 000 52 000 Total Liabilities $99 500 Owner's Equity 27 250 B. Birch, Capital Total liabilities and Owner's Equity Total Assets $126 750 $126 750 DOLL c % 7 100% Arial * . .00 123 10 + BISA A21 fx B c D E F G H K 1 2 ASSETS Bank LIABILITIES OWNER'S EQUITY 3 4 A/P - Cannon Sports B. Birch, Capital 5 6 7 g 10 AJP - Ewert Equipment 12 A/R - Infield Flyers AJR - Remdal Red Sox VP - Sandhu Sporting Goods 14 15 16 17 18 19 20 Supplies Equipment Bank Loan 22 23 24 + E T accounts Trial Balance Balance Sheet O 100% S Arial 10 % 0.00 123- BIS F A B D E F G H Bonnie's Batting Cages and Softball Services Trial Balance December 31, 2015 Account DR CR IN T accounts Trial Balance Balance Sheet - D E F G H 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 Birch, Capital Total Assets Total liabilities and Equity IN T accounts - Trial Balance Balance Sheet O