Hey I was wondering if you could help me with this project I am having a really hard time and I need it done by Tuesday October 13,2015@ 3:00 p.m. Thank you so much in advance for all of your help.

Accounting Cycle Project Transaction Practice Set - B&G Co. ACC5100 & 7040 - Fall 2015 - 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: Project 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. Complete the trial balance on the worksheet. 4. Analyze the narrative to prepare Adjusting Entries and record them to the Taccounts and the worksheet. 5. Prepare the Adjusted Trial Balance on the worksheet. 6. Carry forward the appropriate balances to the Income Statement and Balance Sheet columns on the worksheet. 7. Prepare Income Statement and the Retained Earnings Statement for the month ended December 31, 2015 and Balance Sheet as of December 31, 2015 in good forms. Use the multi-step format for the Income Statement. 8. Close the income statement accounts, posting any net income or loss to retained earnings. Post the closing entry to the general journal and the Taccounts. Due Date: Oct. 26th,2015 (11:00pm) . 1 Note: You can work on this project individually or with your classmates as a team (the number of members up to three). 2 The following is the post-closing trial balance of the B&G Co. on Nov. 30th, 2015: B&G Co. Post-closing Trial Balance November 30th, 2015 DEBIT $41,500 ACCOUNT Cash Accounts Receivable Supplies Equipment Accumulated Depreciation Land Accounts Payable Salaries Payable Common Stock* Retained Earnings CREDIT 20,000 9,000 10,000 $5,000 10,500 8,000 10,000 50,000 18,000 $91,000 $91,000 * 50,000 shares authorized, 20,000 shares issued and outstanding Transactions in December 2015: De c. 1 1 2 3 4 1 0 1 5 1 6 The equipment was completely destroyed by the regional earth quake. \"Loss by earthquake\" was recognized. Assume that the transaction meets the requirements of an extraordinary item. Lent 20,000 to another company and received a 2 year note. The note has a 9% interest rate. Interest will be paid annually on Dec. 1st of 2016 and2017. Purchased new equipment that costs $12,000 and issued 1,000 shares of common stock (no-par stock) to the equipment seller. Cash payment on accounts payable amounted to $6,000. Sold land for $13,000 cash. Collected $15,000 as payment for amounts previously billed. Paid monthly salaries of $20,000 to employees Issued 1,000 shares of preferred stock at $10 per share 3 1 7 2 0 3 1 3 1 3 1 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 various customers for $30,000 cash and another $30,000 on account during December. 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 2016. * 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 decided to use the \"Allowance\" method for possible accounts receivable write-offs in the future and recorded the 5% of the outstanding account receivable as \"Allowance for doubtful account\" and \"Bad debt expense\". Since the company did not use the method before, the beginning balance of the allowance is zero. 6. The equipment purchased on Dec. 2nd depreciates $200 per month. 7. The common stock price of ABC Corporation on December 31st is still $ 15 per share. 4 B&G Co. Post-closing Trial Balance November 30th, 2015 DEBIT ACCOUNT Cash $41,500 Accounts Receivable 20,000 Supplies 9,000 Equipment 10,000 Accumulated Depreciation Land 10,500 Accounts Payable Salaries Payable Common Stock* Retained Earnings $91,000 Cash Accounts Payable CREDIT Salaries Payable $5,000 8,000 10,000 50,000 18,000 $91,000 Utility Payable Accounts Receivable Prefered Stock * 50,000 shares authorized, 20,000 shares issued and outstanding Common Stock DATE Dec. 1 JOURNAL ENTRIES - B&G Co. ACCOUNT DEBIT CREDIT Allowance for Doubtfull A Service Revenue 1 Dividend Receivavle Interest Revenue 2 Interest Receivable Dividend Revenue 3 Supplies Gain on the sale of land 4 Retained Earnings Note receivable 10 Investments in ABC stock 15 Income Summary Equiptment 16 Accumulated Depreciati 17 Dividends 20 Salaries Expense 31 Depreciation Expense 31 Utility Expense 31 Bad Dabt Expense DATE Dec. 31 ADJUSTING ENTRIES ACCOUNT DEBIT CREDIT Supplies Expense Loss by earthquake DATE CLOSING ENTRIES ACCOUNT DEBIT CREDIT Account Title Cash Accounts Receivable Allowance for Doubtfull Account Dividend Receivavle Interest Receivable Supplies Note receivable Investments in ABC stock Equiptment Accumulated Depreciation Accounts Payable Salaries Payable Utility Payable Prefered Stock Common Stock Retained Earnings Dividends Service Revenue Interest Revenue Dividend Revenue Salaries Expense Depreciation Expense Utility Expense Bad Dabt Expense Supplies Expense Gain on the sale of land Loss by earthquake TOTALS NET INCOME TOTALS UNADJUSTED T/B DEBIT CREDIT B&G Co. Accountants Worksheet For the month and short year ending Dec. 31, 2015 ADJUSTMENTS ADJUSTED T/B DEBIT CREDIT DEBIT CREDIT INCOME STATEMENT DEBIT CREDIT BALANCE SHEET DEBIT CREDIT B&G Co. Income Statement B&G Co. Balance Sheet Assets Net income 25,600 Total Assets $ 128,250 Liabilities B&G Co. Retained Earnings Statement Total Liabilities 18,500 Stockholders' Equity Retained earnings, December 31 37,750 Total liailities and Stockholders' Equity $ 128,250