I have 1 and 2. NEED 3 (stockholder equity) and 4 (Balance Sheet). Part 1 Using
ID: 2424158 • Letter: I
Question
I have 1 and 2. NEED 3 (stockholder equity) and 4 (Balance Sheet).
Part 1
Using the account listing in the appendix, you are to create standard financial statements for the corporation, namely: 1) Income Statement, 2) Retained Earnings Statement, 3) Statement of Stockholders’ Equity, and 4) Balance Sheet. Note: a Microsoft Excel spreadsheet of this data will be made available to you. Also, in preparation for the financial statements, you may want to prepare an unadjusted Trial Balance, as the data provided is pre-closing December 31, 2015.
Fort Myers General Merchandise Co. Data provided in Grey Chart of Accounts and balances as of 12/31/2015 Selected Balances provided as of 12/31/2014 Balances Selected Balances Acct No. Description 12/31/2015 12/31/2014 1100 Cash 84,500 73,050 1120 Accounts Receivable 247,450 253,975 1150 Merchandise Inventory 550,000 383,475 1160 Prepaid Insurance 4,800 2,400 1170 Store Supplies 4,000 750 1230 Store Equipment 569,500 1240 Accumulated Depreciation—Store Equipment 70,700 56,700 2100 Accounts Payable 209,000 198,525 2110 Salaries Payable 47,750 42,625 2210 Long-term Notes 300,000 300,000 3100 Common Stock (10,000 shares issued, $25 Par) 250,000 250,000 3110 Capital in Excess of Par Value 100,000 100,000 3120 Dividends Paid 100,000 3200 Retained Earnings 335,300 335,300 4100 Sales 5,032,350 4,225,135 4110 Sales Returns and Allowances 113,700 15,955 4120 Sales Discounts 61,600 35,455 5100 Cost of Merchandise Sold 3,012,150 2,300,422 5200 Sales Salaries Expense 727,800 5210 Advertising Expense 292,000 5220 Depreciation Expense 14,000 5230 Store Supplies Expense 9,800 5290 Miscellaneous Selling Expense 12,600 5300 Office Salaries Expense 417,700 5310 Rent Expense 88,700 5320 Insurance Expense 12,000 5390 Miscellaneous Administrative Expense 7,800 5650 Interest Expense 15,000 Total Assets at 12/31/2014 1,125,138Explanation / Answer
Financial statements are prepared as under:
Fort Myers General Merchandise Co.
Fort Myers General Merchandise Co.
Fort Myers General Merchandise Co.
Fort Myers General Merchandise Co.
1,389,550
Also Trial Balance is prepared as under:
Fort Myers General Merchandise Co.
Retained Earning Statement For the Year Ended December 31'2015 Particulars Amount ($) Amount ($) Opening Balance 335,300 Add: Net income of year 247,500 Less: Dividend paid 100,000 Closing balance 482,800Fort Myers General Merchandise Co.
Income statement For the Year Ended December 31'2015 Particulars Amount ($) Amount ($) Sales 5,032,350 Less: Sales return and allowances 113,700 Less: Sales discounts 61,600 Net sales 4,857,050 Cost of Merchandise Sold 3,012,150 Gross profit 1,844,900 Sales Salaries Expense 727,800 Advertising Expense 292,000 Depreciation Expense 14,000 Store Supplies Expense 9,800 Miscellaneous Selling Expense 12,600 Office Salaries Expense 417,700 Rent Expense 88,700 Insurance Expense 12,000 Miscellaneous Administrative Expense 7,800 Interest Expense 15,000 1,597,400 Net Income 247,500Fort Myers General Merchandise Co.
Statement of Owner's Equity For the Year Ended December 31'2015 Particulars Amount ($) Amount ($) Opening capital 250,000 Plus: Investments by Owner 0 Net Income 482,800 Less: Withdrawal by Owner 0 Clsing capital 732,800Fort Myers General Merchandise Co.
Balance Sheet For the Year Ended December 31'2015 Particulars Amount ($) Amount ($) ASSETS Current Assets: Accounts Receivables 247,450 Cash 84,500 Merchandise inventory 550,000 Prepaid Insurance 4,800 Store Supplies 4,000 Total Current Assets 890,750 Store Equipment 569,500 Less: Accumulated Depreciation 70,700 498,800 Total Assets 1,389,550 LIABILITIES AND STOCKHOLDERS EQUITY Liabilities : Current Liabilities Accounts Payable 209,000 Salaries Payable 47,750 Total Current Liabilities Long-term Notes 300,000 Stockholders' equity 732,800 Capital in Excess of Par Value 100,000 Total Stockholders' Equity Total Liabilities and stockholders’ equity1,389,550
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.