need help with balancing.Not sure what i did wrong and question 1

i did send everything i have

U1 A220 BCDEFGHIJ Module 3 Assignment: Prepare the statement of retained earnings and balance sheet for Ma and Pa Calculate the current ratio for the year. Sales Revenue Equipment Accounts Payable Sales Discounts Advertising Expense Interest Expense Wages Payable Accounts Receivable Building Common Stock Sales returns and Allownaces Utilities Expense Inventory Commission Expense Cost of goods sold Accumulated depreciation equipment Unearned sales revenue Prepaid Rent Office salaries expense Accumulated depreciation-building Rent Expense Dividends 322,800 104,000 16,500 2,200 12,600 1,700 1,600 6,900 140,000 35,000 6,700 10,300 16,400 22,300 158,400 26,400 2,500 1,200 52,000 40.500 5,800 14,000 M3 Assignment Mo Ready Calibri = = -111-AA Ha Paste LG Wrap Text gea Gente A E Clipboard Alignment CS1 X for Ma and Pa Grocery cash retained earnings dielivery expense insurance expense mortgage payable(long term) Supplies 7,800 87,600 1.200 5,700 37,000 500 Requirements: Prepare the Statement of Retained Earnings for the period ending 12/31/20XX. Assume a net income of 543. Ma and Pa Grocery Statement of Retained Earnings For the year ending 12/31/20XX Retained Earnings, 1/1/20XX S87,600 Plus: Net Income 43,800 Less: Dividends 14,000 Net Increase in Retained Earnings Retained Earnings, 12/31/20XX Prepare the Balance Sheet for the period ending 12/31/20XX. Ms and Pa Grocery M3 Assignment Ready * Assignments - AXVAC2209 X assignment_mod Help day - Read-Only - Excel Search Data Review 2. Water General insert Calbei BIU Page Layout Formulas -11 -AA O A. Merge & Center %, 88 Conditional Format Formatting Table Styles Font Alignment CDEFGH PQRS Ma and Pa Grocery Balance Sheet 12/31/20XX Current Assets Cash Accounts Receivable 16,500 1,600 52.500 20.600 Supplies Prepaid Rent Total Current Assets Fixed Assets Equipment Less Accumulated Depreciation Equipment Building Less: Accumulated Depreciation Building Total Assets LCurrent Liabilities: 57.800l Accounts Payable 15.900 Wages Payable 15,400 Unearned Sales Revenue Total Current Liabilities 1,200 Long-Term Liabilities $32,900 Mortgage Payable Tatal Liabilities STOCKHOLDER'S EQUITY 77.600 Common Stock Retained Earnings 63.500 Total Stockholder's Equity $174.000 Total liabilities and Stockholder's Equity $37,000 557,600 26.400 S140 000 $35,000 87,600 5122 500 $180,200 Calculate the constrate for the year. Show your work. Formulare Assets Current Liabilities Current Ratio M3 Assignment Merge a Center Clipboard Alignment U1 A220 Module 3 Assignment: Prepare the statement of retained earnings and balance sheet for Ma and Pa Grocery as of Decembe Calculate the current ratio for the year Sales Revenue Equipment Accounts Payable Sales Discounts Advertising Expense Interest Expense Wages Payable Accounts Receivable Building Common Stock Sales returns and Allownaces Utilities Expense Inventory Commission Expense Cost of goods sold Accumulated depreciation equipment Unearned sales revenue Prepaid Rent Office salaries expense Accumulated depreciation building Rent Expense Dividends M3 Assignment MOReady 322,800 104,000 16,500 2,200 12,600 1,700 1,600 6,900 140,000 35,000 6,700 10,300 16,400 22,300 158.400 26,400 2,500 1,200 52,000 40,500 5,800 14.000 * ce Wap let BIU A Clipboard Meige & Center Alignment vi x fe Module 3 Assignment: Prepare the statement of retained earnings and balance sheet for Ma and Pa Grocery as of Decem Calculate the current ratio for the year Sales Revenue Equipment Accounts Payable Sales Discounts Advertising Expense Interest Expense Wages Payable Accounts Receivable Building Common Stock Sales returns and Allownaces Utilities Expense Inventory Commission Expense Cost of goods sold 20 Accumulated depreciation-equipment Unearned sales revenue Prepaid Rent Office salaries expense Accumulated depreciation building Rent Expense Dividends M3 Assignment Ready 322,800 104,000 16,500 2,200 17,600 1,700 1,600 6,900 140,000 35,000 6,700 10,300 16,400 22,300 158,400 26,400 2,500 1,200 52,000 40,500 5,800 14,000 21 26 Wekome to Student Portal X Lesson Content - AZIVACOXX AutoSave File Home = My insert Page Layout Formulas Data Review Indias_module3_1123305 Help Sear X View Calibri AA Paste LD BI U Wrap Tet Merge & Center - General O Clipboard $ - % Alignment Q26 Number 4 KM 28 Dividends cash retained earnings dielivery expense insurance expense mortgage payable long term) Supplies 14,000 7,800 87,600 1,300 5,700 37.000 34 Requirements: $ Prepare the Statement of Retained Earnings for the period ending 12/31/20XX. Assume a met income of $43.800 Ma and Pa Grocery Statement of Retained Earnings For the year ending 12/31/20XX Retained Earnings, 1/1/2014 $87,500 Plus: Net Income 131.400 Less: Dividends 117 400 Net Increase in Retained Earnings Retained Earnings, 12/31/20XX $ % Prepare the Balance Sheet for the period ending 12/31/20XX. M3 Assignment Portal X lesson Content - AZAVAC220 X ome Insert ndies_module_112320134 - Excel Help Review View Page Layout Formulas 11-A A = = - - A-EE Calibri BIU - Search Wrap Text General Mergea Center Font $ - % 9 9 Conditional Fo Formatting C D E F Net Increase in Retained Earnings Retained Earnings, 12/31/2004 G H M N O P Q R Prepare the Balance Sheet for the period ending 12/31/20XX. Ma and Pa Grocery Balance Sheet 12/11/20xx Current Assets Cash Accounts Receivable Inventory Supplies Prepaid Rent Total Current Assets Fixed Assets Equipment tess: Accumulated Depreciation Equipment Building Less: Accumulated Depreciation Building Total Assets Current Liabilities: 57,00 Accounts Payable 26,900 Wages Payable 16.400 Uneamed Sales Revenue Total Current Liabilities 1,200 Lone-Term Liabilities $32.900 Mortgage Payable Total Liabilities $104 000 STOCKHOLDER S EQUITY 26.400 77,600 Common Stock $140,000 Retained Earnings 40,50099 500 Total Stockholder's Equity 5210 000 Total liabilities and Stockholder's Equity M3 Assignment X77 X fer Current Assets: Cash Accounts Receivable Inventoru Supplies Prepaid Rent Total Current Assets Fixed Assets: Equipment Less: Accumulated Depreciation, Equipment Building Less: Accumulated Depreciation, Building Total Assets Balance Sheet 12/31/20xx LIA Current Liabilities: S7,800 Accounts Payable 6,900 Wages Payable 16,400 Unearned Sales Revenue 600 Total Current Liabilities 1,200 Long Term Liabilities: $32,900 Mortgage Payable Total Liabilities STOCKHOLI 77,600 Common Stock Retained Earnings 99,500 Total Stockholder's Equity $210,000 Total Liabilities and Stockholde $104,000 26,400 $140,000 40,500 Calculate the current ratio for the year. Show your work. Formula: Current Assets / Current Liabilities Current Ratio M3 Assignment DOLL