60.1K

Verified Solution

Link Copied!

the trail balance given by the professor

2. CREATE THE SEPTEMBER 31, 2018 UNADJUSTED TRIAL BALANCE 3. CREATE ADJUSTING JOURNAL ENTRIES FOR SEPTEMBER 31, 2018: o. Record the depreciation for the laptop purchased on September 1. p. Record the September 2018 depreciation for all computers & software owned before the September 1 purchase. These items are being depreciated over 5 years using the straight- line method with no salvage value. 4. Record the September 2018 depreciation for the furniture & fixtures. These items are being depreciated over 7 years using the straight-line method with no salvage value. . Record the adjusting entry for September's rent. Sunflower Designs paid $3,600 in advance for 6 months' rent on June 1, 2018. All previous months' adjusting entries were made as required. 5. Record the adjusting entry for the consumption of prepaid insurance for the month of September. The preexisting policy has 42 months remaining as of September 1, and recall that the new policy provides coverage for 24-months. The previous months' adjusting entries were made as required. t. Record the amount due to an employee for time worked during September, but not paid. The amount earned by the employee was $3,416. 4. CREATE THE ADJUSTED TRIAL BALANCE 5. CREATE THE SEPTEMBER 31, 2018 INCOME STATEMENT. T. Record the adjusting entry for September's rent. Sunflower Designs paid $3,600 in advance for 6 months' rent on June 1, 2018. All previous months' adjusting entries were made as required. S. Record the adjusting entry for the consumption of prepaid insurance for the month of September. The preexisting policy has 42 months remaining as of September 1, and recall that the new policy provides coverage for 24-months. The previous months' adjusting entries were made as required. t. Record the amount due to an employee for time worked during September, but not paid. The amount earned by the employee was $3,416. 4. CREATE THE ADJUSTED TRIAL BALANCE. 5. CREATE THE SEPTEMBER 31, 2018 INCOME STATEMENT. The amount for each account must be linked from the ending balances in the Trial Balance, All sub-totals and totals must be accurately calculated using Excel formulas. 6. CREATE THE SEPTEMBER 31, 2018 BALANCE SHEET. The amount for each account must be linked from the ending balances in the Trial Balance. All sub-totals and totals must be accurately calculated using Excel formulas. Note: The trial balance may include decimals, but the financial statements should not show decimals. ACCT 211 LP 2 Template Fol 2019 (1) Excel A Butta, Belle Auto save File Home - & Share Insert View Help Search 8 Draw Page Layout Formulas B Get Adil D stations My Add-ins a Data Review th? co his Timeline Pivottable Recommended Pivot tables table Recommended Maps Pivot chat D Wir loss September 30, 2019 Unadjusted Trial Balance Debit Credit Adjusting lournal Entries Entries or through t.) Debit Credit Adjusted/Ending Trial Balance Debit Credit 2 September 1, 2019 Beginning Transactions from journal Balances Entries a throughn) Acct # Description Debit Credit Debit Credit 1000 Cash 81,979.00 1010 Accounts Receivable 8,600.00 1020 Inventory 5,810.00 1030 Prepaid Insurance 3,855.00 1040 Prepaid Rent 3,000.00 1100 Building 1110 Computers & Software 3,250.00 1115 Accumulated Dep Comp 975.00 1120 Furniture & Fixtures 6,750.00 1125 Accumulated Dep F&F 2,250.00 1130 Land 1140 Machinery & Equipment 1150 Accumulated Dep M&E 2000 Accounts Payable 1,925.00 2010 Payroll Tax Payable 990.00 2020 Sales Tax Payable 296.00 2030 Unearned Revenue 6,350.00 2040 Line of Credit Journal Entries Trial Balance Income Statement Balance Sheet File Home Insert Draw Page Layout F de ? 12 5 B Get Add-ins du Line als Column Win/Loss Recommended Maps PivotChart 3D Map Illustrations My Add-ins & Pivot Table Recommended Table Pivot Tables Charts - Tours Sparklines Add-ins Tables E2 - X fr Debit A 2050 Notes Payable 2060 Wages Payable 4,025.00 3000 Peters, J., Capital 1,250.00 3010 Peters, M., Capital 1,250.00 3050 Retained Earnings 93,933.00 5000 Designing Revenue 5010 Furnishing Sales 5020 Cost of Goods Sold 6000 Vendor Compensation 6010 Contract Labor Expense 6020 Materials Expense 6030 Supplies Expense 6040 Wages Expense 6050 Depreciation Expense 6060 Insurance Expense 6070 Office Rent Expense 6080 Office Supplies Expense 6090 Payroll Tax Expense 6100 Postage Expense 6110 Small Tools Expense 113,244.00 113,244.00 Journal Entries Trial Balance Income Statement Balance Sheet 38 39 40 41 2. CREATE THE SEPTEMBER 31, 2018 UNADJUSTED TRIAL BALANCE 3. CREATE ADJUSTING JOURNAL ENTRIES FOR SEPTEMBER 31, 2018: o. Record the depreciation for the laptop purchased on September 1. p. Record the September 2018 depreciation for all computers & software owned before the September 1 purchase. These items are being depreciated over 5 years using the straight- line method with no salvage value. 4. Record the September 2018 depreciation for the furniture & fixtures. These items are being depreciated over 7 years using the straight-line method with no salvage value. . Record the adjusting entry for September's rent. Sunflower Designs paid $3,600 in advance for 6 months' rent on June 1, 2018. All previous months' adjusting entries were made as required. 5. Record the adjusting entry for the consumption of prepaid insurance for the month of September. The preexisting policy has 42 months remaining as of September 1, and recall that the new policy provides coverage for 24-months. The previous months' adjusting entries were made as required. t. Record the amount due to an employee for time worked during September, but not paid. The amount earned by the employee was $3,416. 4. CREATE THE ADJUSTED TRIAL BALANCE 5. CREATE THE SEPTEMBER 31, 2018 INCOME STATEMENT. T. Record the adjusting entry for September's rent. Sunflower Designs paid $3,600 in advance for 6 months' rent on June 1, 2018. All previous months' adjusting entries were made as required. S. Record the adjusting entry for the consumption of prepaid insurance for the month of September. The preexisting policy has 42 months remaining as of September 1, and recall that the new policy provides coverage for 24-months. The previous months' adjusting entries were made as required. t. Record the amount due to an employee for time worked during September, but not paid. The amount earned by the employee was $3,416. 4. CREATE THE ADJUSTED TRIAL BALANCE. 5. CREATE THE SEPTEMBER 31, 2018 INCOME STATEMENT. The amount for each account must be linked from the ending balances in the Trial Balance, All sub-totals and totals must be accurately calculated using Excel formulas. 6. CREATE THE SEPTEMBER 31, 2018 BALANCE SHEET. The amount for each account must be linked from the ending balances in the Trial Balance. All sub-totals and totals must be accurately calculated using Excel formulas. Note: The trial balance may include decimals, but the financial statements should not show decimals. ACCT 211 LP 2 Template Fol 2019 (1) Excel A Butta, Belle Auto save File Home - & Share Insert View Help Search 8 Draw Page Layout Formulas B Get Adil D stations My Add-ins a Data Review th? co his Timeline Pivottable Recommended Pivot tables table Recommended Maps Pivot chat D Wir loss September 30, 2019 Unadjusted Trial Balance Debit Credit Adjusting lournal Entries Entries or through t.) Debit Credit Adjusted/Ending Trial Balance Debit Credit 2 September 1, 2019 Beginning Transactions from journal Balances Entries a throughn) Acct # Description Debit Credit Debit Credit 1000 Cash 81,979.00 1010 Accounts Receivable 8,600.00 1020 Inventory 5,810.00 1030 Prepaid Insurance 3,855.00 1040 Prepaid Rent 3,000.00 1100 Building 1110 Computers & Software 3,250.00 1115 Accumulated Dep Comp 975.00 1120 Furniture & Fixtures 6,750.00 1125 Accumulated Dep F&F 2,250.00 1130 Land 1140 Machinery & Equipment 1150 Accumulated Dep M&E 2000 Accounts Payable 1,925.00 2010 Payroll Tax Payable 990.00 2020 Sales Tax Payable 296.00 2030 Unearned Revenue 6,350.00 2040 Line of Credit Journal Entries Trial Balance Income Statement Balance Sheet File Home Insert Draw Page Layout F de ? 12 5 B Get Add-ins du Line als Column Win/Loss Recommended Maps PivotChart 3D Map Illustrations My Add-ins & Pivot Table Recommended Table Pivot Tables Charts - Tours Sparklines Add-ins Tables E2 - X fr Debit A 2050 Notes Payable 2060 Wages Payable 4,025.00 3000 Peters, J., Capital 1,250.00 3010 Peters, M., Capital 1,250.00 3050 Retained Earnings 93,933.00 5000 Designing Revenue 5010 Furnishing Sales 5020 Cost of Goods Sold 6000 Vendor Compensation 6010 Contract Labor Expense 6020 Materials Expense 6030 Supplies Expense 6040 Wages Expense 6050 Depreciation Expense 6060 Insurance Expense 6070 Office Rent Expense 6080 Office Supplies Expense 6090 Payroll Tax Expense 6100 Postage Expense 6110 Small Tools Expense 113,244.00 113,244.00 Journal Entries Trial Balance Income Statement Balance Sheet 38 39 40 41

Answer & Explanation Solved by verified expert

See Answer