1. Fees received in advance from clients $6,000, which were
recorded as revenue.
2. Services performed for clients that were not recorded by
December 31, $4,900.
3. Bad debt expense for the year is $1,430.
4. Insurance expired during the year $480.
5. Equipment is being depreciated at 10% per year.
6. Perez gave the bank a 90-day, 10% note for $7,200 on December 1,
2020.
7. Rent of the building is $750 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,510.
Question: Using the TB and information provided, prepare a classified Balance Sheet. Knowing that the company paid $17,000 cash dividend during the year (recorded in Retained Earnings)
Answer:
Balance Sheet | |||
At December 31,2020 | |||
Assets | |||
Current assets: | |||
Cash | $29,500 | ||
Accounts Receivable | $54,500 | ||
(Less): Allowance for Doubtful Accounts | ($2,180) | ||
Net accounts receivable | $52,320 | ||
Supplies | $1,960 | ||
Prepaid insurance | $620 | ||
Prepaid rent | $750 | ||
Total current assets | $85,150 | ||
Property,plant and Equipment: | |||
Equipment | $25,000 | ||
Accumulated Depreciation-Equipment | ($8,750) | ||
Total property,plant, and equipment | $16,250 | ||
Total assets | $101,400 | ||
Liabilities and stock holders' Equity | |||
Current liabilities: | |||
Unearned revenue | $6,000 | ||
Interest payable | $60 | ||
Salaries and wages payable | $2,510 | ||
Total current liabilities | $8,570 | ||
Notes Payable | $7,200 | ||
Total liabilities | $15,770 | ||
Stockholders' equity: | |||
Common Stock | $10,000 | ||
Retained Earnings | $75,630 | ||
Total stockholders' Equity | $85,630 | ||
Total liabilities and stockholders' Equity | $101,400 |
Calculation
Adjusted Trial Balance | ||
Debit | Credit | |
Cash | $29,500 | |
Accounts Receivable [49600+4900] | $54,500 | |
Allowance for Doubtful Accounts [750+1430] | $2,180 | |
Supplies | $1,960 | |
Prepaid insurance [1100-480] | $620 | |
Prepaid rent | $750 | |
Equipment | $25,000 | |
Accumulated Depreciation-Equipment [6250+2500] | $8,750 | |
Unearned revenue | $6,000 | |
Interest payable | $60 | |
Salaries and wages payable | $2,510 | |
Notes Payable | $7,200 | |
Common Stock | $10,000 | |
Retained Earnings | $25,010 | |
Service Revenue [100,000 - 6000+4900] | $98,900 | |
Rent Expenses [9750-750] | $9,000 | |
Salaries and Wages Expenses [30500+2510] | $33,010 | |
Utilities Expenses | $1,080 | |
Office expense | $720 | |
Bad debt expense | $1,430 | |
Insurance expense | $480 | |
Depreciation expense | $2,500 | |
Interest expense [7,200 x 10% x 30/360] | $60 | |
Total | $160,610 | $160,610 |
Income Statement' | ||
Service Revenue | $98,900 | |
Expenses: | ||
Rent Expenses | $9,000 | |
Salaries and Wages Expenses | $33,010 | |
Utilities Expenses | $1,080 | |
Office expense | $720 | |
Bad debt expense | $1,430 | |
Insurance expense | $480 | |
Depreciation expense | $2,500 | |
Interest expense | $60 | |
Total expenses | $48,280 | |
Net income | $50,620 | |
Statement of retained earnings | ||
Retained earnings, Beginning | $42,010 | |
Add: Net income | $50,620 | |
(Less): Dividends | ($17,000) | |
Retained earnings, Ending | $75,630 |
1. Fees received in advance from clients $6,000, which were recorded as revenue. 2. Services performed...
(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...
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...
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...
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...
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....
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...
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 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...
Required: 1. Prepare the adjusting entries on the Trial Balance tab, and complete the worksheet on the Trial Balance tab 2. On the Financial Statements tab, prepare the income Statement, Retained Earnings Statement, and Balance Sheet for the 2020 year 3. On the Tab complete T-Accounts for all accounts. The ending balances in every should agree to the balances on the Balance Sheet as of December 31, 2020 Prepaid Insurance 1,000 89,020 Accounts Receivable 103,100 103 100 Equipment 100,000 Allowance...
Required: 1. Prepare the adjusting entries on the Trial Balance tab, and complete the worksheet on the Trial Balance tab 2. On the Financial Statements tab, prepare the income Statement, Retained Earnings Statement, and Balance Sheet for the 2020 year 3. On the Tab complete T-Accounts for all accounts. The ending balances in every should agree to the balances on the Balance Sheet as of December 31, 2020 Prepaid Insurance 1,000 89,020 Accounts Receivable 103,100 103 100 Equipment 100,000 Allowance...