Income Statement | ||
Particulars | $ | $ |
Service Revenue | $4,88,700 | |
Expenses: | ||
Advertising Expense | $6,000 | |
Depreciation Expense | $55,600 | |
Insurance Expense | $5,800 | |
Interest Expense | $1,800 | |
Rent Expense | $6,700 | |
Salaries Expense | $1,55,000 | |
Supplies Expense | $2,200 | |
Travel Expense | $550 | |
Utilities Expense | $6,200 | |
Loss on sale of equipment | $2,000 | $2,41,850 |
Net Income | $2,46,850 |
Statement of Retained Earnings | ||
Particulars | $ | $ |
Opening Balance | $1,00,000 | |
Net Income | $2,46,850 | |
Closing Balance | $3,46,850 |
Balance Sheet | ||
Particulars | $ | $ |
Assets | ||
Non-Current Assets: | ||
PPA: | ||
Building | $2,60,000 | |
Equipment | $1,25,000 | |
Land | $1,11,500 | |
-Accumulated Depreciation | -$1,67,000 | $3,29,500 |
Non-Current Investments: | ||
Investments in Bond held to maturity | $24,000 | $24,000 |
Current Assets: | ||
Cash | $1,56,500 | |
Accounts Receivable | $1,16,650 | |
-Allowance for Doubtful Debts | -$51,250 | |
Supplies | $2,950 | |
Prepaid Insurance | $1,700 | $2,26,550 |
TOTAL | $5,80,050 | |
Equity and Liabilities | ||
Equity: | ||
Common Stock | $49,100 | |
Retained Earnings | $3,46,850 | $3,95,950 |
Liabilities: | ||
Non-Current Liabilities: | ||
Note Payable | $1,70,000 | $1,70,000 |
Current Liabilities: | ||
Accounts Payable | $5,650 | |
Current Maturity of Note Payable | $3,000 | |
Unearned Revenue | $2,000 | |
Interest Payable | $1,500 | |
Salaries Payable | $1,950 | $14,100 |
TOTAL | $5,80,050 |
Balance Sheet, Income Statement, and Statement of Retained earnings * 100% Files 3:37 PM Sun Feb...
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 a Trial Balance, Multi Step Income Statement, Retained Earnings Statement, and Classified Balance Sheet the values needed are all the way on the left in the photo. i started the trial balance (the green chart) but could not get both sides to equal. ACCT 251 EXCEL ASSIGNMENT - PREPARING FINANCIAL STATEMENTS IN EXCEL (see instructions tab for detailed instructions) Prepare a multi-step income statement: Prepare a retained earnings statement: Prepare a classified balance sheet: 1,001,360 101,360 591,680 Service Revenue...
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
Assignment: Prepare in proper form: The Balance Sheet The Statement of Retained Earnings The Income Statement Calculate the Current Ratio Calculate Working Capital Carlson & Chan Sports Mgt Incorporated Trial Balance July 31, 2020 Debit Credit $ 345,567 56,788 12,500 2,250 2,000 345,670 $ 35,400 1,450,000 245,000 345,050 179,748 105 120 130 140 145 170 171 175 176 190 195 210 215 230 270 310 320 320 405 505 510 520 530 545 550 560 565 570 575 Cash...
i want the income statement, statement of retained earnings, and balance sheet 2 MIX Inc. is a service business incorporated on January, 2018 to provide personal training for athletes aspiring to play college sports. The following is a simplified list of accounts and amounts reported in its accounting records at the beginning of its second quarter of operations on April 1, 2018(the amounts are in thousands of dollars). The accounts have normal debit or credit balances. Accounts Payable $ 600...
Cornerstone Exercise 3-25 Preparing a Retained Earnings Statement Sparrow Company had the following adjusted trial balance at December 31, 2019 Sparrow Company Adjusted Trial Balance December 31, 2019 Debit Credit Cash $3,150 Accounts Receiva ble 5,650 Prepaid Insurance 4,480 42,000 Equipment Accumulated Depreciation, $24,000 Equipment Accounts Payable 2,800 Salaries Payable 4,450 Unearned Service Revenue 3,875 Common Stock 8,000 Retained Earnings 2,255 Dividends 10,500 Service Revenue 99,600 Salaries Expense 49,400 Rent Expense 17,250 Insurance Expense 2,200 Depreciation Expense 4,950 Income Tax...
Prepare the Statement of Retained Earnings from the Adjusted Trial Balance and Income Statement. Within each section of the statement, use the drop-down menus to enter the accounts in Chart of Accounts order and select the account balances. Prepare the Statement of Retained Earnings from the Adjusted Trial Balance and Income Statement. Within each section of the statement, use the drop-down menus to enter the accounts in Chart of Accounts order and select the account balances. SMART TOUCH LEARNING SMART...
Build the unadjusted trial balance and adjustments columns from the given information and total the columns. Only input amounts for accounts with balances and do not enter zeros for blank cells. Accounts Payable 5.900 Accounts Receivable 19.600 SMART TOUCH LEARNING Worksheet December 31, 2016 Cash 27,900 Unadjusted Trial Balance Adjustments Common Stock 38,600 Account Names Debit Credit Debit Credit Dividends 5.400 Cash 27900 Furniture 4.400 Accounts Receivable 19600 Notes Payable 6.700 Office Supplies R800 Office Supplies 8.800 Prepaid Rent 12700...
Create an Income Statement, Retained Earnings, and Balance Sheet with the information below: Windsor Inc., a provider of consulting services, was founded on October 1, 2022. At the end of the first month of operations, the company decided to prepare an income statement, retained earnings statement, and balance sheet using the following information. Accounts payable $ 3,300 Supplies $ 2,550 Interest expense 410 Supplies expense 470 Equipment (net) 50,000 Depreciation expense 280 Salaries and wages expense 2,500 Service revenue 20,530...
Cornerstone Exercise 3-25 (Algorithmic) Preparing a Retained Earnings Statement Sparrow Company had the following adjusted trial balance at December 31, 2019. Sparrow Company Adjusted Trial Balance December 31, 2019 Debit $3,150 5,650 Credit Cash Accounts Receivable Prepaid Insurance 4,480 42,000 Equipment Accumulated Depreciation, Equipment Accounts Payable Salaries Payable $24,000 2,800 4,450 3,875 8,000 2,255 Unearned Service Revenue 10,800 99,900 Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Rent Expense Insurance Expense Depreciation Expense Income Taxes Expense 49,400 17,250 2,200...