Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

The trial balance of the Wall Fashion Center, Inc. contained the following accounts at December 31, 2007 the end of the companys calendar year. WALL

The trial balance of the Wall Fashion Center, Inc. contained the following accounts at December 31, 2007 the end of the companys calendar year.

WALL FASHION CENTER, INC.

Trial Balance

31-Dec-07

Debit

Credit

Cash

$ 16,700

Accounts Receivable

33,700

Merchandise Inventory (Beginning)

38,000

Store Supplies

5,500

Store Equipment

85,000

Accumulated Depreciation-Store Equipment

$ 18,000

Delivery Equipment

48,000

Accumulated Depreciation-Delivery Equipment

6,000

Notes Payable

51,000

Accounts Payable

48,500

Common Stock

80,000

Retained Earnings

30,000

Dividends

12,000

Sales

746,600

Sales Returns and Allowances

4,200

Purchases

503,600

Purchase Returns and Allowances

6,900

Purchase Discounts

3,700

Freight-in

10,800

Salaries Expense

140,000

Advertising Expense

26,400

Utilities Expense

17,000

Repair Expense

9,100

Delivery Expense

16,700

Rent Expense

24,000

$ 990,700

$ 990,700

Adjustment data:

Store supplies on hand totaled $3,500.

Depreciation is $9,000 on the store equipment and $7,000 on the delivery equipment.

Interest of $11,000 is accrued on notes payable at December 31.

Other data:

Merchandise inventory on hand at December 31, 2007 is $45,000.

Salaries expense is 70% selling and 30% administrative.

Rent expense and utilities expense are 80% selling and 20% administrative.

$30,000 of notes payable are due for payment next year.

Repair expense is 100% administrative.

The beginning balance of accounts receivable is $31,250.

The amount of total assets at the beginning of the year is $199,700.

Instructions

Journalize the adjusting entries.

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

Journalize the closing entries.

Prepare a post-closing trial balance.

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.

2004

2005

2006

Industry Average

Liquidity

Current

1.09

1.30

1.80

1.42

Quick

0.89

1.08

1.28

1.10

Working Capital

$ 10,000.00

$ 13,500.00

$ 18,000.00

$ 20,000.00

Leverage

Debt to Total Assets (%)

52.03%

48.52%

43.61%

40.00%

Times Interest Earned

1.50

3.50

4.75

5.00

Activity

Inventory Turnover (sales)

12.56

13.85

14.02

19.98

Fixed Asset Turnover

9.50

9.98

10.50

10.25

Total Asset Turnover

5.34

6.92

7.12

6.40

Average Collection Period (days)

15.57

14.05

12.41

15.00

Accounts Receivable Turnover

23.12

25.62

29.01

28.64

Days in Inventory

29.06

26.35

26.03

24.52

Profitability

Gross Profit Margin (%)

40.98%

45.27%

49.02%

48.82%

Net Profit (%)

6.98%

9.99%

13.01%

12.35%

Return on Total Assets (%)

10.86%

11.25%

12.09%

11.36%

Return on Equity (%)

20.56%

23.07%

25.12%

24.59%

Payout Ratio

45.00%

45.00%

45.00%

35.26%

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