*Complete the problems in an Excel spreadsheet. Be sure to show your work to receive credit; no hard keys.

Problem 2-1: Preparing Financial Statements

Information below is for Warner Manufacturing, Inc. for the year ended December 31, 20x1 except where beginning of year numbers indicated. All amounts in SAR unless otherwise stated.

Using the information below:

1. Prepare an income statement with the proper title

2. Prepare end of year balance sheet with the proper title

3. Calculate net working capital

4. Calculate the debt ratio

*Complete the problems in an Excel spreadsheet. Be sure to show your work to receive credit; no hard keys.

DATA
Depreciation expense		66,000
Cash		220,000
Long-Term Debt		330,000
Net Sales		615,000
Accounts payable		102,000
Marketing and general and administrative expenses		79,000
Buildings and Equipment		895,000
Notes payable		7,5000
Accounts receivable		156,000
Interest expense		4,750
Accrued expenses		7,900
Common Stock		289,000
Cost of Goods sold		297,000
Inventory		99,300
Taxes		67,300
Accumulated Depreciation		-26,3000
Prepaid expenses		14,500
Taxes payable		55,000
Retained earnings		262,900

Problem 2-2 Preparing Statement of Cash Flows

Given the following information, prepare a statement of cash flows.

DATA
Increase in accounts receivable		30
Increase in inventories		30
Operating Income		95
Interest Expense		30
Increase in accounts payable		25
Dividends		15
Increase in common stock		20
Increase in net fixed assets		23
Depreciation Expense		12
Income taxes		17
Beginning cash		20

Assume all amounts are in 000's SAR.