Financial Accounting Project Assignment

The Wiley Department Store is located near the Village shopping mall. At the close of the year ended December 31, 2007, the following accounts appeared in two of its trial balances.

Trial Balances

Analysis reveals the following additional data:

1. A physical inventory was conducted for year ended December 31, 2007 and the inventory was valued at $70,000.

2. Insurance expense and utilities expense are, 60% selling and 40% administrative.

3. $20,000 of the mortgage payable is due for payment next year.

4. Depreciation on the building and property tax expense are administrative expenses; depreciation on the equipment is a selling expense.

5. The beginning balance of accounts receivable is $64,750.

6. The amount of total assets at the beginning of the year is $321,725.

Instructions

1) Journalize the adjusting entries.

2) Prepare a multiple-step income statement and a retained earnings statement for the year and a classified balance sheet as of December 31, 2007.

3) Journalize the closing entries.

4) Prepare a post-closing trial balance.

5) Prepare the following ratios and show all support for your computations:

a) Current Ratio
b) Quick Ratio
c) Working Capital
d) Accounts Receivable Turnover
e) Average Collection Period
f) Inventory Turnover
g) Days in Inventory
h) Debt to Total Assets Ratio
i) Gross Profit Ratio
j) Profit Margin Ratio
k) Return on Assets Ratio
l) Asset Turnover Ratio

6) Based on the ratios computed in 5) above, answer the following questions and use the financial statement ratios to support your answers where appropriate:

• Do you feel that the company is able to meet its current and long term obligations as they become due?

• Comment on the profitability of the company with respect to the various profitability ratios that you computed.

• Would you lend money to this company for the long term?

• Comment on the ability of the company to collect its receivables and mange inventory.