1. Using the T-accounts template, set up the T-accounts with the balances from the Balance Sheet...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Bank Accounts Receivable - Infield Flyers - Remdal Red Sox Supplies Equipment Liabilities $ 56 450 Accounts Payable - Cannon Sports 3 300 Ewert Equipment 1500 - Sandhu Sporting Goods 13 500 Bank Loan 52 000 Total Liabilities Total Assets Transactions for December: Owner's Equity $ 20 000 32 000 2 500 45 000 99 500 B. Birch, Capital 27 250 $126 750 Total liabilities and Owner's Equity $126 750 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. ASSETS Bank A/R - Infield Flyers A/R - Remdal Red Sox Supplies Equipment LIABILITIES A/P Cannon Sports OWNER'S EQUITY B. Birch, Capital A/P - Ewert Equipment A/P - Sandhu Sporting Goods Bank Loan Account Bonnie's Batting Cages and Softball Services Trial Balance December 31. 2015 DR CR Assets Bank Accounts Receivable Infield Flyers Remdal Red Sox Supplies Equipment Total Assets Bonnie's Batting Cages and Softball Services BALANCE SHEET December 31, 2015 Liabilities Accounts Payable Cannon Sports Ewert Equipment Sandhu Sporting Goods Bank Loan Total liabilities Owner's Equity B. Birch, Capital Total liabilities and Equity 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 Bank Accounts Receivable - Infield Flyers - Remdal Red Sox Supplies Equipment Liabilities $ 56 450 Accounts Payable - Cannon Sports 3 300 Ewert Equipment 1500 - Sandhu Sporting Goods 13 500 Bank Loan 52 000 Total Liabilities Total Assets Transactions for December: Owner's Equity $ 20 000 32 000 2 500 45 000 99 500 B. Birch, Capital 27 250 $126 750 Total liabilities and Owner's Equity $126 750 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. ASSETS Bank A/R - Infield Flyers A/R - Remdal Red Sox Supplies Equipment LIABILITIES A/P Cannon Sports OWNER'S EQUITY B. Birch, Capital A/P - Ewert Equipment A/P - Sandhu Sporting Goods Bank Loan Account Bonnie's Batting Cages and Softball Services Trial Balance December 31. 2015 DR CR Assets Bank Accounts Receivable Infield Flyers Remdal Red Sox Supplies Equipment Total Assets Bonnie's Batting Cages and Softball Services BALANCE SHEET December 31, 2015 Liabilities Accounts Payable Cannon Sports Ewert Equipment Sandhu Sporting Goods Bank Loan Total liabilities Owner's Equity B. Birch, Capital Total liabilities and Equity
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Swift - iOS Xcode 9.4 Write a function that: - takes in an array of integers and separates each element ofthe array into odd and even numbers - then splits the array into lists that are sorted in...
-
(a) What are the stereochemical relationships among the three conformations of meso-2,3- butanediol (the compound discussed in Sec. 6.7)? (b) Explain why meso-2,3-butanediol is a chiral even though...
-
Which of (x) = x sin 2 x and g(x) = x 2 sin 2 x has a larger average value over [0, 1]? Over [1, 2]?
-
Prepare an income statement and a balance sheet for Lippo Group from the following scrambled list of items. What is the firms net working capital and debt ratio? In addition, the firm has 12,000...
-
The balance sheets of Hutter Amalgamated are shown below. If the 12/31/2004 value of operations is $756 million, what is the 12/31/2004 value of equity? Balance Sheets, December 31, 2004 (Millions of...
-
Question 2) Suppose there were an alternative replacement machine that could do the same job as the new stamping machine under your consideration in Question 1. The alternate choice offers the...
-
A camera tripod is set up as shown below. The tripod is pretty fancy and has self-balancing legs. The camera weighs 32 N. Felicia Filmmaker has positioned the tripod as follows: XA = -6 m YA = 0 m ZA...
-
Will free trade and perfect competition lead to an equalization of wage rate internationally? Explain. Why would the wage rate greatly vary between developed and developing countries, in the same...
-
Which of the following countries would you expect to have intertemporal production possibilities, biased toward current consumption goods, and which would be biased toward future consumption goods?...
-
You are auditing Hawthorne Industries. The preliminary risk assessment resulted in a high potential for fraud given the number of offices it has across Canada and the high volume of travel-related...
-
Assume that the interest rate on a 1-year T-bond is currently 7% and the rate on a 2-year bond is 9%. If the maturity risk premium is zero, what is a reasonable forecast of the rate on a 1-year bond...
-
Tamara and Tony Mapp, a married couple, report the following items for the year: What is their alternative minimum tax for the year? Taxable income AMT adjustments Tax preferences Regular tax...
-
What Are the Criticisms of Parole & Probation?
-
The Higher the time period of the financial security the higher the. ............... risk. O a. Maturity O b. Default and Maturity Oc. Default O d. Liquidity
-
How far above Farth's surface must a \(10,000-\mathrm{kg}\) boulder be moved to increase the mass of the Earthboulder system by \(2.50 \mathrm{mg}\) ? Assume the same ratio of energy change to mass...
-
Is an oscillating object in translational equilibrium?
-
Show that for small displacements the restoring force exerted on part 2 of the displaced string in Figure 15.14 is linearly proportional to the displacement of that part from its equilibrium...
Study smarter with the SolutionInn App