Question

I need submission 2 and submission 3 completed please, thank you!!!

Submission 1 - due Friday January 17 before 5pm - You must submit your completed Journal entries, the Worksheet complete through the Trial Balance (with totals for all columns), and the worksheet formulas tab complete through the Trial Balance. Your file must be named correctly - "Your name (first and last) Project 1 part 1. Failure to name your file correctly will result in a 1 point deduction Submission 2 - due Friday January 31 before 5pm - You must submit your completed Adjusting Journal Entries, the worksheet with the Trial Balance and adjustments and Adjusted Trial Balance Columns (with totals for all columns), and the Worksheet formulas tabs completed/redone. Your file must be named correctly - "Your name (first and last) Project 1 part 2. Failure to name your file correctly will result in a l point deduction Submission 3 - due Friday February 7 before 5pm - You must submit your completed Closing entries, the financial statements completed, and the financial statements formulas tab completed. Your file must be named correctly - "Your name (first and last) Project I part 3. Failure to name your file correctly will result in a 1 point deduction

Answer 1

Aug Fig Consulting Inc. Worksheet For the period ending Particulars Cash 8100 Accounts Receivable Supplies Prepaid Rent Land Computer Equipment Accum. Depre-- Equip. Office Furniture Accum. Depre-- Off. Furn. Accounts Payable Salaries Payable Interest Payable Unearned Revenue Long Term Notes Payable Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Supplies Expense Utilities Expense Interest Expense Depreciation Expense - Comp. Equip. Depreciation Expense - Off. Furn. Totals Beginning Numbers January Enteries Unadjusted TB Adjustments Adjusted TB Debit in $ Credit in $ Debit in $ Credit in $ Debit in $ Credit in $ Debit in $ Credit in $ Debit in $ Credit in $ 49200 27635 76835 76835 2100 2100 5480 7580 8650 6850 15500 4380 11120 8100 675 7425 28000 28000 28000 42800 42800 42800 185 185 11260 11260 11260 135 135 8650 8650 6850 6850 6850 1750 1750 65 11760 11760 980 10780 26000 26000 26000 120000 120000 120000 2000 2000 2000 28700 28700 6460 35160 4375 4375 1750 675 4380 6125 675 4380 2340 2340 2340 65 65 185 135 13650 185 135 200925 128650 128650 73310 73310 193310 193310 13650 200925

Adjusting Enteries Date Particulars 31.1.2020 Rent Expense a/c Dr. To Prepaid Rent (Rent expensed) 8100/12 Debit in $ Credit in $ 675 675 980 31.1.2020 Unearned Revenue a/c Dr. To Service Revenue (Revenue recognized) 980 Dr. 4380 31.1.2020 Supplies Expense a/c To Supplies (Supplies expensed) 4380 31.1.2020 Dr. Interest Expense a/c To Interest Payable (Interest accrued) 65 5480 31.1.2020 Accounts Receivable a/c Dr. To Service Revenue (Services on account) 5480 1750 31.1.2020 Salaries Expense a/c Dr. To Salaries Payable (Salaries accrued) 4375 x 2/5 1750 185 135 31.1.2020 Depreciation Expense - Comp. Equip. a/c Dr. Depreciation Expense - Off. Furn. a/c Dr. To Accum. Depre-- Equip. To Accum. Depre--Off. Furn. (To record Depreciation) 185 135

Aug Fig Consulting Inc. 35160 Closing Enteries Date Particulars 31.1.2019 Income Summary a/c Dr. To Salaries Expense To Rent Expense To Supplies Expense To Utilities Expense To Interest Expense To Depreciation Expense, Comp Equip. To Depreciation Expense, Office Furniture (Expense accounts closed) Debit in $ Credit in $ 13905 6125 2340 675 4380 65 185 135 Income Statement For the Month ending 31.1.2019 Service Revenue Less: Salaries Expense Rent Expense Supplies Expense Utilities Expense Interest Expense Depreciation Expense, Comp Equip. Depreciation Expense, Office Furniture Net Income 6125 675 4380 2340 185 135 13905 21255 35160 31.1.2019 Service Revenue a/c Dr. To Income Summary (Revenue accounts closed) 35160 Statement of Retained Earnings For the Month ending 31.1.2019 Beginning Balance Net Income Dr. 21255 31.1.2019 Income Summary a/c To Retained Earnings (Profits transferred) 21255 21255 21255 -2000 19255 Less:Dividends Dr. 2000 31.1.2019 Retained Earnings a/c To Dividends (Dividends charged) 2000

Balance sheet As at 31.1.2020 Assets Current Assets Amounts in $ Amounts in $ Cash Amounts in $ Amounts in $ Liabilities Current Liabilities 76835 Accounts Payable 7580 Salaries Payable 11120 Interest Payable 7425 102960 Unearned Revenue Accounts Receivable Supplies Prepaid Rent 6850 1750 65 10780 19445 Non Current Liabilities 28000 Long Term Notes Payable 26000 Non Current Assets Land Computer Equipment Accum. Depre-- Equip. Office Furniture Accum. Depre-- Off. Furn. Total Assets 42800 -185 11260 -135 42615 Shareholders Equity Common Stock 11125 Retained Earnings 184700 Total Liabilities & Equity 120000 19255 139255 184700