you have to put the cell equations (Not numbers in itself), such as =A2+C3-D5 or =SUM(C3:C7), etc.

Accumulated depreciation Accumulated Retained earnings Unearned revenue Current maturities of long-term debt Cash & Cash equivalents Bonds payable Accounts receivable Plant and equipment-original cost Inventory Marketable securities Other Investments 18 Current Assets Cash & Cash Equivalents Marketable Securities Accounts Receivable Less: Allowance for bad debts Prepaid Expenses Inventory 25 Total Current Assets 26 Other Assets: Investment Fixed Assets Plant and equipment Less: Accumulated depreciation" Net plant and equipment 34 Total assets QI Home X cut Paste Accessibility: Investigate Insert Format Painter Clipboard Page Layout Formulas Data Review View Help Wrap Text Comments 16 Share General B11Jv +08 Normal Calculation Conditional Formatting v Format as Table v Bad Check Cell Styles Good Explanatory Neutral Input Insert Delete cells Format AutoSum v Fillv Clear v Merge & Center v Alignment Sort & Find & Filter v Select v Analyze Analysis Font Accumulated depreciation Number 30,000 7,000 12,000 22,000 31,000 100,000 40,000 78,000 Editing 1. Arrange the following items in proper balance sheet presentation below. go,ooo 14,000 sg,ooo 16,000 120,000 35,000 680,000 83,000 30,000 65,000 Balance Sheet Current liabilities Accounts payable Allowance for Oad debts Accrued expense Prepaid expenses Notes payable Common stock, Sl par, shares outstanding Preferred stock, $540 par, @1 ,OOO shares outstanding Paid-in capital in excess of par (common stock) Accounts payable Notes payable unearned Revenue Accrued Expenses Current Maturities oflsng-term Debt Total Current Liabilities Long-term Liabilities Bonds payable Total liabilities Stockholders' equity: Preferred stock ($50 par@ 1 ,OOO shares Common stock (Sl par share Capital paid in excess of par Accumulated Retained earnings Stockholders' equity Total liabilities and stockholders' equity