AutoSave OR 12 assignment mod_03 (1) - Excel File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 11 X Cut Ih Copy ~ Format Painter Clipboard BIU -A A 23 Wrap Text A E Merge & C Font Alignment 01 A C D F G 4 H N 5 6 8 10 11 H 15 15 17 10 D 20 21 Sales Revenue Equipment Accounts Payable Sales Discounts Advertising Expense Interest Expense Wages Payable Accounts Receivable Building Common Stock Sales returns and Alonces Ulries Expense Inventory Commission Expense Cost of goods sold Accumulated depreciation equipment Unewned sales revenue Prepaid Rent Office salaries e pense Accumulated depreciation building Rent Expense Dividends cash et ned earnings delvery expense insurance expense mortgage payable long term) Supplies 3922800 104000 16.500 2.200 12.600 1.700 1600 6.900 140.000 35.000 6.700 20.300 18,400 22.300 158 400 26,400 2.500 1200 52.000 40.500 800 14.000 7,800 87,600 1300 5,700 37 000 600 26 27 28 30 31 23 Requirements: 38 37 1 40 41 42 42 Prepare the Statement of Retained Earnings for the period ending 12/3120XX. Assume a net income of $43,800 Ma and Pa Grocery Statement of Retained Earnings For the year ending 12/31/20XX Retained Earnings, 1920XX Plus: Net Income Les Dividends Net Increase in Retained Earnings Retained ning 12/3120XX 46 47 48 50 2 Prepare the Balance Sheet for the period ending 12/31/20XX Search AutoSave assignment_mod 03 (1) - Excel OM 128 Formulas Review Data View Help File Home Draw Insert Page Layout 2 Wrap Text General Calibri - A A A EE X cut Paste Ib Copy Format Painter Clipboard $ % BIU FR Merge & Center Alignment Nur Font U1 > M J K N P O B QR 40 D E F G H 1 Ma and Pa Grocery Statement of Retained Earnings For the year ending 12/31/20XX Retained Earnings, 1/1/20XX Plus: Net Income Less: Dividends Net Increase in Retained Earnings Retained Earnings 12/31/20XX 45 06 48 30 2 51 Prepare the Balance Sheet for the period ending 12/31/20x6. Ma and Pa Grocery Balance Sheet 12/31/20xx ASSETS LIABILITIES Current Assets Current Liabilities: Cash Accounts Payable nts Receivabl Wapes Payable Inventoru Unearned Sales Revenue Supplies Total Current Liabilities Prepaid Rent Long-Term Liabilities: Total Current Assets Mortgage Payable Fixed Assets Total Liabilities Equipment STOCKHOLDER'S EQUITY less: Accumulated Depreciation Equipment Common Stock Building Retained Earnings Less Accumulated Depreciation Building Total Stockholder's Equity Total Assets Total Liabilities and Stockholder's Equity 9 3 Calculate the current ratio for the year. Show your work. Formula: Current Assets Current Liabilities Current Ratio M3 Assignment