Please fill these tables and calculate: for Quarter 1 -2 -3 - 4
| Debt ratio |
| Total Liabilities |
| Total Assets |
| Debt ratio |
| Times Interest Earned Ratio |
| EBIT |
| Interest charges |
| Times interest earned |
| Current ratio |
| Current assets |
| Current liabilities |
| Current ratio |
| Quick ratio |
| Current assets |
| Inventory |
| Current liabilities |
| Quick ratio |
| Liquidity ratio |
| Cash and cash equ. |
| |
| Current liabilities |
| Quick ratio |
| Inventory Turnover Ratio |
| Cost of Goods Sold |
| Average Inventory |
| Inventory Turnover |
| Total Asset Turnover |
| Sales |
| Total Assets |
| Gross profit margin |
| Gross Profit Margin |
| Sales |
| Cost of sales |
| Gross profit margin |
| Net Profit Margin |
| Net Income |
| Sales |
| Net profit margin |
| Return on Equity |
| Earnings after taxes |
| Stockholder's equity |
| Return on equity |
| Earnings Per Share (EPS) Ratio |
| Net income |
| Shares of common stock outstanding |
| EPS |
| Equity ratio |
| Total Equity |
| Total Assets |
| Equity ratio |
ANNUAL INCOME = ANNUAL BALANCE SHEET ANNUAL CASH FLOW Forecasted 2ND QTR 3RD QTR Total 1999 1ST QTR 4TH QTR Actual 2002 1ST QTR Forecast 2ND QTR 3RD QTR 4TH QTR Sales Sales Cost of sales $2,000,000 $1,500,000 $1,300,000 $2,010,100 Actual 2002 Gross profit $451,000 $350,000 $400,000 $10,000 $90,360 $657,534 $630,411 $60,000 $229,233 $493, 151 $590,959 $45,090 $469,196 $427,397 $575,178 $76,320 ($945,586) $660,855 $1,186,002 $50,000 Cash flows from operating activities Net Income Expenses Operating expenses Interest Depreciation Amortization Total expenses $424,000 $16,250 $32,500 $1,250 $318,000 $16,250 $33,958 $1,250 $275,600 $16,250 $33,958 $1,250 $426,141 $16,250 $33,958 $1,250 $6,810,100 ASSETS SO Current Assets Cash and cash equivalents $6,810,100 Accounts receivable Inventory Other current assets $1,443,741 Total Current Assets $65,000 $134,374 Fixed Assets $5,000 Land $1,648,115 Buildings Equipment $5,161,985 $ Subtotal Less-accumulated depreciation Total Fixed Assets $518,700 $370,000 Intangible Assets $888.700 Cost Less-accumulated amortization Total Intangible Assets $6,050,685 $ Other assets SO Total Assets $100,000 $1,500,000 $800,000 Operating income ($30,000) ($6,500) $39,000 $5,700 ($767,125) $400,000 Other income and expenses Gain (loss) on sale of assets Other (net) Subtotal $100,000 $20,000 $10,000 $50,000 $3,000 $100,000 $ $405,700 $200,000 $50,000 $20,000 $26,032 Income before tax Please enter a tax percentage Taxes @ 30% $13,684 $25,000 Net income SO Actual 1999 ($13,860) Detailed Supporting Information Items not requiring an outlay of cash: Amortization $112,500 $125,000 $137,500 $150,000 Deferred income taxes $1,450,000 $1,450,000 $ $ $1,450,000 $1,450,000 $ $875,000 $875,000 $875,000 $875,000 Income taxes payable Stock-based compensation $432.500 $466,458 $500,416 S534,374 Other Net changes in working capital items Net cash provided by operating activities $50,000 $50,000 $50,000 $50,000 Cash flows from financing activities $21,250 $22,500 $23,750 $25,000 Issuance of share capital Additional paid-in capital Excess tax benefits from stock-based compensation $33,000 $120,000 $5,000 $23,000 Common shares repurchased pursuant to Common Share Repurchase Program Forecast Repayment of debt 1ST QTR 2ND QTR 3RD QTR 4TH QTR Net cash provided by (used in) financing activities Cash flows from investing activities $328,767 $328,767 $328,767 $328,767 Acquisition of long-term investments $50,000 $50,000 $50,000 $50,000 Proceeds on sale or maturity of long-term investments $100,000 $100,000 $100,000 $100,000 Acquisition of capital assets $183,300 $52,663 $14,983 (5188,735) Acquisition of intangible assets $83,288 $54,137 $ $12,000 $12,000 $12,000 $12,000 Business acquisitions Acquisition of short-term investments Proceeds on sale or maturity of short-term investments Net cash used in investing activities $500,000 $500,000 $500,000 $500.000 Effect of foreign exchange gain (loss) on cash and $90,000 $90,000 $90,000 $90,000 $27,000 $27,000 $27,000 $27,000 cash equivalents $90,000 $40,000 $40,000 $40,000 Net increase (decrease) in cash and cash equivalents for the year Cash and cash equivalents, beginning of year 1,000 Cash and cash equivalents, end of year 1,000 1,000 1,000 $100,000 $100,000 $100,000 $100,000 $50,000 $50,000 $50,000 $50,000 S1,890,700 $2,076,579 $ $2,174,538 $1,747,157 $ Cost of sales Direct labor Materials Other costs $320,000 $500,000 $125,000 $240,000 $500,000 $125,000 $208,000 $500,000 $125,000 $321,616 $500,000 $125,000 LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities Accounts payable Notes payable Current portion of long-term debt Income taxes Accrued expenses Other current liabilities Total Current Liabilities $1,089,616 $2,000,000 $500,000 $600,000 $100,000 $100,000 $30,000 $90,000 $16,000 UT ($511,085) $412,765 ($835,326) ($688,915) ($47,576) ($918,256) $749,065 $62,466 Non-Current Liabilities Long-term debt Deferred income Deferred income taxes Other long-term liabilities $600,000 $100,000 $30,000 $50,000 ($2,684) Total Liabilities ($345,943) $1,185,492 Shares Outstanding Capital stock issued Additional paid in capital Retained earnings 1,000 $100,000 $50,000 $1,400,000 Equity Total Liabilities and Equity
