Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 DepreciationStore 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,138

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cases in Finance

Authors: Jim DeMello

3rd edition

1259330476, 1259330478, 9781259352652 , 978-1259330476

More Books

Students also viewed these Finance questions

Question

Explain the pages in white the expert taxes

Answered: 1 week ago