Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

This project will require you to prepare Financial Statements from a list of accounts and balances using a Trial Balance worksheet. The financial statements you

This project will require you to prepare Financial Statements from a list of accounts and balances using a Trial Balance worksheet. The financial statements you are to prepare include:

1) Income Statement

2) Retained Earnings Statement

3) Statement of Stockholders Equity

4) Balance Sheet.

5) Statement of cash flow (using the Indirect method)

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

Part 2

From the statements prepared in part 1 above, calculate the following financial ratios and other analysis. Note: selected balances for year ended December 31st,2014 are provided should they be needed. 1) Working capital 2) Current Ratio 3) Quick Ratio 4) Accounts Receivable Turnover 5) Number of days sales in receivables 6) Inventory turnover 7) Number of days sales in Inventory 8) liabilities to Stockholder's equity 9) Net sales to assets 10) rate earned on total assets 11) rated earned on Stockholders equity 12) Rate earned on common Stockholders equity 13) Earnings per share on common stock Summarize the state ,status and health of the company. You might request that facilitate a stronger analysis about the operations and financial conditions of the company, as well as, in the industry

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions