Accounting Cycle ProjectTransaction Practice Set B&G MusicACC5100 - Winter 2017 - Prof Chung

You have been hired as an accountant for B&G Co., a corporation performing diverse consulting services in Detroit, Michigan. B&G Co. prepares financial statements on monthly bases.

Project Scope: You are to record the transactions for December, prepare the monthly adjustments, and prepare the financial statements using the Excel workbook provided. Then you will close the fiscal year and prepare the books for next year.

Directions: The assignment encompasses two files: Directions and Transactions (this Word document) and Forms (a separate Excel workbook). Your solution should be worked in Excel and the completed Excel workbook submitted for grading.

You should use Excel formula where appropriate and cell references to carry forward values and numbers between worksheets within the workbook. Simply typing values in Excel will result in a reduced score, even if the correct solution is provided. You should use formula wherever possible.

1.Analyze the narrative to prepare and record the transactions for December to the General Journal.

2.Post the journal entries to ledger accounts using T-accounts (Dont forget the opening balances from the information given on the post-closing trial balance on Nov. 30th.)

3.Prepare Income Statement and the Retained Earnings Statement for the month ended December 31, 2016 and Balance Sheet as of December 31, 2016 in good forms. Use the multi-step format for the Income Statement.

4.Close the temporary accounts, posting any net income or loss to retained earnings.

Due Date: Apr. 26th.

Transactions in December 2016:

Dec.

1

The equipment was completely destroyed by the regional earth quake. Loss by earthquake was recognized.

1

Lent cash to another company and received a 2 year, $20,000 zero-interest-bearing note. The market rate of interest for a note of similar risk is 8 percent.

1

Purchased new equipment that costs $12,000 and issued 1,000 shares of common stock (no-par stock) to the equipment seller.

3

Cash payment on accounts payable amounted to $6,000.

4

Sold land for $13,000 cash.

10

Collected $15,000 as payment for amounts previously billed (suppose the payment was made within the discount period).

13

One of the customers went bankrupt. B&G wrote off $2,000 account receivable.

15

Paid monthly salaries of $20,000 to employees

16

Issued 1,000 shares of preferred stock at $10 per share

17

Purchased 500 shares of ABC corporations common stock at $15 (per share) and classify the securities as available-for-sales securities

20

Found that the company incorrectly overstated its November account receivable and sales revenue by $1,000 and made a journal entry to correct the error.

29

Performed services for a customer for $30,000 cash

30

Performed $30,000 services on account with the following terms: 2/15, n/30. B&G records credit sales using the net method

31

Dividends of $5,000 were declared and paid. $ 1,025 is paid to preferred stockholders and the rest is paid to the common stock holders.

31

ABC corporation declared $ 5 dividend per share (to common stock holders). It will be paid in 2017.

* Additional information1.Ignore tax effect.2.Salaries expenses incurred but not paid prior to Dec. 31^st totaled $10,500.3.The company received the bill for utility services (electricity) that the firm used during December in the amount of $6,000. The company will pay the bill in Jan. 2016.4.$3,000 of supplies remained at the end of December.5.The company use the Allowance method for possible accounts receivable write-offs in the future and estimated that 4% of the outstanding account receivable will not be collected.6.The equipment purchased on Dec. 1^st depreciates $200 per month.7.The common stock price of ABC Corporation on December 31st is still $ 15 per share. Accounting Cycle Project Transaction Practice Set - B&G Music ACC5100 - Winter 2017 - Prof Chung You have been hired as an accountant for B&G Co., a corporation performing diverse consulting services in Detroit, Michigan. B&G Co. prepares financial statements on monthly bases. Project Scope: You are to record the transactions for December, prepare the monthly adjustments, and prepare the financial statements using the Excel workbook provided. Then you will close the fiscal year and prepare the books for next year. Directions: The assignment encompasses two files: Directions and Transactions (this Word document) and Forms (a separate Excel workbook). Your solution should be worked in Excel and the completed Excel workbook submitted for grading. You should use Excel formula where appropriate and cell references to carry forward values and numbers between worksheets within the workbook. Simply typing values in Excel will result in a reduced score, even if the correct solution is provided. You should use formula wherever possible. 1. Analyze the narrative to prepare and record the transactions for December to the General Journal. 2. Post the journal entries to ledger accounts using T-accounts (Don't forget the opening balances from the information given on the post-closing trial balance on Nov. 30th.) 3. Prepare Income Statement and the Retained Earnings Statement for the month ended December 31, 2016 and Balance Sheet as of December 31, 2016 in good forms. Use the multi-step format for the Income Statement. 4. Close the temporary accounts, posting any net income or loss to retained earnings. Due Date: Apr. 26th. 1 Transactions in December 2016: Dec . 1 The equipment was completely destroyed by the regional earth quake. \"Loss by earthquake\" was recognized. 1 Lent cash to another company and received a 2 year, $20,000 zero-interest-bearing note. The market rate of interest for a note of similar risk is 8 percent. Purchased new equipment that costs $12,000 and issued 1,000 shares of common stock (no-par stock) to the equipment seller. 1 3 4 1 0 1 3 1 5 1 6 1 7 2 0 2 9 3 0 3 1 3 1 Cash payment on accounts payable amounted to $6,000. Sold land for $13,000 cash. Collected $15,000 as payment for amounts previously billed (suppose the payment was made within the discount period). One of the customers went bankrupt. B&G wrote off $2,000 account receivable. Paid monthly salaries of $20,000 to employees Issued 1,000 shares of preferred stock at $10 per share Purchased 500 shares of ABC corporation's common stock at $15 (per share) and classify the securities as available-for-sales securities Found that the company incorrectly overstated its November account receivable and sales revenue by $1,000 and made a journal entry to correct the error. Performed services for a customer for $30,000 cash Performed $30,000 services on account with the following terms: 2/15, n/30. B&G records credit sales using the net method Dividends of $5,000 were declared and paid. $ 1,025 is paid to preferred stockholders and the rest is paid to the common stock holders. ABC corporation declared $ 5 dividend per share (to common stock holders). It will be paid in 2017. * Additional information 1. Ignore tax effect. 2. Salaries expenses incurred but not paid prior to Dec. 31 st totaled $10,500. 3. The company received the bill for utility services (electricity) that the firm used during December in the amount of $6,000. The company will pay the bill in Jan. 2016. 4. $3,000 of supplies remained at the end of December. 5. The company use the \"Allowance\" method for possible accounts receivable write-offs in the future and estimated that 4% of the outstanding account receivable will not be collected. 2 6. The equipment purchased on Dec. 1st depreciates $200 per month. 7. The common stock price of ABC Corporation on December 31st is still $ 15 per share. 3 B&G Co. Post-closing Trial Balance November 30th, 2016 ACCOUNT CREDIT DEBIT Cash $42,500 Accounts Receivable 20,000 Allowance for doubtful account 1,000 Supplies 9,000 Equipment 10,000 Accumulated Depreciation $5,000 Land 10,500 Accounts Payable 8,000 Salaries Payable 10,000 Common Stock* 50,000 Retained Earnings 18,000 $92,000 $92,000 * 50,000 shares authorized, 20,000 shares issued and outstanding DATE JOURNAL ENTRIES - B&G Co. ACCOUNT DEBIT Cash Accounts Receivable CREDIT Allowance for doubtful ac Dividend Receivable Supplies Note receivable Discount on N/R Investments in ABC stock Equiptment Accumulated Depreciatio Dividends Salaries Expense Depreciation Expense Utility Expense Bad Dabt Expense DATE Dec. 31 ADJUSTING ENTRIES ACCOUNT DEBIT CREDIT Supplies Expense Loss by earthquake DATE CLOSING ENTRIES ACCOUNT DEBIT CREDIT Cash Accounts Payable Salaries Payable Utility payable Accounts Receivable Prefered stock Common stock owance for doubtful ac Service Revenue Interest Revenue Dividend Receivable Dividend Revenue Supplies Gain on the sale of land Note receivable Retained Earnings Discount on N/R Income Summary vestments in ABC stock Equiptment cumulated Depreciatio Dividends Salaries Expense Depreciation Expense Utility Expense Bad Dabt Expense Supplies Expense Loss by earthquake B&G Co. Income Statement For the month ending December 31, 2016 B&G Co. Retained Earnings Statement For the month ending December 31, 2016 B&G Co. Balance Sheet December 31, 2016 Assets Current Assets Total Current Assets Non-current Asstes Total Non-Current Assets Total Assets Liabilities Stockholders' Equity Total liabilities and Stockholders' Equity