Search (A) C File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot Anal 10 - A A 29 Want ID BIU A E Moraenter $% Undo Clipboard Font Alignment Number D12 VEX fx B 4 5 6 Account Unadjusted Trial Balance Adjusting Entries Adjusted Trial Balance 7 Number Name Dobit Credit Dobit Credit Debit Credit 8 1110 Cash 38,350.92 38 350 92 9 1120 Accounts Receivable 1.261.00 1,261 00 10 1130 Prepaid Insurance 11 1140 Prepaid Rent 4,200.00 2 100.00 2 100.00 12 1150 Office Supplies 530.00 318.00 214.00 13 1211 Office Equip 2 116.00 2,116 00 14 1212 Accum Depr-Office Equip 15 1311 Computer Equip 227 400.00 227 400.00 TB 1312 Accum. Dopr-Computer Equip 17 1411 Building Cost 120,000.00 120,000.00 18 1412 Accum Depr Building 19 1510 Lond 23 000 00 23 000.00 20 2101 Accounts Payablo 1.700.00 1.700.00 21 2102 Advanced Payments 02 2103 Interest Payable 23 2105 Salarios Payable 24 2106 Income Taxes Payable 25 2201 Mortgage Payable 128 700.00 128.700.00 26 2202 Notes Payable 110,000.00 110,000.00 27 3100 Capital Stock 169,960.00 169,900.00 28 3200 Retained Earings 29 3300 Dividends 2,032.08 2,032 08 BLO 31 4100 Computer & Consulting Revenue 19,175 00 19,175.00 32 5010 Rent Expense 2,100.00 2,100.00 33 5020 Salary Expense 1.770.00 1,770.00 Transactions General Journal Worksheet Income Statement Changes in Retained Earnings Balance Sheet C D m F G H B 2103 Interest Payable 2105 Salaries Payable 2106 Income Taxes Payable 2201 Mortgage Payable 2202 Notes Payable 3100 Capital Stock 3200 Retained Earrings 3300 Dividends 128.700.00 110,000 00 169,900.00 128,700.00 110,000.00 169,900.00 2,032 08 2,032 08 19,175.00 19,175.00 2,100.00 22 23 24 25 28 27 28 29 30 31 32 33 34 35 38 37 38 39 40 41 42 43 44 45 46 47 48 49 4100 Computer & Consulting Revenue 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 5120 Income Tax Expense 1.770.00 250.00 1.215.00 990.00 2,100.00 1,770.00 250.00 1.215.00 990.00 316.00 316.00 6,480.00 6,480.00 TOTAL 429,595.00 129,595.00 2,416.00 2.416.00 429,595.00 429 595.00 29. The annual interest rate on the mortgage payable was 8.75 percent. Interest expense for one-half month should be computed because the building and land were purchased and the liability incurred on June 16. 62 63 30. Information relating to the prepaid insurance may be obtained from the transaction recorded on June 14. Expense the amount associated with one half month's insurance, 64 65 31 A review of Byte's job worksheets show that there are unbilled revenues in the amount of $5,125 for the period of June 28-30. 66 67 68 32 69 70 71 The fixed assets have estimated useful lives as follows: Building - 31.5 years Computer Equipment - 5.0 years Office Equipment - 7.0 years + Use the straight-line method of depreciation Management has decided that assets purchased during a month are treated as if purchased on the first day of the month. The building's scrap value is $7,500. The office equipment has a serap value of $500. The computer equipment has no scrap value. Calculate the depreciation for one month. 72 73 33. A review of the payroll records show that unpaid salaries in the amount of $531 are owed by Byte for three days, June 28 - 30. 74 75 Search (A) C File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot Anal 10 - A A 29 Want ID BIU A E Moraenter $% Undo Clipboard Font Alignment Number D12 VEX fx B 4 5 6 Account Unadjusted Trial Balance Adjusting Entries Adjusted Trial Balance 7 Number Name Dobit Credit Dobit Credit Debit Credit 8 1110 Cash 38,350.92 38 350 92 9 1120 Accounts Receivable 1.261.00 1,261 00 10 1130 Prepaid Insurance 11 1140 Prepaid Rent 4,200.00 2 100.00 2 100.00 12 1150 Office Supplies 530.00 318.00 214.00 13 1211 Office Equip 2 116.00 2,116 00 14 1212 Accum Depr-Office Equip 15 1311 Computer Equip 227 400.00 227 400.00 TB 1312 Accum. Dopr-Computer Equip 17 1411 Building Cost 120,000.00 120,000.00 18 1412 Accum Depr Building 19 1510 Lond 23 000 00 23 000.00 20 2101 Accounts Payablo 1.700.00 1.700.00 21 2102 Advanced Payments 02 2103 Interest Payable 23 2105 Salarios Payable 24 2106 Income Taxes Payable 25 2201 Mortgage Payable 128 700.00 128.700.00 26 2202 Notes Payable 110,000.00 110,000.00 27 3100 Capital Stock 169,960.00 169,900.00 28 3200 Retained Earings 29 3300 Dividends 2,032.08 2,032 08 BLO 31 4100 Computer & Consulting Revenue 19,175 00 19,175.00 32 5010 Rent Expense 2,100.00 2,100.00 33 5020 Salary Expense 1.770.00 1,770.00 Transactions General Journal Worksheet Income Statement Changes in Retained Earnings Balance Sheet C D m F G H B 2103 Interest Payable 2105 Salaries Payable 2106 Income Taxes Payable 2201 Mortgage Payable 2202 Notes Payable 3100 Capital Stock 3200 Retained Earrings 3300 Dividends 128.700.00 110,000 00 169,900.00 128,700.00 110,000.00 169,900.00 2,032 08 2,032 08 19,175.00 19,175.00 2,100.00 22 23 24 25 28 27 28 29 30 31 32 33 34 35 38 37 38 39 40 41 42 43 44 45 46 47 48 49 4100 Computer & Consulting Revenue 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 5120 Income Tax Expense 1.770.00 250.00 1.215.00 990.00 2,100.00 1,770.00 250.00 1.215.00 990.00 316.00 316.00 6,480.00 6,480.00 TOTAL 429,595.00 129,595.00 2,416.00 2.416.00 429,595.00 429 595.00 29. The annual interest rate on the mortgage payable was 8.75 percent. Interest expense for one-half month should be computed because the building and land were purchased and the liability incurred on June 16. 62 63 30. Information relating to the prepaid insurance may be obtained from the transaction recorded on June 14. Expense the amount associated with one half month's insurance, 64 65 31 A review of Byte's job worksheets show that there are unbilled revenues in the amount of $5,125 for the period of June 28-30. 66 67 68 32 69 70 71 The fixed assets have estimated useful lives as follows: Building - 31.5 years Computer Equipment - 5.0 years Office Equipment - 7.0 years + Use the straight-line method of depreciation Management has decided that assets purchased during a month are treated as if purchased on the first day of the month. The building's scrap value is $7,500. The office equipment has a serap value of $500. The computer equipment has no scrap value. Calculate the depreciation for one month. 72 73 33. A review of the payroll records show that unpaid salaries in the amount of $531 are owed by Byte for three days, June 28 - 30. 74 75