accounting homework
mr.5rmasho
horizontalanalysisexampleinexcel.xlsBalance Sheet
| Company ABC, Inc, | |||||
| Balance Sheet | |||||
| As of | 12/31/13 | 12/31/12 | 12/31/11 | 12/31/10 | |
| Assets | |||||
| Current Assets | |||||
| Cash And Cash Equivalents | 1,587,000 | 1,670,000 | 906,000 | 1,156,000 | |
| Short Term Investments | 61,000 | 49,000 | 52,000 | 64,000 | |
| Net Receivables | 2,027,000 | 1,899,000 | 1,821,000 | 1,858,000 | |
| Inventory | 2,634,000 | 2,486,000 | 2,502,000 | 2,119,000 | |
| Other Current Assets | 271,000 | 277,000 | 350,000 | 250,000 | |
| Total Current Assets | 6,580,000 | 6,381,000 | 5,631,000 | 5,447,000 | |
| Property Plant and Equipment | 486,000 | 528,000 | 484,000 | 508,000 | |
| Long Term Investments | 120,000 | 113,000 | 99,000 | 101,000 | |
| Goodwill | 1,204,000 | 1,281,000 | 1,553,000 | 1,539,000 | |
| Total Assets | 8,390,000 | 8,303,000 | 7,767,000 | 7,595,000 | |
| Liabilities | |||||
| Current Liabilities | |||||
| Accounts Payable | 1,825,000 | 1,790,000 | 1,887,000 | 1,694,000 | |
| Short/Current Long Term Debt | 1,347,000 | 1,505,000 | 1,291,000 | 1,621,000 | |
| Other Current Liabilities | 1,265,000 | 1,033,000 | 1,017,000 | 1,310,000 | |
| Total Current Liabilities | 4,437,000 | 4,328,000 | 4,195,000 | 4,625,000 | |
| Long Term Debt | 653,000 | 1,207,000 | 991,000 | 1,342,000 | |
| Total Liabilities | 5,090,000 | 5,535,000 | 5,186,000 | 5,967,000 | |
| Stockholders' Equity | |||||
| Common Stock | 209,000 | 209,000 | 209,000 | 931,000 | |
| Retained Earnings | 2,761,000 | 1,905,000 | 1,577,000 | 535,000 | |
| Treasury Stock | 321,000 | 641,000 | 791,000 | 159,000 | |
| Capital Surplus | 9,000 | 13,000 | 4,000 | 3,000 | |
| Total Stockholder Equity | 3,300,000 | 2,768,000 | 2,581,000 | 1,628,000 | |
| Total Liabilities and Equity | 8,390,000 | 8,303,000 | 7,767,000 | 7,595,000 |
BS - Horizontal
| Company ABC, Inc, | |||||
| Balance Sheet | |||||
| As of | 12/31/13 | 12/31/12 | 12/31/11 | 12/31/10 | |
| Assets | |||||
| Current Assets | |||||
| Cash And Cash Equivalents | 137.28% | 144.46% | 78.37% | 100.00% | |
| Short Term Investments | 95.31% | 76.56% | 81.25% | 100.00% | |
| Net Receivables | 109.10% | 102.21% | 98.01% | 100.00% | |
| Inventory | 124.30% | 117.32% | 118.07% | 100.00% | |
| Other Current Assets | 108.40% | 110.80% | 140.00% | 100.00% | |
| Total Current Assets | 120.80% | 117.15% | 103.38% | 100.00% | |
| Property Plant and Equipment | 95.67% | 103.94% | 95.28% | 100.00% | |
| Long Term Investments | 118.81% | 111.88% | 98.02% | 100.00% | |
| Goodwill | 78.23% | 83.24% | 100.91% | 100.00% | |
| Total Assets | 110.47% | 109.32% | 102.26% | 100.00% | |
| Liabilities | |||||
| Current Liabilities | |||||
| Accounts Payable | 107.73% | 105.67% | 111.39% | 100.00% | |
| Short/Current Long Term Debt | 83.10% | 92.84% | 79.64% | 100.00% | |
| Other Current Liabilities | 96.56% | 78.85% | 77.63% | 100.00% | |
| Total Current Liabilities | 95.94% | 93.58% | 90.70% | 100.00% | |
| Long Term Debt | 48.66% | 89.94% | 73.85% | 100.00% | |
| Total Liabilities | 85.30% | 92.76% | 86.91% | 100.00% | |
| Stockholders' Equity | |||||
| Common Stock | 22.45% | 22.45% | 22.45% | 100.00% | |
| Retained Earnings | 516.07% | 356.07% | 294.77% | 100.00% | |
| Treasury Stock | 201.89% | 403.14% | 497.48% | 100.00% | |
| Capital Surplus | 300.00% | 433.33% | 133.33% | 100.00% | |
| Total Stockholder Equity | 202.70% | 170.02% | 158.54% | 100.00% | |
| Total Liabilities and Equity | 110.47% | 109.32% | 102.26% | 100.00% |
Income Statement
| Company ABC, Inc, | |||||
| Income Statement | |||||
| For the year ending | 12/31/13 | 12/31/12 | 12/31/11 | 12/31/10 | |
| Total Revenue | 14,492,000 | 14,883,000 | 13,322,000 | 11,990,000 | |
| Cost of Goods Sold | 7,352,000 | 7,780,000 | 6,993,000 | 6,260,000 | |
| Gross Profit | 7,140,000 | 7,103,000 | 6,329,000 | 5,730,000 | |
| Operating Expenses | 1,825,000 | 1,790,000 | 1,887,000 | 1,694,000 | |
| Research Development | 1,347,000 | 1,505,000 | 1,291,000 | 621,000 | |
| Selling General and Administrative | 1,265,000 | 1,033,000 | 1,017,000 | 1,310,000 | |
| Interest Expense | 134,000 | 120,000 | 87,000 | 14,000 | |
| Other Expenses | 145,000 | 1,450,000 | 234,000 | 1,344,000 | |
| Total Operating Expenses | 4,716,000 | 5,898,000 | 4,516,000 | 4,983,000 | |
| Operating Income (or Loss) | 2,424,000 | 1,205,000 | 1,813,000 | 747,000 | |
| Income Tax Expense | 73,000 | 97,000 | 108,000 | 112,000 | |
| Net Income (or Loss) | 2,351,000 | 1,108,000 | 1,705,000 | 635,000 |
IS - Horizontal
| Company ABC, Inc, | |||||
| Income Statement | |||||
| For the year ending | 12/31/13 | 12/31/12 | 12/31/11 | 12/31/10 | |
| Total Revenue | 120.87% | 124.13% | 111.11% | 100.00% | |
| Cost of Goods Sold | 117.44% | 124.28% | 111.71% | 100.00% | |
| Gross Profit | 124.61% | 123.96% | 110.45% | 100.00% | |
| Operating Expenses | 107.73% | 105.67% | 111.39% | 100.00% | |
| Research Development | 216.91% | 242.35% | 207.89% | 100.00% | |
| Selling General and Administrative | 96.56% | 78.85% | 77.63% | 100.00% | |
| Interest Expense | 957.14% | 857.14% | 621.43% | 100.00% | |
| Other Expenses | 10.79% | 107.89% | 17.41% | 100.00% | |
| Total Operating Expenses | 94.64% | 118.36% | 90.63% | 100.00% | |
| Operating Income (or Loss) | 324.50% | 161.31% | 242.70% | 100.00% | |
| Income Tax Expense | 65.18% | 86.61% | 96.43% | 100.00% | |
| Net Income (or Loss) | 370.24% | 174.49% | 268.50% | 100.00% |
