Question

In: Accounting

Appendix 1: Financial Statements From an End-of-Period Spreadsheet Alert Security Services Co. offers security services to...

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 $

Solutions

Expert Solution

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    

Related Solutions

Appendix: Financial Statements From an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
Appendix: 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, 2016 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 12 Accounts Receivable 103 Supplies 4 Prepaid Insurance 2 Land 190 Equipment 50 Accum. Depr. - Equipment 7 Accounts Payable 36 Wages Payable 1 Common Stock 50 Retained Earnings 210 Dividends 8 Fees Earned...
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Alert...
Appendix: Completing 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, 2016 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 12 Accounts Receivable 103 Supplies 4 Prepaid Insurance 2 Land 190 Equipment 50 Accum. Depr. - Equipment 7 Accounts Payable 36 Wages Payable 1 Common Stock 50 Retained Earnings 210 Dividends 8 Fees Earned 213 Wages...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 2019. In addition, the data for year-end adjustments are as follows: Fees earned, but not yet billed, $34. Supplies on hand, $8. Insurance premiums expired, $42. Depreciation expense, $17. Wages accrued, but not paid, $17. Enter the adjustment data, and place...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business...
Appendix: Adjustment Data on an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 20Y5. In addition, the data for year-end adjustments are as follows: Fees earned but not yet billed, $18. Supplies on hand, $4. Insurance premiums expired, $22. Depreciation expense, $9. Wages accrued but not paid, $9. Enter the adjustment data and place...
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete...
Appendix: Completing an End-of-Period Spreadsheet Alert Security Services Co. offers security services to business clients. Complete the following end-of-period spreadsheet for Alert Security Services Co. If a box does not require an entry, leave it blank. Alert Security Services Co. End-of-Period Spreadsheet (Work Sheet) For the Year Ended October 31, 2019 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 250 Accounts Receivable 1,830 Supplies 83 Prepaid Insurance 62 Land 2,080 Equipment 832...
Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare...
Alert Security Services Co. offers security services to business clients. Based on the end-of-period spreadsheet, prepare the closing entries for Alert Security Services Co. Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2018 1 Adjusted Adjusted 2 Trial Balance Trial Balance Income Statement Income Statement Balance Sheet Balance Sheet 3 Debit Credit Debit Credit Debit Credit 4 Cash 13.00 5 Accounts Receivable 108.00 6 Supplies 8.00 7 Prepaid Insurance 2.00 8 Land 184.00 9 Equipment 50.00...
Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security...
Alert Security Services Co. offers security services to business clients. The trial balance for Alert Security Services Co. has been prepared on the following end-of-period spreadsheet for the year ended October 31, 2016: Alert Security Services Co. End-of-Period Spreadsheet For the Year Ended October 31, 2016 1 Unadjusted Unadjusted Adjusted Adjusted 2 Trial Balance Trial Balance Adjustments Adjustments Trial Balance Trial Balance 3 Debit Credit Debit Credit Debit Credit 4 Cash 18.00 5 Accounts Receivable 90.00 6 Supplies 14.00 7...
Financial Statements from the End-of-Period Spreadsheet Demo Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Demo Consulting is a consulting firm owned and operated by Jesse Flatt. The following end-of-period spreadsheet was prepared for the year ended August 31, 20Y9: Demo Consulting End-of-Period Spreadsheet For the Year Ended August 31, 20Y9 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title   Dr.   Cr.   Dr.   Cr.   Dr.   Cr. Cash 10,230 10,230 Accounts Receivable 24,350 24,350 Supplies 2,580 2,170 410 Land 20,700 20,700 Office Equipment 19,480 19,480 Accumulated Depreciation 2,700 1,290 3,990...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended April 30, 20Y3: During the year ended April 30, 20Y3, common stock of $5,000 was issued. Triton Consulting End-of-Period Spreadsheet For the Year Ended April 30, 20Y3 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 21,500 21,500 Accounts Receivable 51,150 51,150 Supplies 2,400 1,650...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by...
Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended April 30, 20Y3: Triton Consulting End-of-Period Spreadsheet For the Year Ended April 30, 20Y3 Unadjusted Adjusted Trial Balance Adjustments Trial Balance Account Title    Dr.    Cr.    Dr.    Cr.    Dr.    Cr. Cash 17,460 17,460 Accounts Receivable 41,570 41,570 Supplies 4,410 3,700 710 Office Equipment 33,260 33,260 Accumulated Depreciation 4,610 2,200 6,810 Accounts Payable 11,220...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT