Use Excel Functions Please

An office party on New Years Eve overflowed into the accounting department of your corporation, causing ink to be spilled onto a balance sheet. The accountants are furious, especially because they are never invited to the parties. Can you help them by supplying the missing numbers?

The balance sheet for problem #1 (in $000s)

	Year 2	Year 1	Change
Assets
Cash and securities	$ 512	$ 453	$_______
Accounts receivable	$ 1,325	$_______	$ +104
Inventory	$_______	$ 8,386	$_______
Total Current Assets	$_______	$_______	$ +300
Equipment	$_______	$ 33,929	$ +8,010
Less: Accumulated depreciation	$ 12,657	$_______	$ +1,362
Net equipment	$_______	$_______	$_______
Buildings	$ 95,129	$_______	$ 0
Less: Accumulated depreciation	$_______	$ 51,237	$ +2,251
Net buildings	$_______	$_______	$_______
Land	$ 73,012	$_______	$ 0
Fixed Assets	$_______	$_______	$_______
Total Assets	$_______	$_______	$_______
Liabilities and Equity
Accounts payable	$_______	$ 1,423	$ +76
Bank loans	$ 3,664	$_______	$ 32
Debt due within year	$ 1,483	$ 1,327	$_______
Total Current Liabilities	$_______	$_______	$_______
Total Long-Term Debt	$_______	$_______	$_______
Common stock ($.10 par)	$ 1,500	$ 1,500	$_______
Paid-in-surplus	$ 45,546	$_______	$ 0
Retained earnings	$_______	$_______	$_______
Total Equity	103,323	$102,876	$_______
Total Liabilities and Equity	$_______	$_______	$_______