| Template 19 |
| Balance Sheet and Income Statement Derived from Template 18 |
| See Chapter 20 for a discussion of this topic. |
| Below are Financial Statements that are linked to Template 18. The data you insert in |
| Template 18 will be used to update this template automatically. When Excel asks if you |
| wish to update this file automatically with values from Template 18, you should click on "Yes". |
| Be sure to have both Templates 18 and 19 open at the same time. |
| Executive Corporation |
| Income Statement |
| For the Year Ending December 31, 2018 |
| Revenue | | $0.00 |
| Less Expenses: |
| Cost of Goods Sold | $10,000.00 |
| Labor | 0.00 |
| Interest | 0.00 |
| Insurance | 0.00 |
| Depreciation | 0.00 |
| Total Expenses | | 10,000.00 |
| Net Income | | ($10,000.00) |
| Retained Earnings Balance 1/1/18 | | xx |
| Dividends Declared 2003 | | 0.00 |
| Retained Earnings Balance 12/31/18 | | ($10,000.00) |
| Executive Corporation |
| Balance Sheet |
| As of December 31, 2013 |
| ASSETS |
| Current Assets: |
| Cash | $325,000.00 |
| Prepaid Insurance | 0.00 |
| Accounts Receivable | 0.00 |
| Inventory | 0.00 |
| Total Current Assets | | $325,000.00 |
| Fixed Assets: |
| Plant and Equipment, net | | 0.00 |
| TOTAL ASSETS | | $325,000.00 |
| EQUITIES |
| LIABILITIES |
| Current Liabilities: |
| Accounts Payable | $0.00 |
| Wages Payable | 0.00 |
| Total Current Liabilities | | $0.00 |
| Long-Term Liabilities |
| Mortgage Payable | | 0.00 |
| TOTAL LIABILITIES | | $0.00 |
| STOCKHOLDERS' EQUITY |
| Common Stock | | $0.00 |
| Retained Earnings | | (10,000.00) |
| TOTAL STOCKHOLDERS' EQUITY | | ($10,000.00) |
| TOTAL LIABILITIES & STOCKHOLDERS' EQUITY | | ($10,000.00) |
excel_123
Template19-BalanceSheetandIncomeStatement-ch20.xls
