1. Using Excel recreate the Balance sheet given below. Make sure you have a tab for this called Balance Sheet November 30, 2020. Make sure that you are using formulas for all calculations. 2. Create another sheet with a T-accounts tab (using the accounts below), set up with the accounts and initial balances from the Balance Sheet below. 3. Using the T-accounts worksheet, input the following 10 transactions into each account. Calculate the balance of each account. 4. Prepare a trial balance worksheet December 31, 2020 based on your account balances from the ledger (Don't forget to also create a 3rd worksheet tab. Jim's Batting Cages and Softball Services BALANCE SHEET November 30, 2020 Assets Liabilities Bank $ 66 000 $ 20 000 Accounts Receivable 3 300 Accounts Payable - Cannon Sports - Ewert Equipment - Sandhu Sporting Goods Bank Loan Infield Flyers - Remdal Red Sox 32 000 1 500 2 500 13 500 45 000 Supplies Equipment 52 000 Total Liabilities $99 500 Owner's Equity J. Jakusz, Capital 36 800 Total liabilities and Owner's Equity $136 300 Total Assets $136 300 Chart of Accounts Jim's Batting Cages and Softball Services Account number Account Account number 105 Bank 305 110 310 115 405 120 410 Account J. Jakusz, Capital J. Jakusz, Drawings Membership Fees Cash Sales Bank Charges Expense Heating Expense Rent Expense Repair Expense Wages Expense A/R - Infield Flyers A/R - Remdal Red Sox Supplies Equipment A/P - Cannon Sports A/P - Ewert Equipment A/P - Sandhu Sporting Goods 125 505 205 510 210 515 215 520 220 Bank Loan 525 Transactions for December 1. Jim Jakusz, the owner, invested $140 000 in the business. 2. Borrowed $15 000 from the bank, which was deposited in the business' bank account. 3. Paid $500 to Romeyn Properties Ltd. for the monthly rent. 4. Bought office and various sport supplies for $2 500 cash. 5. Purchased $3 000 worth of bats, helmets, and other sports equipment from Cannon Sports on account. The amount is due in 30 days. 6. Paid $800 cash for the heating bill received today. 7. Bought pitching machines from Ewert Equipment for $12 000 and have 30 days in which to pay 8. Equipment was repaired ($50) from Ewert Equipment and will be paid for later. 9. Bought $800 of miscellaneous sports supplies on account from Sandhu Sporting Goods. 10. Owner withdrew $1 000 for personal use