| Complete blue highlighted areas only for week 1. There are no calculations this week. Keep a copy of this spreadsheet for use in week 4 and 5. |
| Table I Vertical and Horizontal Analysis | | | | Be sure to use formulas for you vertical and horizontal analysis |
| Company Name | | | | Vertical Analysis year 1 | Vertical Analysis Year 2 | Horizontal Analysis |
| Income Statement | Year 1 (enter the years used) | Year 2 | Year 3 |
| Sales Revenue |
| Cost of Goods Sold |
| Gross (Profit) Margin |
| Total Operating Expenses (selling, mkting, admin) |
| Earnings from Operations |
| Interest Expense |
| Income Taxes |
| Net Earnings (after tax) |
| Balance Sheet |
| Cash/cash equivalents (cash) |
| Investments (short term) |
| Net Accounts Receivable (Trade) |
| Inventory (materials, WIP, FG) |
| Total Current Assets |
| Net Fixed Assets(PPE, net) |
| Total Assets |
| Total Current Liabilities |
| Total Noncurrent Liabilities |
| Total Liabilities |
| Total Stockholders Equity |
| Total liabilities + Stockholders Equity |
| Other Information |
| Stock Price at end of year |
| Dividends paid Common shareholder |
| Outstanding Shares Common Stock |
| Basic EPS (Earnings Per Share) |
| Treasury Stock |
| Auditing Firm |
bkaneh
CompanySpreadsheet.xlsx
