Review ABC Company

SpreadsheetABC1.xlsx

OBJ

Balance Sheet
Company Name: ABC, Inc
Amounts In: ($)
Period: Fiscal
Statement Type:
Date: December 31	1996	1997	1998	1999
ASSETS
Cash & Cash Equivalents
Marketable Securities
Accounts Receivable, net
Inventories
Prepaid Expenses
Other Current Assets
Total Current Assets	- 0	- 0	- 0	- 0
Net Fixed Assets
Investments
Intangibles
Other Assets
Total Assets	- 0	- 0	- 0	- 0
LIABILITIES & STOCKHOLDERS' EQUITY
Accounts Payable
Notes Payable - Banks
Current Maturities of Long Term Debt
Accrued Liabilities
Other Current Liabilities
Total Current Liabilities	- 0	- 0	- 0	- 0
Deferred Federal Income Taxes
Long-Term Debt
Subordinated Debt
Total Liabilities	- 0	- 0	- 0	- 0
Common Stock
Additional paid-in capital
Retained Earnings
Treasury Stock
Total Stockholders' Equity	- 0	- 0	- 0	- 0
Total Liabilities & Stockholders' Equity	- 0	- 0	- 0	- 0

Statements of Earnings and Retained Earnings
Company Name: ABC, Inc
Amounts In: ($)
Period: Fiscal
Statement Type:
Date: December 31	1996	1997	1998	1999
Total Sales - Revenues
Cost of Goods Sold
Gross Profit	- 0	- 0	- 0	- 0
Selling, Gen & Adm Expenses
Advertising
Lease Payments
Officers' Salaries
Bad Debt Expense
Depreciation and amortization
Repairs and maintenance
Net Operating Income (Profit)	- 0	- 0	- 0	- 0
Interest Income
Interest Expense
Other Income
Other Expense
Net Income Before Taxes	- 0	- 0	- 0	- 0
Income Taxes
Net Income Before Extra Items	- 0	- 0	- 0	- 0
Extraordinary Income
Extraordinary Charges
Net Income (Loss)	- 0	- 0	- 0	- 0
Beginning Retained Earnings		- 0	- 0	- 0
Net Profit		- 0	- 0	- 0
Cash Dividends
Other Deductions
Other Additions
Ending Retained Earnings	- 0	- 0	- 0	- 0

Statement of Cash Flow
Company Name: ABC, Inc
Amounts In: ($)
Period: Fiscal
Statement Type:
Date: December 31	1996	1997	1998	1999
Cash Flows from Operations
Net Income				- 0
Noncash revenue and expense included in net income
Depreciation and amortization				- 0
Change in Deferred Income Taxes				- 0
Cash provided (used) by current assets and liabilities
Change in Accounts Receivable				- 0
Change in Inventory				- 0
Change in Prepaid Expenses				- 0
Change in Other Current Assets				- 0
Change in Accounts Payable				- 0
Change in Accrued Liabilities				- 0
Change in Other Current Liabilities				- 0
Total Cash Flows from Operations	- 0	- 0	- 0	- 0
Cash Flows from Investing
Change in Fixed Assets				- 0
Change in Other Investing Activities				- 0
Total Cash Flows from Investing	- 0	- 0	- 0	- 0
Cash Flows from Financing
Change in Short-term Borrowings				- 0
Change in Long-term Borrowings				- 0
Cash Dividends Paid				- 0
Change in Common Stock				- 0
Total Cash Flows from Financing	- 0	- 0	- 0	- 0
Net Change in Cash and Marketable Securities	- 0	- 0	- 0	- 0

Common Size Balance Sheet
Company Name: ABC, Inc
Amounts In: (%)
Period: Fiscal
Statement Type:
Date: December 31	1996	1997	1998	1999
ASSETS
Cash & Cash Equivalents
Marketable Securities
Accounts Receivable, net
Inventories
Prepaid Expenses
Other Current Assets
Total Current Assets	- 0	- 0	- 0	- 0
Net Fixed Assets
Investments
Intangibles
Other Assets
Total Assets	- 0	- 0	- 0	- 0
LIABILITIES & STOCKHOLDERS' EQUITY
Accounts Payable
Notes Payable - Banks
Current Maturities of Long Term Debt
Accrued Liabilities
Other Current Liabilities
Total Current Liabilities	- 0	- 0	- 0	- 0
Deferred Federal Income Taxes
Long-Term Debt
Subordinated Debt
Total Liabilities	- 0	- 0	- 0	- 0
Common Stock
Additional paid-in capital
Retained Earnings
Treasury Stock
Total Stockholders' Equity	- 0	- 0	- 0	- 0
Total Liabilities & Stockholders' Equity	- 0	- 0	- 0	- 0

Common Size Income Statement
Company Name: ABC, Inc
Amounts In: (%)
Period: Fiscal
Statement Type:
Date: December 31	1996	1997	1998	1999
Total Sales - Revenues
Cost of Goods Sold
Gross Profit	- 0	- 0	- 0	- 0
Selling, Gen & Adm Expenses
Advertising
Lease Payments
Officers' Salaries
Bad Debt Expense
Depreciation and amortization
Repairs and maintenance
Net Operating Income (Profit)	- 0	- 0	- 0	- 0
Interest Income
Interest Expense
Other Income
Other Expense
Net Income Before Taxes	- 0	- 0	- 0	- 0
Income Taxes
Net Income Before Extra Items	- 0	- 0	- 0	- 0
Extraordinary Income
Extraordinary Charges
Net Income (Loss)	- 0	- 0	- 0	- 0

Financial Ratios
Company Name: ABC, Inc
Amounts In: ($ in Summary)
Period: Fiscal
Statement Type:					Better/
Date: December 31	1996	1997	1998	1999	Worse
Financial Summary
Current Assets
Current Liabilities
Total Assets
Total Liabilities
Total Net Worth
Net Working Capital
Working Assets
Working Liabilities
Working Investment
Long Term Debt
Tangible Net Worth
Average Annual Long-term Debt Maturities
Current Maturities of LTD
Operating Cash Flow
Net Sales
Net Income
Liquidity/Activity Ratios
Current Ratio (x)
Quick Ratio (x)
Cash Flow Liquidity Ratio (x)
Sales/Working Capital (x)
Accounts Receivable (x)
Accounts Receivable (Days)
Inventory Turnover vs COGS (x)
Inventory Turnover vs Aver Sales (Days)
Accounts Payable vs COGS (Days)
Accounts Payable vs Aver Sales (Days)
Cash Conversion Cycle (Days)
Leverage Ratios
Debt Ratio (%)
Long-term Debt to Total Capitalization (%)
Debt to Worth (x)
Debt to Tangible Net Worth (x)
(Net Profit+Depr/Depl/Amort)/CMLTD (x)
Times Interest Earned (x)
Fixed Charge Coverage (x)
Cash Flow Adequacy (x)
Performance Ratios
Fixed Asset Turnover (x)
Total Asset Turnover (x)
Gross Profit Margin (%)
Operating Profit Margin (%)
Net Profit Margin (%)
Cash Flow Margin (%)
Profit Before Taxes/Total Assets (%)
Return on Assets (%)
Return on Equity (%)
Cash Return on Assets (%)
Sales Growth (%)
Earnings Growth (%)
Total Asset Growth (%)