Assignment: Prepare in proper form:
NOTE: | ||||
Notes 1 & 2 are missing in the question. Hence, solution is given without the effect of | ||||
those notes. | ||||
A] | INCOME STATEMENT | |||
Revenues: | ||||
Sports consulting fee | $ 1,545,544 | |||
Expenses: | ||||
Wages expense | $ 75,000 | |||
Rent expense | $ 24,000 | |||
Subcontractor expense | $ 24,000 | |||
Supplies expense | $ 7,670 | |||
Repairs & maintenance expense | $ 35,600 | |||
Insurance expense | $ 14,500 | |||
Office expense | $ 45,670 | |||
Postage and shipping expense | $ 4,560 | |||
Travel and entertainment expense | $ 5,678 | |||
Rent expense | $ 24,000 | |||
Total operating expenses | $ 260,678 | |||
Income before tax | $ 1,284,866 | |||
B] | STATEMENT OF RETAINED EARNINGS | |||
Beginning balance | $ 150,000 | |||
Add: Net income for the year | $ 1,284,866 | |||
Less: Cash dividends | $ (56,000) | |||
Ending balance | $ 1,378,866 | |||
C] | BALANCE SHEET | |||
Assets | ||||
Current assets: | ||||
Cash | $ 345,567 | |||
Accounts receivable | $ 56,788 | |||
Supplies inventory | $ 12,500 | |||
Prepaid rent | $ 2,000 | |||
Prepaid insurance | $ 2,250 | |||
Total current assets | $ 419,105 | |||
Non-current assets: | ||||
PP&E: | ||||
Furniture and fixtures | $ 345,670 | |||
Accumulated depreciation-F&F | $ 35,400 | $ 310,270 | ||
Building | $ 1,450,000 | |||
Accumulated depreciation-Building | $ 245,000 | $ 1,205,000 | ||
Land | $ 345,050 | |||
Total PP&E | $ 1,860,320 | |||
Intangible assets: | ||||
Trade marks | $ 179,748 | |||
Total non-current assets | $ 2,040,068 | |||
Total assets | $ 2,459,173 | |||
Total liabilities and Stockholders' Equity | ||||
Current liabilities: | ||||
Salaries payable | $ 15,950 | |||
Accounts payable | $ 17,567 | |||
Unearned service revenue | $ 150,000 | |||
Mortgage payabe-Current portion [Details--Note 2 not seen] | $ - | |||
Total current liabilities | $ 183,517 | |||
Non-current liabilities-Mortgage payable | $ 756,790 | |||
Total liabilities | $ 940,307 | |||
Stockholders' Equity | ||||
Common stock | $ 140,000 | |||
Retained earnings | $ 1,378,866 | |||
Total stockholders' equity | $ 1,518,866 | |||
Total liabilities and stockholders' equity | $ 2,459,173 | |||
D] | Current ratio = Current assets/Current liabilities = 419105/183517 = | 2.28 | ||
E] | Working capital = Current assets-Current liabilities = 419105-183517 = | $ 235,588 |
Assignment: Prepare in proper form: The Balance Sheet The Statement of Retained Earnings The Income...
Prepare an Income Statement, Statement of Retained Earnings, and Balance Sheet using the following information. Credit (CR) Debit (DR) 11,000 Cash 5,000 23,500 4,000 12,000 4,000 2,500 3,800 60,000 32,000 29,500 21,000 Accounts Payable Accounts Receviable Rent Expense Unearned Revenue Depreciation Expense Prepaid Insurance Supplies Expense Equipment Accumulated Depreciation - Equipment Cost of Goods Sold Merchandise Inventory Notes Payable Salary Payable Buildings Interest Payable Sales Revenue Interest Expense Supplies Accumulated Depreciation - Buildings Prepaid Insurance Common Stock Retained Earnings Dividends...
Prepare an income statement and a retained earnings sheet ONLY Ironside security services end of period spread sheet for the year ended april30,2014 cash 18000 accounts receivable 37,200 supplies 7500 prepaid insurance 4,800 building 240,500 accumulated depreciation-building 55,200 accounts payable. 6,000 salaries payable. 1,500 unearned rent. 3,000 capital stock. 35,000 retained earnings. 144,300 dividends 10000 service fees. 480,000 rent revenue. 25,000 salaries expense 336,000 rent expense.62,500 supplies expense 12,000 depreciation expense-building 6,000 utilities expense 4,400 repairs expense 3,200 insurance expense...
Problem 1-63A (Algorithmic) Income Statement, Retained Earnings Statement, and Balance Sheet The following information relates to Ashton Appliances for 2019. Accounts payable $16,800 Accounts receivable 70,300 Accumulated depreciation (building) 106,200 Accumulated depreciation (furniture) 27,600 Bonds payable (due in 7 years) 192,000 Building 300,000 Cash 41,450 Common stock 115,620 Cost of goods sold 511,350 Depreciation expense (building) 11,050 Depreciation expense (furniture) 12,000 Furniture 130,000 Income taxes expense 16,650 Income taxes payable 11,400 Insurance expense 36,610 Interest expense 15,500 Inventory 59,850 Other...
Prepare an Income Statement and a statement of Retained Earnings sheet. Also, calculate profit margin and payout ratio. XYZ Company Adjusted Trial Balance Debit Credit Cash 9,800 Accounts receivable 5,250 5,300 Supplies Prepaid Advertising 3,000 Trucks 30,300 $ 10,000 Accumulated depreciation – Trucks Equipment 7,600 Accumulated depreciation – Equipment 2,100 Accounts payable 1,200 Unearned service fees 6,700 Common Stock 10,000 Retained earnings 16,050 Dividends 12,000 Service fees earned 90,000 Wages expense 29,800 Rent expense 10,200 Insurance expense 4,900 Supplies expense...
Use the information presented in this worksheet to prepare an income statement, retained earnings statement, and balance sheet. Show cell references if possible. ESP Corporation Worksheet for year ended December 31, 2018 Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Cash 5,900 $ 5,900 $ 5,900 Accounts Receivable 12,450 $ 2,800 $ 15,250 $ 15,250 Office Supplies $ 200 $ 200 $ 200 Prepaid insurance 2,400 $ 1,800 $ 600 $ 600 Equipment 169,000 $ 169,000 $ 169,500...
prepare an income statement, statement of retained earnings, and balance sheet. Sharon Silver, Registered Dietician July 31, 2017 Account Titles Balance Dividends $2,300 Unearned Revenues $1,500 Utilities Expense $150 Cash $36,200 Office Supplies $1,800 Rent Expense $500 Accounts Receivable $9,100 Accounts Payable h# $3,300 Retained Earnings (Beginning Balance) $0 Salaries Expense $1,700 Prepaid Insurance $2,000 Equipment $13,000 Notes Payable $30,000 Common Stock $23,150 Service Revenue $8,800
Balance Sheet, Income Statement, and Statement of Retained earnings * 100% Files 3:37 PM Sun Feb 16 Sandifer's Trial balance Home Insert Draw Formulas Data Calibri (Body) 11 BLUE A Review R View A O Sandifer's Accounting Service, Inc. Trial Balance For the year ended 12/31/19 Debit Credit $ 156,500 116,650 $ 51,250 2.950 1,700 260,000 125,000 111,500 167,000 24,000 5,650 & Cash 9 Accounts Recieveable 10 Allowance for Doubtful Accounts 11 Supplies 12 Prepaid insurance 13 Building 14 Equipment...
Requirement: Using this adjusted trial balance, complete an income statement, a statement of retained earnings, and a balance sheet. Make sure all three are in good form. Bertrand Irrigation System Adjusted Trial Balance December 31, 2018 Balance Account Title Debit Credit Cash $12,000 Accounts Receivable 46,200 Office Supplies 17,700 Prepaid Insurance 4,600 Building 58,000 Accumulated Depreciation—Building $24,300 Equipment 26,000 Accumulated Depreciation—Equipment 7,600 Accounts Payable 27,100 Interest Payable 1,800...
Prepare an Income Statement and a statement of Retained Earnings sheet. Also, calculate profit margin and payout ratio. CDE Company Adjusted Trial Balance Debit Credit Cash $ 3,500 Accounts receivable 8,000 Prepaid Insurance 3,600 Equipment 80,000 Accumulated depreciation $ 12,000 Accounts payable 600 Common Stock 35,000 Retained earnings 14,200 Cash Dividends 7,500 Service fees earned 102,200 Miscellaneous Income 4,200 Salaries Expense 42,800 Rent expense 13,000 Insurance expense 1,800 Depreciation expense 8,000 Income Tax expense 8,800 Income Tax Payable 8,800 Totals...
Chapter 3 Exam Review Use the below information to prepare an Adjusted Trial Balance for the Garrett Corporation for the Year Ended August 31, 2014: Cash Accounts Payable Prepaid Insurance Sales Salaries Expense Building Notes Payable Furniture Retained Earnings Prepaid Supplies Depreciation Expense, Building Insurance Expense 490,000 Merchandise Inventory 3,000,000 Accumulated depreciation, Building 425,000 Advertising Expense 1.620,000 Accumulated depreciation, Furniture 675,000 Accounts Receivable 1,175,000 Interest Expense 1,500,000 Salaries Payable 825,000 Depreciation Expense, Furniture 400,000 Supplies Expense 120,000 Land 150,000 Common...