ADJUSTING ENTRIES Complete the excel spreadsheet by using the following suppleme
ID: 2551239 • Letter: A
Question
ADJUSTING ENTRIES
Complete the excel spreadsheet by using the following supplementary data. All of the account titles you will need in preparing the adjusting entries have already been included in the worksheet in their proper numerical sequence.
a) Store and office supplies on hand as of January 31 are $1,600.
b) Insurance expense expired during the month was $200.
The balance in the Prepaid Rent account is for a 2-month period ending February 28. The company will be moving to new facilities by the end of February.
The Building will be depreciated over 20 years, using straight-line depreciation with no salvage value. The Office Equipment has an estimated life of five years with no salvage value.
Interest and amortization should be accrued on the bonds payable.
Note: the discount on bonds payable is amortized on the straight-
line method for the month of January.
YourName estimates that in the future approximately 3.0 percent of total accounts receivable will be uncollectible.Use the balance sheet method and adjust to this number.
The marketable securities have a market value of $22,000 as of Jan 31 Use accounts 801 and 109 for the unrealized gain/loss). Unrealized Gains/Losses is part of Owners' Equity and is included as a part of Other Comprehensive Income and Accumulated Other Comprehensive Income in the Equity section of the balance sheet.
Record corporate income tax expense as $4,951 Note that when computing income tax for the corporation Unrealized Gains is not taxable.
COMPLETE WORKSHEET
Name Acct Unadj ustedTrial Bal ustments usted Trial Bal Income Statement Balance Sheet Account Title DR CR DR CR DR CR DR CR DR CR 101 Cash 102 Accounts Receivable 103 Allowance for Doubtful Accts. 109 Available for sale securities 110 Merchandise Invento 119 Office and Store Supplies 120 Prepaid Insurance 121Prepaid Rent 122 Office Equipment 123 Accum. Depre.-Office Equi 124 Warehouse Equipment 125 Accum. Depre.-Warehouse Equi 170 Buildin 171 Accum. Depre. -Buildin 201 Accounts Payable 203 Interest Payable 209 Salaries Payable 219 Employee's Fed Inc Taxes Pa 225 FICA Taxes Payable 240 Short-term Notes Payable 250 Dividends Payable 251 Income Taxes Payable 280 Bonds Payable 281 Discount on Bonds Payable 301 Common Stock 302 Additional Paid-In Capital 340 Accumulated-Other Comprehensive In 350 Retained Eamings 390 Treasury Stock 42,839 500 150,000 5.415 5.415 5.415 110,000 42.000 98.500Explanation / Answer
Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Summary Balance Sheet Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Cash 42,839.00 42,839.00 42,839.00 Accounts Receivable 47,500.00 47,500.00 47,500.00 Allowance for Doubtful Accounts 500.00 1,925.00 1,425.00 1,425.00 Available for Sale Securities 23,000.00 1,000.00 22,000.00 22,000.00 Merchandise Inventory 63,771.00 63,771.00 63,771.00 Office & Store Supplies 3,500.00 1,900.00 1,600.00 1,600.00 Prepaid Insurance 1,000.00 200.00 800.00 800.00 Prepaid Rent 4,000.00 2,000.00 2,000.00 2,000.00 Office Equipment 20,000.00 20,000.00 20,000.00 Accumulated Dep. - Office Equip. 4,000.00 333.33 4,333.33 4,333.33 Warehouse Equipment - - Accumulated Dep. - Warehouse Equip. - Building 150,000.00 150,000.00 150,000.00 Accumulated Dep. - Building - 625.00 625.00 625.00 Accounts Payable 30,200.00 30,200.00 30,200.00 Interest Payable - - - Salaries Payable - - - Employees fed. Inc Taxes Payable 1,400.00 1,400.00 1,400.00 FICA Taxes Payable 1,000.00 1,000.00 1,000.00 Short Term Notes Payable - - - Dividends Payable - - - Income Tax Payable - 4,951.00 4,951.00 4,951.00 Bonds Payable 110,000.00 110,000.00 110,000.00 Discount on Bonds Payable 9,000.00 9,000.00 9,000.00 Common Stock 42,000.00 42,000.00 42,000.00 Additional Paid in Capital 62,000.00 62,000.00 62,000.00 Accumulated Other Comprehensive Inc. 1,500.00 1,500.00 1,500.00 Retained Earnings 98,500.00 98,500.00 98,500.00 Treasury Stock 10,000.00 10,000.00 10,000.00 Sales 82,200.00 82,200.00 82,200.00 Sales Return and Allowances 1,000.00 1,000.00 1,000.00 Sales Discount 440.00 440.00 440.00 Cost of Goods Sold 45,150.00 45,150.00 45,150.00 Depreciation Expense - Office Equip. - 333.33 333.33 333.33 Depreciation Expense - Warehouse Equip. 517.00 517.00 517.00 Depreciation Expense - Building - 625.00 625.00 625.00 Office Salaries Expense 2,500.00 2,500.00 2,500.00 Sales Salaries Expense 4,500.00 4,500.00 4,500.00 Payroll Tax Expense 500.00 500.00 500.00 Interest Expense 100.00 100.00 100.00 Insurance Exepense - 200.00 200.00 200.00 Rent Expense - 2,000.00 2,000.00 2,000.00 Office / Store Supplies Expense - 1,900.00 1,900.00 1,900.00 Advertising Expense 400.00 400.00 400.00 Bad debts Expense - 1,925.00 1,925.00 1,925.00 Repair Expense, Office 600.00 600.00 600.00 Utilities Expesne 1,000.00 1,000.00 1,000.00 Income Tax Expense - 4,951.00 4,951.00 4,951.00 Realized Loss - sale of assets 1,483.00 1,483.00 1,483.00 Investment Income 500.00 500.00 500.00 Unrealized gain AFS - 1,000.00 1,000.00 1,000.00 Totals 433,300.00 433,300.00 12,934.33 12,934.33 440,634.33 440,634.33 71,124.33 82,700.00 369,510.00 357,934.33 Net Income - - 11,575.67 11,575.67 Totals 82,700.00 82,700.00 369,510.00 369,510.00 Note - 1. Interest on Bond cannot be calculated as no interest rate is given - - 2. Amortization of Discount on Bonds Payable cannot be calculated, as period for which bonds are issued are not given.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.