Depreciation Expense 66,000

Cash 225,000

Long term debt 334,000

Sales 573,000

Accounts Payable 127,000

General & Administrative Expense 79,000

Buildings and equipment 895,000

Notes Payable 75,000

Accounts Receivable 153,000

Interest Expense 4,750

Accrued Operating Expense 7,900

Common Stock 289,000

Cost of Goods Sold 297,000

Inventory 124,300

Taxes 50,500

Accumulated Depreciation 263,000

Prepaid Expense 14,500

Taxes Payable 53,000

Retained Earnings 262,900

In an Excel file, prepare a balance sheet and income statement for the Trinity, Inc. from the following scrambled list of items. (note: you are solving for Net Income) Calculate the following ratios (using the Excel ratios): Current Ratio Quick Ratio (also called Acid Test) Working Capital Inventory Turnover Operating Profit Margin Debt Ratio Return on Equity