50.1K

Verified Solution

Link Copied!

We need to fill all the transactions in the excel sheet I have attached

Assignment 1 - Transaction Analysis Drop Box Complete the following assignment and submit your work to the dropbox. Download and complete a Transaction Analysis Sheet for the Giants Softball Company for the transactions below. When the Transaction Analysis Sheet is finished, complete an updated Balance Sheet (for December 31, 20XX) using the balances obtained after the transactions have been verified. You will also need to use the Balance Sheet template to complete this assignment. You can find it in Activity 3. The Asset accounts will include: cash, accounts receivable, computer, supplies, equipment, and truck. The Liability accounts will include: accounts payable. The Owner's Equity account will include Manning, Capital. Here are the transactions: E. Manning invests $6,000 into the Giants Softball Company. The owner buys the business a new computer (valued at $1,200) with the company's money. Supplies costing $950 are purchased for cash from the Sport Store. A set of bats (Sporting Equipment) is purchased from Bats 'N' Gloves for $3,000 cash. A tournament is set up by the Giants Softball Company. For this service, the company receives $15,000 cash now and the remaining $15,000 later. Giants Softball Company purchases a new batting cage from Sport Store valued at $8,000. Giants Softball Company gives a cash down payment of $4,000 and the remainder of the balance is to be paid at a later date. Giants Softball Company buys a truck for $10,000 cash. Giants Softball receives the remaining $15,000 owed to them (see previous transaction). Giants Softball pays the $4,000 owed on the batting cage (see previous transaction). G H L M N NAME OF BUSINESS TRANSACTION SHEET LABILITIES OIE CAPITAL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 B D 1 2 3 ASSETS 4 DATE CASH 5 BEG BAL 6 7 NEWB 0.00 0.00 0.00 8 9 NEWB 0.00 0.00 0.00 10 11 NEWB 0.00 0.00 0.00 12 13 NEW B 0.00 0.00 0.00 14 15 NEWB 0.00 0.00 0.00 16 17 NEWB 0.00 0.00 0.00 18 19 NEWS 0.00 0.00 0.00 RO 21 NEWS 0.00 0.00 0.00 22 23 NEWB 0.00 0.00 0.00 24 25 NEWB 0.00 0.00 0.00 26 27 NEWB 0.00 0.00 0.00 28 29 TOTAL ASSETS 30 TOTAL L & OIE 31 32 33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 35 36 37 38 39 10 1 2 23 Assignment 1 - Transaction Analysis Drop Box Complete the following assignment and submit your work to the dropbox. Download and complete a Transaction Analysis Sheet for the Giants Softball Company for the transactions below. When the Transaction Analysis Sheet is finished, complete an updated Balance Sheet (for December 31, 20XX) using the balances obtained after the transactions have been verified. You will also need to use the Balance Sheet template to complete this assignment. You can find it in Activity 3. The Asset accounts will include: cash, accounts receivable, computer, supplies, equipment, and truck. The Liability accounts will include: accounts payable. The Owner's Equity account will include Manning, Capital. Here are the transactions: E. Manning invests $6,000 into the Giants Softball Company. The owner buys the business a new computer (valued at $1,200) with the company's money. Supplies costing $950 are purchased for cash from the Sport Store. A set of bats (Sporting Equipment) is purchased from Bats 'N' Gloves for $3,000 cash. A tournament is set up by the Giants Softball Company. For this service, the company receives $15,000 cash now and the remaining $15,000 later. Giants Softball Company purchases a new batting cage from Sport Store valued at $8,000. Giants Softball Company gives a cash down payment of $4,000 and the remainder of the balance is to be paid at a later date. Giants Softball Company buys a truck for $10,000 cash. Giants Softball receives the remaining $15,000 owed to them (see previous transaction). Giants Softball pays the $4,000 owed on the batting cage (see previous transaction). G H L M N NAME OF BUSINESS TRANSACTION SHEET LABILITIES OIE CAPITAL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 B D 1 2 3 ASSETS 4 DATE CASH 5 BEG BAL 6 7 NEWB 0.00 0.00 0.00 8 9 NEWB 0.00 0.00 0.00 10 11 NEWB 0.00 0.00 0.00 12 13 NEW B 0.00 0.00 0.00 14 15 NEWB 0.00 0.00 0.00 16 17 NEWB 0.00 0.00 0.00 18 19 NEWS 0.00 0.00 0.00 RO 21 NEWS 0.00 0.00 0.00 22 23 NEWB 0.00 0.00 0.00 24 25 NEWB 0.00 0.00 0.00 26 27 NEWB 0.00 0.00 0.00 28 29 TOTAL ASSETS 30 TOTAL L & OIE 31 32 33 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 35 36 37 38 39 10 1 2 23

Answer & Explanation Solved by verified expert

See Answer