| BMGT 495 - Financial Analysis Activity |
| 3 Year TREND ANALYSIS |
| | | | 2013 | 2012 | 2011 |
| Balance Sheet Data |
| Assets |
| Current Assets |
| Cash |
| Accounts Receivable |
| Inventory |
| Total Current Assets | | | 0.00 | 0.00 | 0.00 |
| plus |
| Fixed Assets |
| Machinery & Equipment |
| Buildings |
| Land |
| Total Fixed Assets | | | 0.00 | 0.00 | 0.00 |
| plus |
| Other Assets |
| Patents |
| Goodwill |
| Total Other Assets | | | 0.00 | 0.00 | 0.00 |
| equals |
| Total Assets | | | 0.00 | 0.00 | 0.00 |
| equals |
| Liabilities (Debt) & Owners' Equity (Net Worth) |
| Debt |
| Current (Short-term) Liabilities |
| Accounts Payable |
| Accrued Expenses |
| Short-term Notes Payable |
| Total Current Liabilities | | | 0.00 | 0.00 | 0.00 |
| plus |
| Long-term Liabilities |
| Long-term Notes Payable |
| Bonds Payable |
| Total Long-term Liabilities | | | 0.00 | 0.00 | 0.00 |
| Total Liabilities | | | 0.00 | 0.00 | 0.00 |
| plus |
| Owners' Equity |
| Common Stock |
| Retained Earnings |
| Total Owners' Equity | | | 0.00 | 0.00 | 0.00 |
| equals |
| Total Liabilities & Owners' Equity | | | 0.00 | 0.00 | 0.00 |
| Income Statement Data |
| Revenues/Gross Sales |
| less |
| Cost of Goods Sold (Cost of producing or acquiring product/service to be sold) |
| equals |
| Gross Profit | | | 0.00 | 0.00 | 0.00 |
| less |
| Operating Expenses: |
| Marketing & Selling Expenses |
| General & Administrative Expenses |
| Depreciation Expense |
| Total Operating Expenses | | | 0.00 | 0.00 | 0.00 |
| equals |
| Operating Profits (earnings before interest & taxes) | | | 0.00 | 0.00 | 0.00 |
| less |
| Interest Expense |
| equals |
| Profits before Taxes | | | 0.00 | 0.00 | 0.00 |
| less |
| Income Tax |
| equals |
| Net Profits | | | 0.00 | 0.00 | 0.00 |
scorpio3
spreadsheetsample_financialanalysisactivity.xls
