Q$1$: Arrange the following items in proper balance sheet presentation below. Work on the blue colored cells only.

Don't put the numbers directly. You have to use the cell operations, i$.$e$.,=$A$3-$G$3.$

Current Assets:

Cash & Cash Equivalents

Marketable Securities

Accounts Receivable

Less: Allowance for bad debts

Prepaid Expenses

Inventory

Total Current Assets

Other Assets: Investment

Fixed Assets:

Plant and equipment

Less: Accumulated depreciation$**$

Net plant and equipment

Current liabilities:

Accounts payable

Notes payable

Unearned Revenue

Accrued Expenses

Current Maturities of Long$-$term Debt

Total Current Liabilities

Long$-$term Liabilities

Bonds payable

Total liabilities

Stockholders' equity:

Preferred stock $($ $$40$ par @ $1,000$ shares$)$

Common stock $($ $$1$ par @$100,000$ shares$)$

Capital paid in excess of par

Accumulated Retained earnings

Stockholders' equity