In: Accounting
Appendix 1: Financial Statements From an End-of-Period Spreadsheet
Alert Security Services Co. offers security services to business clients.
Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 20Y3 |
|||||||||||||
Adjusted Trial Balance | Income Statement | Balance Sheet | |||||||||||
Account Title | Dr. | Cr. | Dr. | Cr. | Dr. | Cr. | |||||||
Cash | 223 | ||||||||||||
Accounts Receivable | 1,637 | ||||||||||||
Supplies | 74 | ||||||||||||
Prepaid Insurance | 56 | ||||||||||||
Land | 1,860 | ||||||||||||
Equipment | 744 | ||||||||||||
Accum. Depr.-Equipment | 149 | ||||||||||||
Accounts Payable | 670 | ||||||||||||
Wages Payable | 74 | ||||||||||||
Common Stock | 40 | ||||||||||||
Retained Earnings | 3,195 | ||||||||||||
Dividends | 149 | ||||||||||||
Fees Earned | 1,823 | ||||||||||||
Wages Expense | 446 | ||||||||||||
Rent Expense | 223 | ||||||||||||
Insurance Expense | 186 | ||||||||||||
Utilities Expense | 130 | ||||||||||||
Supplies Expense | 112 | ||||||||||||
Depreciation Expense-Equip. | 74 | ||||||||||||
Miscellaneous Expense | 37 | ||||||||||||
5,951 | 5,951 |
Prepare an income statement for Alert Security Services Co.
Alert Security Services Co. | ||
Income Statement | ||
For the Year Ended October 31, 20Y3 | ||
$ | ||
Expenses: | ||
$ | ||
Total expenses | ||
$ |
Prepare a statement of stockholders’ equity for Alert Security Services Co. During the year ended October 31, 20Y3, common stock of $6 was issued. If an amount box does not require an entry, leave it blank. If a net loss is incurred or dividends were paid, enter that amount as a negative number using a minus sign.
Alert Security Services Co. | |||
Statement of Stockholders’ Equity | |||
For the Year Ended October 31, 20Y3 | |||
Common Stock | Retained Earnings | Total | |
$ | $ | $ | |
$ | $ | $ |
Prepare a balance sheet for Alert Security Services Co.
Alert Security Services Co. | |||
Balance Sheet | |||
October 31, 20Y3 | |||
Assets | |||
Current assets: | |||
$ | |||
Total current assets | $ | ||
Property, plant, and equipment: | |||
$ | |||
$ | |||
Total property, plant, and equipment | |||
Total assets | |||
Liabilities | |||
Current liabilities: | |||
$ | |||
Total liabilities | $ | ||
Stockholders' Equity | |||
$ | |||
Total stockholders' equity | |||
Total liabilities and stockholders' equity | $ |
Alter Security service co. | |||
Income statement | |||
For the year ended October 31 .2013 | |||
Fees earned | 1,823.00 | ||
Gross Profit | 1,823.00 | ||
Operating Expenses: | |||
Wages expenses | 446.00 | ||
Rent expenses | 223.00 | ||
Utilities expenses | 130.00 | ||
Suppliers expenses | 112.00 | ||
Insurance expenses | 186.00 | ||
Depreciation expenses | 74.00 | ||
Miscellaneous expenses | 37.00 | ||
Total Expenses | 1,208.00 | ||
Net Income | 615.00 | ||
Alter Security service co. | |||
Statement of Stockholders’ Equity | |||
For the year ended October 31 .2013 | |||
Common Stock | Retained earnings | Total | |
Beginning balance | 40.00 | 3,195.00 | |
Add: Net income or Loss | 615.00 | ||
Less: Dividend | -149.00 | ||
40.00 | 3,661.00 | 3,701.00 | |
Alter Security service co. | |||
Balance sheet | |||
For the year ended October 31 .2013 | |||
Assets | |||
Current Assets: | |||
Cash | 223.00 | ||
Accounts Receivable | 1,637.00 | ||
Supplies | 74.00 | ||
Prepaid Insurance | 56.00 | ||
Total Current Assets | 1,990.00 | ||
Property, plant, and equipment: | |||
Land | 1,860.00 | ||
Equipment | 744.00 | ||
Accum Dep Equipment | -149.00 | ||
Total property, plant, and equipment | 2,455.00 | ||
Total Assets | 4,445.00 | ||
Liabilities and Stockholders' Equity | |||
Liabilities | |||
Current Liabilities: | |||
Account payable | 670.00 | ||
Salaries and Wages payable | 74.00 | ||
Total Current Liabilities | 744.00 | ||
Total Liabilities | 744.00 | ||
Stockholders' Equity | |||
Common Stock | 40.00 | ||
Retained Earnings | 3,661.00 | ||
Total Stockholders' Equity | 3,701.00 | ||
Total Liabilities & Stockholders' Equity | 4,445.00 |