The following are the trial balance and the other information related to Robert Consulting Engineer. ROBERT CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2020 Debit Credit Cash $29,500 Accounts Receivable 55,200 Allowance for Doubtful Accounts $732 Supplies 2,490 Prepaid Insurance 1,740 Equipment 29,700 Accumulated Depreciation-Equipment 6,522 Notes Payable 7,200 Common Stock 10,000 Retained Earnings 22,774 Service Revenue 115,238 Rent Expense 9,516 Salaries and Wages Expense 32,130 Utilities Expenses 1,400 Office Expense 790 $162,466 $162,466 1. Fees received in advance from clients $6,350, which were recorded as revenue. 2. Services performed for clients that were not recorded by December 31, $4,693. 3. Bad debt expense for the year is $1,515. 4. Insurance expired during the year $433. 5. Equipment is being depreciated at 10% per year. 6. Robert gave the bank a 90-day, 10% note for $7,200 on December 1, 2020. 7. Rent of the building is $732 per month. The rent for 2020 has been paid, as has that for January 2021, and recorded as Rent Expense. 8. Office salaries and wages earned but unpaid December 31, 2020, $2,739.
Part 1 From the trial balance and other information given, prepare annual adjusting entries as of December 31, 2020. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No entry" for the account titles and enter 0 for the amounts.)
part 2 Prepare an income statement for 2020. (Enter loss using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).)
part 3 Prepare a retained earnings statement for 2020. Robert paid a $16,350 cash dividend during the year. (recorded in Retained Earnings.) (List items that increase owner's capital first.)
part 4 Prepare a classified balance sheet for 2020. (List current assets in the order of liquidity.)
1) Adjusting journal entries: | ||||
Date | Acc Title | Debit $ | Credit $ | |
1 | Service Rev. | 6350 | ||
Unearned Revenue | 6350 | |||
(being advance revenue booked to Unearned rev.) | ||||
2 | Accounts Receivable | 4693 | ||
Service Rev. | 4693 | |||
(service revenue missed now recorded) | ||||
3 | Bad Debt | 1515 | ||
Allowance for Doubtful Accs | 1515 | |||
(bad debt expenses recorded) | ||||
4 | Insurance exp. | 433 | ||
Prepaid Insurance | 433 | |||
(insurance exp. recorded) | ||||
5 | Depreciation exp. | 2970 | ||
Acc Dep - equip | 2970 | |||
(depreciation recorded on equip. @10% on 29700) | ||||
6 | Interest exp. | 60 | (7200*10%*1/12) | |
Interest payable | 60 | |||
(interest exp. Recorded) | ||||
7 | Prepaid rent | 732 | ||
Rent expense | 732 | |||
(being prepaid rent recorded which booked as rent) | ||||
8 | Salaries & wages exp. | 2739 | ||
Salaries & wages payable | 2739 | |||
(being salaries & wages made payable) |
2)Income statement: | |||
amount $ | calculations | ||
Service revenue | 113581 | 115238-6350+4693 | |
Less:expenses operating: | |||
rent | 8784 | 9516-732 | |
Salary & wages | 34869 | 32130+2739 | |
Utilities | 1400 | 1400 | |
Office exp. | 790 | 790 | |
Bad Debts | 1515 | 1515 | |
Insurance | 433 | 433 | |
Depreciation exp. | 2970 | 2970 | |
Interest | 60 | 60 | |
Total Expenses | 50821 | ||
Net Income | 62760 |
3) Statement of Retained Earnings: | Calculations | ||
amount $ | |||
Opening Balance | 22774 | ||
add:Net income | 62760 | ||
Closing balance | 85534 | ||
4) Balance Sheet: | |||
Assets: | amount $ | ||
Cash | 29500 | 29500 | |
Acc Rec. | 59893 | 55200+4693 | |
Allow for D/A | -2247 | -2247 | |
Supplies | 2490 | 2490 | |
Prepaid Insurance | 1307 | 1740-433 | |
Prepaid rent | 732 | 732 | |
Current assets | 91675 | ||
PPE: | |||
Equipment | 29700 | 29700 | |
Acc Dep. | -9492 | -9492 | |
Total Assets | 111883 | ||
Liabilities & Equity: | amount $ | ||
Note payable | 7200 | 7200 | |
Unearned Rev. | 6350 | 6350 | |
Interest payable | 60 | 60 | |
salaries & wages payable | 2739 | 2739 | |
Current liabilities | 16349 | ||
Equity: | |||
CS | 10000 | 10000 | |
R Earnings | 85534 | ||
Total Liab. & Equity | 111883 |
The following are the trial balance and the other information related to Robert Consulting Engineer. ROBERT...
The following are the trial balance and the other information related to Charles Consulting Engineer. CHARLES CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2020 Debit Credit Cash $29,500 Accounts Receivable 52,700 Allowance for Doubtful Accounts $701 Supplies 2,000 Prepaid Insurance 1,680 Equipment 26,300 Accumulated Depreciation-Equipment 6,310 Notes Payable 7,200 Common Stock 10,000 Retained Earnings 24,581 Service Revenue 107,741 Rent Expense 9,113 Salaries and Wages Expense 32,990 Utilities Expenses 1,640 Office Expense 610 $156,533 $156,533 1. Fees received in advance from clients...
Problem 3-06 The following are the trial balance and the other information related to Kenneth Consulting Engineer. Credit $817 KENNETH CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2020 Debit Cash $29,500 Accounts Receivable 57,200 Allowance for Doubtful Accounts Supplies 1,500 Prepaid Insurance 1,270 Equipment 29,700 Accumulated Depreciation Equipment Notes Payable Common Stock Retained Earnings Service Revenue Rent Expense 10,621 Salaries and Wages Expense 34,650 Utilities Expenses 1,680 Office Expense 680 $166,801 5,759 7,200 10,000 22,092 120,933 $166,801 1. Fees received in...
MARK CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2020 Debit Credit Cash $29,500 Accounts Receivable 56,600 Allowance for Doubtful Accounts $776 Supplies 1,630 Prepaid Insurance 1,510 Equipment 33,500 Accumulated Depreciation-Equipment 6,314 Notes Payable 7,200 Common Stock 10,000 Retained Earnings 25,979 Service Revenue 117,759 Rent Expense 10,088 Salaries and Wages Expense 33,260 Utilities Expenses 1,150 Office Expense 790 $168,028 $168,028 1. Fees received in advance from clients $5,850, which were recorded as revenue. 2. Services performed for clients that were not recorded...
The following are the trial balance and the other information related to Martinez Perez, a consulting engineer. MARTINEZ PEREZ, CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2017 Debit Credit $29,500 56,400 $718 1,730 1,050 33,800 Cash Accounts Receivable Allowance for Doubtful Accounts Supplies Prepaid Insurance Equipment Accumulated Depreciation Equipment Notes Payable Owner's Capital Service Revenue Rent Expense (13 months of rent) Salaries and Wages Expense Utilities Expenses Office Expense 8,450 7,200 35,342 112,964 9,334 30,360 1,750 750 Totals $164,674 $164,674 1....
Problem 3-6 The following are the trial balance and the other information related to Pearl Perez, a consulting engineer. PEARL PEREZ, CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2017 Debit Credit Cash $29,500 Accounts Receivable 57,000 Allowance for Doubtful Accounts $815 Supplies 1,880 Prepaid Insurance 1,940 Equipment 30,300 Accumulated Depreciation-Equipment 7,575 Notes Payable 7,200 Owner’s Capital 36,778 Service Revenue 115,887 Rent Expense (13 months of rent) 10,595 Salaries and Wages Expense 34,700 Utilities Expenses 1,720 Office Expense 620 Totals $168,255 $168,255...
P3-6 The trial balance and other information for consulting engineers Mustang Rovers Consulting Limited follow: XLS FIRI MUSTANG ROVERS CONSULTING LIMITED Trial Balance December 31, 2017 Credit Debit $ 83,700 81,100 $ 750 1,960 85,000 Cash Accounts receivable Allowance for doubtful accounts Supplies Equipment Accumulated depreciation equipment Notes payable Common shares Retained earnings Service revenue Rent expense Salaries and wages expense Insurance expense Utilities expense Miscellaneous expense 6,250 7,200 35,010 161,100 100,000 9,750 28,500 18,500 1,080 720 $310,310 $310,310 Additional...
(Adjusting Entries and Financial Statements) The following are the trial balance and the other information related to Yorkis Perez, a consulting engineer. YORKIS PEREZ, CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2014 Debit Credit Cash $ 44,500 Accounts Receivable 49,600 Allowance For Doubtful Accounts $ 750 Inventory 1,960 Prepaid Insurance 1,100 Prepaid Rent 3,750 Equipment 25,000 Accumulated Depreciation—Equipment 6,250 Unearned Revenue 15,000 Notes Payable 7,200 Owner’s Capital 35,010...
MARTINEZ PEREZ, CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2017 Debit $29,500 56,400 Credit Cash Accounts Receivable Allowance for Doubtful Accounts Supplies Prepaid Insurance Equipment Accumulated Depreciation-Equipment Notes Payable Owner's Capital Service Revenue Rent Expense (13 months of rent) Salaries and Wages Expense Utilities Expenses Office Expense Totals $718 1,730 1,050 33,800 8,450 7,200 35,342 112,964 9,334 30,360 1,750 750 $164,674 $164,674 1. Fees received in advance from clients $6,010, which were recorded as revenue 2. Services performed for clients that...
3. (15 points) (Adjusting Entries and Financial Statements) The following are the trial balance and the other information related to Yorkis Perez, a consulting engineer. YORKIS PEREZ, CONSULTING ENGINEER TRIAL BALANCE DECEMBER 31, 2014 Debit Credit Cash $ 44,500 Accounts Receivable 49,600 Allowance For Doubtful Accounts $ 750 Inventory 1,960 Prepaid Insurance 1,100 Prepaid Rent 3,750 Equipment 25,000 Accumulated Depreciation Equipment 6,250 Unearned Revenue 15,000 Notes Payable 7,200 Owner's Capital 35,010 Service Revenue 103,750 Rent Expense 9,750 Salaries and Wages...
Financial Statements and Closing Entries The adjusted trial balance shown below is for Fine Consulting Service as of December 31. Byran Sharpe made no capital contributions during the year. SHARPE CONSULTING SERVICE Adjusted Trial Balance December 31 Debit Credit Cash $2,900 Accounts Receivable 3,270 Supplies 5,060 Prepaid Insurance 1,500 Equipment 6,400 Accum. Depr. - Equipment $1,080 Accounts Payable 845 Long - Term Notes Payable 7,200 Common Stock 2,800 Retained Earnings 5,205 Dividends 2,900 Service Fees Earned 62,600 Rent Expense 15,500...