Old MathJax webview

Old MathJax webview

description for excel spreadsheet reads please fill out the spreadsheet for the RainBird car wash company.

and this is the spreadsheet that needs to be completed

Create a Balance Sheet for Year ended January 31, 20XY Rainbird Car Wash Company Balance Sheet January 31, 20XY Assets 0 Total Current Assets Property Plant and Equipment Total Property, plant and Equipment Total Assets Liabilities Total Liabilities Shareholders Equity Module 2 Deliverable Save ACG2209-Deliverable-2-Assignment (1) - Excel Search Off Home Insert Formulas View Data Help Page Layout Review Calibri - Au General 29 Wrap Text X Cut Copy Format Painter BIU a. A- Merge & Center $ %) Conditional Formatting Clipboard Number Font Alignment X for A B D F G H 1 The balances for the accounts listed below appear on which financial statement and which account category: Financial statements: Account categories: Income statement or Balance Sheet Assets, Liabilities, Shareholders' Equity, Revenues or Expenses 1. Salaries Payable 2. Fees Earned 3. Accounts Payable 4. Common Stock 5. Supplies Expense 6. Unearned Rent 7. Retained Earnings 8. Equipment 9. Accounts Receivable 10. Accumulated Depreciation 11. Salary Expense 12. Depreciation Expense Financial Statement Account Category Balance Sheet Liabilities Income statement Revenue Balance Sheet Liabilities Balance Sheet Equity Income statement Expenses Balance Sheet Liabilities Balance Sheet Equity Balance Sheet Assets Balance Sheet Assets Balance Sheet Liabilities Income statement Expenses Income statement Expenses 2 The following are the figures for the adjusted trial balance of Rainbird Car Wash Company (a fictitious company) after the acco Debit Credit 580 4,250 Adjusted Trial Balance Account Title Cash Accounts Receivable Supplies Prepaid Insurance Land Equipment Module 2 Deliverable 193 145 4,830 1,932 ady Type here to search O i Styles Cells Editing Ideas Seng f B D E F G H K L M N O Q R 2 The following are the figures for the adjusted trial balance of Rainbird Car Wash Company (a fictitious company) after the accounts had been adjusted on January 31, 20XY, the end of the fiscal year. Adjusted Trial Balance Account Title Cash Debit Credit 580 4,250 193 145 4,830 1,932 386 1,739 193 Accounts Receivable Supplies Prepaid Insurance Land Equipment Accum. Depr. - Equipment Accounts Payable Wages Payable Common Stock Retained Earnings Dividends Service Fees Earned Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense-Equip. Miscellaneous Expense 80 8,325 386 4,733 1,159 580 483 338 290 193 97 15,456 15,456 Create an Income Statement for Year ended January 31, 20XY. AutoSave ACG2209-Deliverable-2-Assignment (1) - Excel Search OH Data Review View File Formulas Help Home Insert Page Layout E = Calibri 11 General Wrap Text X Cut La Copy Format Painter ' ' a- A- Paste BIU EEE Merge & Center $ % Alignment Num! Clipboard Font E61 : X f F D G B E A 193 Depreciation Expense-Equip. Miscellaneous Expense 97 15,456 15,456 12 3 14 25 16 47 48 Create an Income Statement for Year ended January 31, 20XY. 49 50 51 52 Rainbird Car Wash Company Income Statement For the year ended January 31, 20XY Service Fees Earned 4,733 53 54 1,159 55 56 57 580 483 58 Expenses: Wages Expense Rent Expense Insurance Expense Utilities Expense Supplies Expense Depreciation Expense-Equip Miscellaneous Expense Total Expenses 59 60 61 338 290 193 97 62 3,140 63 64 1,593) Net Income 65 66 Create a Statement of Retained Earnings 67 68 69 Rainbird Car Wash Company Statement of Retained Earnings January 31, 20XY Module 2 Deliverable 70 Ready Type here to search o M199 AutoSave OH ACG2209-Deliverable-2-Assignment (1) - Excel Search File Home Insert Page Layout Formulas Data Review View Help Calibri 11 - ' ' = Wrap Text General a x Cut LECopy aste Format Painter BIU A Merge & Center $ % Clipboard Font 6 Alignment Num 61 X fox A B D E G F Rainbird Car Wash Company Statement of Retained Earnings January 31, 20XY Beginning Retained Earnings +/- Net Income/Net Loss - 3 4 Less Dividends 5 Ending Retained Earnings 7 8 9 Create a Balance Sheet for Year ended January 31, 20XY 0 1 2 Rainbird Car Wash Company Balance Sheet January 31, 20XY 3 4 Assets 5 -6 37 38 39 20 0 Total Current Assets Property Plant and Equipment 21 22 33 24 95 96 Module 2 Deliverable Ready (99+ Type here to search AutoSave CH T ACG2209-Deliverable-2-Assignment (1) - Excel Ele Home Insert Page Layout Formulas Data Review View Help Calibri 11 X Cut LECopy Format Painter & Wrap Text Merge & Center - aste BI U U A Clipboard Font Alignment 51 f A B E D Total Current Assets 0 Property Plant and Equipment Total Property, Plant and Equipment Total Assets ol Liabilities Total Liabilities Shareholders Equity Total Shareholders Equity 1 Total Liabilities and S/H Equity Module 2 Deliverable eady Type here to search be TA