I need the steps 8 -11 completed in this excel workbook ASAP! Please

\fAsset Accounts Liability Accounts Acct # Cash Baking Supplies Prepaid Rent Prepaid Insurance Baking Equipment Misc. Supplies Accounts Receivable Accumulated Depreciation Equity Accounts Acct # 101 Notes Payable 102 Accounts Payable 103 Wages Payable 104 Interest Payable 105 106 107 108 Acct # 201 Common Stock 202 Dividends 203 204 301 302 Revenue Accounts Acct # Bakery Sales Merchandise Sales This chart of accounts should help you identify the appropriate accounts to record to as you are analyzing and journaling transactions for this workbook. There is nothing to complete on this page; this is simply a resource for you. 401 402 Expense Accounts Acct # Baking Supplies Expense Rent Expense Insurance Expense Misc. Expense Business License Expense Advertising Expense Wages Expense Telephone Expense Interest Expense Depreciation Expense Misc. Supplies Expense 501 502 503 504 505 506 507 508 509 510 511 Peyton Approved General Journal Entries Jul-14 Date Accounts 1-Jul Cash Common Stock Contributed cash for common stock 1-Jul Baking Supplies Vendor 3-Jul Cash Creditors (Parents) 7-Jul Rent Expense Prepaid Expense Rent Payable 10-Jul Business License Fee Cash 11-Jul Misc. Expense Cash 13-Jul Banking Equipment Common Stock Advertising Expense Cash 14-Jul Misc. Supplies Cash 30-Jul Telephone Expense Expense Payable 31-Jul Prepaid Insurance Cash 31-Jul Salary Expense Salary Payable To Record Accured Salary Debit 15,000.00 Credit 15,000.00 8,500.00 8,500.00 10,000.00 10,000.00 1,500.00 1,500.00 3,000.00 375.00 375.00 250.00 250.00 5,000.00 5,000.00 200.00 200.00 300.00 300.00 45.00 45.00 1,200.00 1,200.00 120.00 120.00 Peyton Approved General Journal Entries Aug-14 Date 31-Jul Accounts Totals 5-Aug Salary Expense Debit 15,000.00 120.00 8-Aug Accounts Receiveable 10-Aug Telephone Expense Credit 15,000.00 3,200.00 45.00 15-Aug Business Expense 5,000.00 15-Aug Rent Expense 1,500.00 18-Aug Accounts Receiveable 20-Aug Acccounts Payable 1,000.00 8,500.00 20-Aug Salary Expense 420.00 22-Aug Misc. Supplies 300.00 31-Aug Utilities 31-Aug Salaries 31-Aug Accounts Receiveable 45.00 420.00 7,500.00 Peyton Approved General Journal Entries Sep-14 Date Accounts 1-Sep Dividends Cash 5-Sep Salaries Payable Cash 7-Sep Merchandise Inventory Cash 8-Sep Cash Accounts Receiveable 10-Sep Telephone Expense Cash 11-Sep Baking Supplies Accounts Payable 13-Sep Accounts Payable Cash 15-Sep Salaries Expense Salaries Payable 15-Sep Rent Expense Cash 15-Sep Cash Merchandise Sale Revenue 15-Sep Cost of Goods Sold 15-Sep Merchandise Inventory 20-Sep Merchandise Inventory Cash 24-Sep Cash Merchandise Sale Revenue 24-Sep Cost of Goods Sold Merchandise Inventory 30-Sep Merchandise Inventory Cash 30-Sep Salaries Expense Salaries Payable Debit 3,000.00 Credit 3,000.00 120.00 120.00 60.00 60.00 4,000.00 4,000.00 45.00 45.00 7,000.00 7,000.00 5,000.00 5,000.00 120.00 120.00 1,500.00 1,500.00 68.00 68.00 48.00 48.00 122.00 122.00 153.00 153.00 109.60 109.60 151.25 151.25 120.00 120.00 FIFO Date 7-Sep Purchases 10 $ 6.00 $ Sales 60.00 15-Sep 20-Sep 8 $ 20 $ 6.10 $ 6.00 $ 6.10 $ $ 12.00 97.60 109.60 12.00 6.00 $ 6.10 $ $ 12.00 122.00 134.00 4 $ 6.10 $ 24.40 4 $ 25 $ 29 29 6.10 $ 6.05 $ $ $ 24.40 151.25 175.65 175.65 LIFO 7-Sep Purchases 10 $ 6.00 $ 333.25 6.10 $ 157.60 Ending Inventory 10 $ 6.00 $ 60.00 60.00 8 $ 20 $ $ Sales 15-Sep 20-Sep 26 6.00 $ 48.00 122.00 24-Sep 2 $ 2 $ 20 $ 22 18 $ 6.10 $ 109.80 2 $ 2 $ 4 6.00 $ 6.00 $ 6.10 $ $ 6.00 $ 6.10 $ $ 15-Sep Cash (8 x $8.50) Merchandise Sales Revenue Record sale of inventory 68.00 15-Sep Cost of Goods Sold (8 X $6) Merchandise Inventory Recorded the cost of goods sold 48.00 68.00 48.00 20-Sep Merchandise Inventory (20 x $6.10 ) Cash 122.00 24-Sep Cash (18 x 8.50) Merchandise Sales Revenue Record sale of inventory 153.00 109.60 151.25 7-Sep Merchandise Inventory (10 x $6) Cash Purchased inventory 60.00 122.00 153.00 109.60 151.25 60.00 12.00 12.00 122.00 134.00 12.00 12.20 24.20 15-Sep Cash (8 x $8.50) Merchandise Sales Revenue Record sale of inventory 68.00 15-Sep Cost of Goods Sold (8 X $6) Merchandise Inventory Record inventory reduction due to sale 48.00 68.00 48.00 55 weighted average 7-Sep 6.05 $ $ Purchases 10 $ 6.00 $ 151.25 333.25 6.10 $ 25 $ 55 6.05 $ $ 6.00 $ 48.00 6.09 $ 109.62 151.25 333.25 2 $ 2 $ 20 $ 22 18 $ 26 6.00 $ 6.10 $ 6.05 $ $ $ 12.00 12.20 151.25 175.45 175.45 Ending Inventory 10 $ 6.00 $60 122.00 24-Sep 30-Sep 157.80 60.00 8 $ 20 $ $ Sales 15-Sep 20-Sep 26 2 $ 2 $ 25 $ 29 29 157.62 4 4 25 $ 29 6.00 $ 6.00 $ 6.10 $ $ $ $ 6.05 $ $ 122.00 24-Sep Cash (18 x 8.50) Merchandise Sales Revenue Record sale of inventory 153.00 109.80 30-Sep Merchandise Inventory (25 x $6.05) Cash 25 $ 20-Sep Merchandise Inventory (20 x $6.10) Cash 24-Sep Cost of Goods Sold (18 x $6.10) Merchandise Inventory Record inventory reduction due to sale 30-Sep Cr 60.00 30-Sep Merchandise Inventory (25 x $6.05) Cash $ 151.25 6.00 $ 7-Sep Merchandise Inventory (10 x $6) Cash Purchased inventory Dr 60.00 24-Sep Cost of Goods Sold (2 x $6)+(16 x $6.10) Merchandise Inventory Recorded the cost of goods sold 55 6.05 $ 48.00 2 $ 2 $ 20 $ 22 2 $ 16 $ 25 $ 6.00 $ 122.00 24-Sep 30-Sep Ending Inventory 10 $ 6.00 $ 60.00 151.25 7-Sep Merchandise Inventory (10 x $6) Cash Purchased inventory 60.00 122.00 153.00 109.80 151.25 60.00 12.00 12.00 122.00 per unit 134.00 $6.09 24.38 151.25 151.25 $5.22 15-Sep Cash (8 x $8.50) Merchandise Sales Revenue Record sale of inventory 68.00 15-Sep Cost of Goods Sold (8 X $6) Merchandise Inventory Record inventory reduction due to sale 48.00 68.00 48.00 20-Sep Merchandise Inventory (20 x $6.10) Cash 122.00 24-Sep Cash (18 x 8.50) Merchandise Sales Revenue Record sale of inventory 153.00 122.00 153.00 Purchases 9/7: 10 bottles purchased at $6 9/20: 20 bottles purchased at $6.10 9/30: 25 bottles purchased at $6.05 Sales - selling price, $8.50 a bottle 9/15: 8 bottles 9/24: 18 bottles 24-Sep Cost of Goods Sold (18 x $6.09) Merchandise Inventory Record inventory reduction due to sale 109.62 30-Sep Merchandise Inventory (25 x $6.05) Cash 151.25 109.62 151.25 date Cash 1-Jul 3-Jul 10-Jul 11-Jul 13-Jul 14-Jul 31-Jul 1-Sep 5-Sep 7-Sep 10-Sep date Notes Payable date Business License exp 10-Jul 375 15-Aug 5,000 15,000.00 10,000.00 375.00 250.00 200.00 300.00 1,200.00 3,000.00 120.00 60.00 45.00 10-Sep 13-Sep date Accounts Rec. 8-Aug 31-Aug date 3,200 7,500 COMPLETION OF STEPS 1- 4 DELIVERABLE: CONGRATULATIONS! YOU ARE NOW READY TO SUBMIT YOUR 45.00 5,000.00 WORKBOOK TO COMPLETE THE 3-3 CHECKPOINT REQUIREMENT 11-Jul 14-Jul 0 1,500.00 68.00 122.00 153.00 151.25 25,221.00 12,852.75 date 1-Jul 12,368.25 Misc. expense 250 300 date 13-Jul Baking equipment 5,000 date 13-Jul Advertising expense 200 200 5,000 550 date 1-Jul 11-Sep Baking supplies 8,500 7,000 date 14-Jul 22-Aug 15,500 Misc. supplies 300 300 date Rent expense 7-Jul 15-Aug 15-Sep 1,500 1,500 1,500 600 4,500 date 7-Jul Prepaid rent 1,500 date Prepaid insurance 1,200 date Bakery Sales 1,200 0 1,500 date 20-Aug Accounts payable 8,500 Common Stock 15,000 Insurance expense 0 15-Sep 15-Sep 20-Sep 24-Sep 30-Sep date date 31-Jul Salary and wages expense 120 date 31-Jul Salaries and wages payable 120 11-Sep 13-Sep 7,000 5,000 5-Aug 20-Aug 31-Aug 15-Sep 30-Sep 120 420 420 120 120 5-Sep 15-Sep 30-Sep 120 120 120 (6,500) date 30-Jul 10-Aug 10-Sep Telephone expense 45 45 45 1,320 240 date Dividends 1-Sep depreciation expense acc dep 3,000 135 3,000 date adj 0 Interest expense baking supplies expense 0 Interest payable adj 1-Jul 11-Sep date adj 8,500 7,000 15,500 0 misc supplies expense 11-Jul adj 250 date 15-Sep 24-Sep COGS LIF0 date 15-Sep 24-Sep 48.00 109.60 0 COGS FIFO 48.00 109.60 250 date Merchandise Sales Revenue 15-Sep 68.00 24-Sep 153.00 157.60 157.60 221.00 date 7-Sep 24-Sep COGS Weighted Avg. 48.00 109.62 157.62 date 7-Sep Merch. Inv. FIFO 60.00 60.00 date 7-Sep Merch. Inv. LIFO 60.00 60.00 date 7-Sep 20-Sep 30-Sep Merch. Inv. Avg. 60.00 122.00 151.25 333.25 Account Cash Baking Supplies Merchandise Inventory Prepaid Rent Prepaid Insurance Baking Equipment Misc. Supplies Accounts Receivable Notes Payable Accounts Payable Wages Payable Common Stock Dividends Bakery Sales Merchandise Sales Baking Supplies Expense Rent Expense Insurance Expense Misc. Expense Business License Expense Advertising Expense Wages Expense Telephone Expense COGS Depreciation Expense Accumulated Depreciation Misc Supplies Expense* Interest Expense* Interest Payable* Peyton Approved Trial Balance 2014 Unadjusted trial balance Debit Credit 47,896.75 20,500.00 175.65 1,500.00 1,200.00 $19,400 $1,200 5,000.00 600.00 10,300.00 Adjusted trial balance Debit Credit $47,896.75 $1,100 $176 $300 $1,200 $5,000 $50 $10,300 Adjusting entries Debit Credit 10,000.00 7,000.00 480.00 20,000.00 $10,000 $7,000 $480 $20,000 3,000.00 $3,000 60,000.00 221.00 $60,000 $221.00 $19,400 $1,200 $19,400 $4,500 $1,200 208.33 $250 $375 $200 1,956.00 90.00 157.60 208.33 4,500.00 250.00 375 200.00 1,956.00 90 157.60 208.33 97,701.00 ### 20,808.33 20,808.33 COMPLETION OF STEPS 5-7 DELIVERABLE: CONGRATULATIONS! YOU ARE NOW READY TO SUBMIT YOUR WORKBOOK TO COMPLETE THE 4-3 CHECKPOINT REQUIREMENT 208.33 97,359.68 97,909.33 *These accounts will not be utilized before the adjusting process. They should have zero balance in the unadjusted trial balance. Peyton Approved Adjusting Journal Entries 2014 Date Accounts 30-Sep Depreciation Expense accumulated depreciation (Life of Equipment is not recorded) Interest Expense (10000*6%) /12*3 months Interest Payable (To record the interest accural) Insurance Expense Prepaid Insurance (To record the insurance expense) Banking Supplies Expense (20500-1100) Banking Supplies (To record the baking supplies expense) Misc. Supplies Expense (600-50) Misc. Supplies (To record the misc. supplies expense) Debit 208.33 Credit 208.33 150.00 150.00 1,200.00 1,200.00 19,400.00 19,400.00 550.00 550.00 Peyton Approved Income Statement For Qtr. Ending 9/30/2014 Peyton Approved Statement of Retained Earnings For Qtr. Ending 9/30/2014 Peyton Approved Balance Sheet As of September 30, 2014 Assets Liabilities and Owners' Equity Peyton Approved Closing Entries 9/30/2014 Date Accounts Debit Credit Peyton Approved Post Closing Trial Balance 9/30/2014 Account Unadjusted Trial Balance Debit Credit Peyton Approved Reversing Entries 9/30/2014 Date Accounts Debit Credit COMPLETION OF STEPS 8-11 DELIVERABLE: CONGRATULATIONS! YOU ARE NOW READY TO SUBMIT YOUR COMPLETED WORKBOOK (STEPS 1 - 11)TO COMPLETE THE 6-2 CHECKPOINT REQUIREMENT