This is a 3-Part Excel Assignment. I'm offering $10 for each part and if a 90/A or better is received I will include a $10 bonus.

1. Biven Corporation's balance sheet and income statement appear below: BALANCE SHEETS 2006 2005 $35,000 54,000 67,000 580,000 (316,000) $420,000 $30,000 49,000 58,000 530,000 (313,000) $354,000 LIABILITIES & EQUITIES Accounts payable $51,000 Wages payable 26,000 Taxes payable 11,000 Deferred taxes payable 25,000 Bonds payable (long term) 77,000 Total liabilities 190,000 Common stock 33,000 Retained earnings 197,000 Total equities 230,000 Total liabilities & equities $420,000 $57,000 24,000 10,000 24,000 90,000 205,000 30,000 119,000 149,000 $354,000 INCOME STATEMENTS 2006 Sales $620,000 Cost of goods sold 381,000 Gross margin 239,000 Selling & Admin expense 103,000 Net operating income 136,000 Gain on sale of plant & equipment 20,000 Income before tax 156,000 Income tax 47,000 Net income $109,000 2005 $520,000 300,000 220,000 99,000 121,000 121,000 36,000 $85,000 Cash & equivalents Accounta receivable Inventory Plant & equipment Accumulated depreciation Total Assets ASSETS Cash dividends were $31,000. The company sold equipment for $20,000. The equipment had originally cost $14,000 and was fully depreciated. Required: Prepare a statement of cash flows for 2006 using the indirect and direct methods. 2. Biven Corporation's balance sheet and income statement appear below: BALANCE SHEETS 2006 ASSETS Cash & equivalents $35,000 Accounta receivable 54,000 Inventory 67,000 Plant & equipment 580,000 Accumulated depreciation (316,000) Total Assets $420,000 2005 $30,000 49,000 58,000 530,000 (313,000) $354,000 LIABILITIES & EQUITIES Accounts payable $51,000 Wages payable 26,000 Taxes payable 11,000 Bonds payable 77,000 Deferred taxes 25,000 Total liabilities 190,000 Common stock 33,000 Retained earnings 197,000 Total equities 230,000 Total liabilities & equities $420,000 $57,000 24,000 10,000 90,000 24,000 205,000 30,000 119,000 149,000 $354,000 INCOME STATEMENTS 2006 Sales $620,000 Cost of goods sold 381,000 Gross margin 239,000 Selling & Admin expense 103,000 Net operating income 136,000 Gain on sale of plant & equipment 20,000 Income before tax 156,000 Income tax 47,000 Net income $109,000 2005 $520,000 300,000 220,000 99,000 121,000 121,000 36,000 $85,000 Cash dividends were $31,000. The company sold equipment for $20,000. The equipment had originally cost $14,000 and was fully depreciated. Required: Fill in the Amounts and Percent of change in the balance sheet and income statements. Increase (Decrease) Amount Percent 3. Espinola Corporation's most recent balance sheet and income statement appear below: BALANCE SHEETS ASSETS Cash & equivalents Accounta receivable Inventory Prepaid expenses Total current assets Plant & equipment, net Total Assets Accounts payable Accrued payable Notes payable, current Total current liabilities Bonds payable Total liabilities 2006 2005 $320,000 220,000 140,000 20,000 700,000 860,000 $1,560,000 $180,000 240,000 130,000 20,000 570,000 920,000 $1,490,000 LIABILITIES & EQUITIES Preferred stock, $100 par value, 5% Common stock, $1 par value Additional paid in capital, common stock Retained earnings Total equities Total liabilities & equities INCOME STATEMENT Sales Cost of goods sold Gross margin Selling & Admin expense Net operating income Interest expense Income before tax Income tax Net income Dividends paid, preferred Net income for common shareholders Dividends paid, common Net income added to retained earnings Beginning retained earnings Ending retained earnings Other: Market value of stock end of year Tax rate Bond interest Return demanded on preferred stock Return demanded on common stock Required compute the following for 2006 : a. Gross margin percentage. b. Earnings per share (of common stock). c. Priceearnings ratio. d. Dividend payout ratio. dividend per share dividend payout ratio e. Dividend yield ratio. f. Return on total assets. after tax cost of interest average total assets return on total assets g. Return on common stockholders' equity. average stockholders equity average preferred stock return on equity h. Book value per share. i. Working capital. j. Current ratio. k. Acidtest ratio. l. Accounts receivable turnover. m. Average collection period (days). n. Inventory turnover. o. Average sale period (days). p. Times interest earned. q. Debttoequity ratio. r. Show that financial leverage is positive or negative. $200,000 80,000 40,000 320,000 210,000 530,000 $170,000 80,000 40,000 290,000 220,000 510,000 100,000 100,000 150,000 680,000 1,030,000 $1,560,000 100,000 100,000 150,000 630,000 980,000 $1,490,000 2006 $1,220,000 790,000 430,000 268,000 162,000 26,000 136,000 41,000 95,000 5,000 90,000 40,000 50,000 630,000 $680,000 $12.87 30% 10% 10% 14%