Requirement 1: Prepare the worksheet as follows
| PIA Inc | ||||||||||||
| Work Sheet | ||||||||||||
| December 31,2007 | ||||||||||||
| Un-adjusted Trial Balance | Adjustments | Adjusted Trial Balance | Income Statement | Balance Sheet | ||||||||
| Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | |||
| Cash | $15,000 | $15,000 | $15,000 | |||||||||
| Accounts receivable | $36,000 | e. | $2,000 | $38,000 | $38,000 | |||||||
| Supplies | $9,000 | b. | $8,000 | $1,000 | $1,000 | |||||||
| Equipment | $99,000 | $99,000 | $99,000 | |||||||||
| Accumulated Depreciation | $13,000 | c. | $9,000 | $22,000 | $22,000 | |||||||
| Accounts Payable | $6,000 | $6,000 | $6,000 | |||||||||
| Salary Payable | $0 | d. | $1,000 | $1,000 | $1,000 | |||||||
| Unearned Service Revenue | $5,000 | a. | $1,000 | $4,000 | $4,000 | |||||||
| Notes Payable, Long-term | $60,000 | $60,000 | $60,000 | |||||||||
| Capital | $36,000 | $36,000 | $36,000 | |||||||||
| Withdrawals | $62,000 | $62,000 | $62,000 | |||||||||
| Service Revenue | $182,000 | a | $1,000 | $185,000 | $185,000 | |||||||
| e | $2,000 | |||||||||||
| Salary Expense | $53,000 | d. | $1,000 | $54,000 | $54,000 | |||||||
| Supplies Expense ($9,000 − $1,000) | $0 | b. | $8,000 | $8,000 | $8,000 | |||||||
| Depreciation Expense | $0 | c. | $9,000 | $9,000 | $9,000 | |||||||
| Interest Expense | $6,000 | $6,000 | $6,000 | |||||||||
| Rent Expense | $15,000 | $15,000 | $15,000 | |||||||||
| Insurance Expense | $7,000 | $7,000 | $7,000 | |||||||||
| Totals | $302,000 | $302,000 | $21,000 | $21,000 | $314,000 | $314,000 | $99,000 | $185,000 | $215,000 | $129,000 | ||
| Net Income | $86,000 | $86,000 | ||||||||||
| Totals | $185,000 | $185,000 | $215,000 | $215,000 | ||||||||
Requirement 2: Prepare the financial statements as follows
a. Income statement
| PIA Inc | ||
| Income Statement | ||
| For the Year Ended December 31, 2007 | ||
| Particulars | Amount | Amount |
| Revenues: | ||
| Service revenue | $185,000 | |
| Expenses: | ||
| Salary Expense | $54,000 | |
| Supplies Expense | $8,000 | |
| Depreciation Expense | $9,000 | |
| Interest Expense | $6,000 | |
| Rent Expense | $15,000 | |
| Insurance Expense | $7,000 | |
| Total Expenses | $99,000 | |
| Net income | $86,000 | |
b. Statement of owners' equity
| PIA Inc | ||
| Statement of Owners' Equity | ||
| For the Year Ended December 31, 2007 | ||
| Particulars | Amount | |
| Capital - Beginning Balance | $36,000 | |
| Add: Net income | $86,000 | |
| Deduct: Withdrawals | ($62,000) | |
| Capital - Ending Balance | $60,000 | |
c. Balance sheet
| PIA Inc | |||||
| Balance Sheet | |||||
| December 31, 2007 | |||||
| Assets | Amount | Amount | Liabilities and Owners' Equity | Amount | Amount |
| Current Assets: | Current Liabilities: | ||||
| Cash | $15,000 | Accounts Payable | $6,000 | ||
| Accounts Receivable | $38,000 | Salary Payable | $1,000 | ||
| Supplies | $1,000 | Unearned Service Revenue | $4,000 | ||
| Total Current Assets | $54,000 | Total Current Liabilities | $11,000 | ||
| Non-Current Liabilities: | |||||
| Property, Plant and Equipment: | Notes Payable - Long-term | $60,000 | |||
| Equipment | $99,000 | Total liabilities | $71,000 | ||
| Deduct: Accumulated Depreciation - Equipment | ($22,000) | $77,000 | Owners' Equity: | ||
| Capital | $60,000 | ||||
| Total Assets | $131,000 | Total liabilities and owners' equity | $131,000 | ||
Requirement 3: The net income in 2007 is $86,000 and it represents a profit margin of 46.49% (86,000 ÷185,000) and therefore the company had a good year during 2007.
P4-26A The unadjusted T-accounts of Paladdin Investment Advisers, at Decem ber 31, 2007, and the related...
P4-26A The unadjusted T-accounts of Paladdin Investment Advisers, at Decem- ber 31, 2007, and the related year-end adjustment data follow. Accounts Receivable Bal. 36,000 Supplies 9,000 Equipment Bal. 99,000 Bal. Salary Payable Accounts Payable Bal. 6,000 Unearned Service Revenue Bal. 5,000 S. Paladdin, Capital Bal. 36,000 S. Paladdin, Withdrawals Bal. 62,000 Supplies Expense Salary Expense Bal. 53,000 Interest Expense Bal. 6,000 Rent Expense Bal. 15,000 Insurance Expense Bal. 7,000 Adjustment data at December 31, 2007: a. Unearned service revenue earned...
Data Table Advisers at December 31, 2018 bint of retained earnings, and the classified balance sheet in accoun 2018 worksheet. Complete the works Income Statement and Balance with the adjustment letter references-(a), (b), (c) etc.-into the bedDepr = depreciation. Ex expense, It = long term, Paypal 1 More info Fawn Investment Advisers Unadjusted Trial Balance December 31, 2018 Balance Account Title Debit Credit Cash 32,000 Accounts Receivable 45,000 Office Supplies 6,000 Equipment 26.000 Accumulated Depreciation Equipment 19,000 Accounts Payable 20,000...
Consider the unadjusted trial balance of AEA Insurers at October31, 20x2, and the related month-enc adjustment data. TRIAL BALANCE ACCOUNT TITLE DEBIT CREDIT Cash 6,300 Accounts receivable 8,000 Prepaid rent 6,000 Supplies 600 Equipment 27,000 Accumulated depreciation 3,000 Accounts payable 2,800 Salary payable Karen Cabot, capital 38,000 Karen Cabot, withdrawals 3,600 Service revenue 9,400 Salary expense 1,400 Rent expense Utilities expense 300 Depreciation expense Supplies expense _________ ________ 53,200 53,200 Adjustment data: Accrued service revenue at October 31,...
P3-33A The trial balance of Dynaclean Air Purification Systems at November 30, 2007, and the data needed for the month-end adjustments follow. PANAIR PURIFICATION SYSTEMS Tha Balance November 2007 Balance Account Title Debit Credi Cash 57.100 Accounts receivable 19,800 Prepaid rent 2,400 Supplier 1,200 Equipment 19,700 Accumulated depreciation $ 3.600 Accounts payable 3.300 Salary payable Uneared service revenue 2,800 Dinah Kipin.capital 49,000 Dinah Ksein, withdrawals 9,800 Service tereno Salary expense 3.800 Rent expense Depreciation expense Advertising expense 1,500 Supplies expenses...
Suppb DYNACLEAN AIR PURUTCATION SYSTEMS THA Balance November 2007 Balance Account Title Debit Credit Casb 5 7100 Accounts receivable 19,800 Prepaid rent 2.400 Supplier 1,200 Equipment 19,700 Accumulated depreciation 5 3.600 Accounts payable 3.300 Salary payable Unearned service revenue 2,800 Dinah Klein, capital 40,000 Dinah Kiein, withdrawals 9,800 Service terene Salary expense 3.800 Rent expense Depreciation expense Advertising expense 1.500 Supplies expense Total 563.300 565,300 Adjustment data at November 30: a. Unearned service revenue still unearned, $1,100. b. Prepaid rent...
Accounting 1 Handouts 10. Consider the unadjusted trial balance of Freight Line Transport at May 31, 2017, and the related month-end adjustment data. Freight Line Transport Trial Balance May 31, 2017 Trial Balance Debit Credit 7,400 1,440 5,500 1,700 84,500 4,990 4,200 Account Cash Accounts receivable Prepaid rent Supplies Automobile Accumulated depreciation Accounts payable Salary payable Common stock Retained earnings Dividends Service revenue Salary expense Rent expense Fuel expense Depreciation expense Supplies expense Total 74,700 10,500 4,100 16,800 3,250 3,300...
The unadjusted trial balance of Princess Ltd. at October 31, 2017, appears below. The adjustment data at October 31, 2017, is provided. Adjustment data at October 31, 2017. A. Accrued service revenue at October 31, 2017, $2,300. B. Prepaid rent expired during the month. The unadjusted prepaid balance of $3,000 relates to the period October through December. C. Supplies used during October, $2,600. D. Depreciation on furniture for the month. The estimated useful life of the furniture is three years....
Consider the unadjusted trial balance of London, Inc. at December 31, 2016, and the related month-end adjustment data a (Click the icon to view the month-end adjustment data.) Requirements 1. Using the worksheet, prepare the adjusted trial balance of London, Inc. at December 31, 2016. The unadjusted balances have been entered for you. Key each adjusting entry by letter. 2. Prepare the single-step monthly income statement, the statement of retained earnings, and the classified balance sheet. More Info - X...
T Accounts, Adjusting Entries, Financial Statements, and Closing Entries; optional end-of-period spreadsheet The unadjusted trial balance of La Mesa Laundry at August 31, 20Y5, the end of the fiscal year, follows: La Mesa Laundry Unadjusted Trial Balance August 31, 20Y5 Debit Balances Credit Balances Cash 3,800 Laundry Supplies 9,000 Prepaid Insurance 6,000 Laundry Equipment 180,800 Accumulated Depreciation 49,200 Accounts Payable 7,800 Common Stock 15,000 Retained Earnings 80,000 Dividends 2,400 Laundry Revenue 248,000 Wages Expense 135,800 Rent Expense 43,200 Utilities Expense...
T Accounts, Adjusting Entries, Financial Statements, and Closing Entries; optional end-of-period spreadsheet The unadjusted trial balance of La Mesa Laundry at August 31, 20Y5, the end of the fiscal year, follows: La Mesa Laundry Unadjusted Trial Balance August 31, 20Y5 Debit Balances Credit Balances Cash 3,800 Laundry Supplies 9,000 Prepaid Insurance 6,000 Laundry Equipment 180,800 Accumulated Depreciation 49,200 Accounts Payable 7,800 Common Stock 15,000 Retained Earnings 80,000 Dividends 2,400 Laundry Revenue 248,000 Wages Expense 135,800 Rent Expense 43,200 Utilities Expense...