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, 2019 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 154 Accounts Receivable 1,126 Supplies 51 Prepaid Insurance 38 Land 1,280 Equipment 512 Accum. Depr.—Equipment 102 Accounts Payable 461 Wages Payable 51 Brenda Schultz, Capital 2,228 Brenda Schultz, Drawing 102 Fees Earned 1,254 Wages Expense 307 Rent Expense 154 Insurance Expense 128 Utilities Expense 90 Supplies Expense 77 Depreciation Expense 51 Miscellaneous Expense 26 Totals 4,096 4,096 Net income (loss) Prepare an income statement for Alert Security Services Co. Alert Security Services Co. Income Statement For the Year Ended October 31, 2019 $fill in the blank 899ff8005021077_2 Expenses: $fill in the blank 899ff8005021077_4 fill in the blank 899ff8005021077_6 fill in the blank 899ff8005021077_8 fill in the blank 899ff8005021077_10 fill in the blank 899ff8005021077_12 fill in the blank 899ff8005021077_14 fill in the blank 899ff8005021077_16 Total expenses fill in the blank 899ff8005021077_17 $fill in the blank 899ff8005021077_19 Prepare a statement of owner's equity for Alert Security Services Co. Negative amounts should be indicated by a minus sign. Alert Security Services Co. Statement of Owner's Equity For the Year Ended October 31, 2019 $fill in the blank 06f4d50a7ffdff0_2 $fill in the blank 06f4d50a7ffdff0_4 fill in the blank 06f4d50a7ffdff0_6 fill in the blank 06f4d50a7ffdff0_8 $fill in the blank 06f4d50a7ffdff0_10 Prepare a balance sheet for Alert Security Services Co. Alert Security Services Co. Balance Sheet October 31, 2019 Assets Current assets: $fill in the blank 2ecb26ff7f87f92_2 fill in the blank 2ecb26ff7f87f92_4 fill in the blank 2ecb26ff7f87f92_6 fill in the blank 2ecb26ff7f87f92_8 Total current assets $fill in the blank 2ecb26ff7f87f92_9 Property, plant, and equipment: $fill in the blank 2ecb26ff7f87f92_11 $fill in the blank 2ecb26ff7f87f92_13 fill in the blank 2ecb26ff7f87f92_15 fill in the blank 2ecb26ff7f87f92_16 Total property, plant, and equipment fill in the blank 2ecb26ff7f87f92_17 Total assets $fill in the blank 2ecb26ff7f87f92_18 Liabilities Current liabilities: $fill in the blank 2ecb26ff7f87f92_20 fill in the blank 2ecb26ff7f87f92_22 Total liabilities $fill in the blank 2ecb26ff7f87f92_23 Owner's Equity fill in the blank 2ecb26ff7f87f92_25 Total liabilities and owner's equity $fill in the blank 2ecb26ff7f87f92_26

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, 2019 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 154 Accounts Receivable 1,126 Supplies 51 Prepaid Insurance 38 Land 1,280 Equipment 512 Accum. Depr.—Equipment 102 Accounts Payable 461 Wages Payable 51 Brenda Schultz, Capital 2,228 Brenda Schultz, Drawing 102 Fees Earned 1,254 Wages Expense 307 Rent Expense 154 Insurance Expense 128 Utilities Expense 90 Supplies Expense 77 Depreciation Expense 51 Miscellaneous Expense 26 Totals 4,096 4,096 Net income (loss) Prepare an income statement for Alert Security Services Co. Alert Security Services Co. Income Statement For the Year Ended October 31, 2019 $fill in the blank 899ff8005021077_2 Expenses: $fill in the blank 899ff8005021077_4 fill in the blank 899ff8005021077_6 fill in the blank 899ff8005021077_8 fill in the blank 899ff8005021077_10 fill in the blank 899ff8005021077_12 fill in the blank 899ff8005021077_14 fill in the blank 899ff8005021077_16 Total expenses fill in the blank 899ff8005021077_17 $fill in the blank 899ff8005021077_19 Prepare a statement of owner's equity for Alert Security Services Co. Negative amounts should be indicated by a minus sign. Alert Security Services Co. Statement of Owner's Equity For the Year Ended October 31, 2019 $fill in the blank 06f4d50a7ffdff0_2 $fill in the blank 06f4d50a7ffdff0_4 fill in the blank 06f4d50a7ffdff0_6 fill in the blank 06f4d50a7ffdff0_8 $fill in the blank 06f4d50a7ffdff0_10 Prepare a balance sheet for Alert Security Services Co. Alert Security Services Co. Balance Sheet October 31, 2019 Assets Current assets: $fill in the blank 2ecb26ff7f87f92_2 fill in the blank 2ecb26ff7f87f92_4 fill in the blank 2ecb26ff7f87f92_6 fill in the blank 2ecb26ff7f87f92_8 Total current assets $fill in the blank 2ecb26ff7f87f92_9 Property, plant, and equipment: $fill in the blank 2ecb26ff7f87f92_11 $fill in the blank 2ecb26ff7f87f92_13 fill in the blank 2ecb26ff7f87f92_15 fill in the blank 2ecb26ff7f87f92_16 Total property, plant, and equipment fill in the blank 2ecb26ff7f87f92_17 Total assets $fill in the blank 2ecb26ff7f87f92_18 Liabilities Current liabilities: $fill in the blank 2ecb26ff7f87f92_20 fill in the blank 2ecb26ff7f87f92_22 Total liabilities $fill in the blank 2ecb26ff7f87f92_23 Owner's Equity fill in the blank 2ecb26ff7f87f92_25 Total liabilities and owner's equity $fill in the blank 2ecb26ff7f87f92_26

Corporate Financial Accounting

14th Edition

ISBN:9781305653535

Author:Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:Carl Warren, James M. Reeve, Jonathan Duchac

Chapter4: Completing The Accounting Cycle

Section: Chapter Questions

Problem 4.23EX: Appendix 1 Completing an end-of-period spreadsheet Alert Security Services Co. offers security...

See similar textbooks

Related questions

Question

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, 2019

	Adjusted Trial Balance	Income Statement	Balance Sheet
Account Title	Dr.	Cr.	Dr.	Cr.	Dr.	Cr.
Cash	154
Accounts Receivable	1,126
Supplies	51
Prepaid Insurance	38
Land	1,280
Equipment	512
Accum. Depr.—Equipment			102
Accounts Payable			461
Wages Payable			51
Brenda Schultz, Capital			2,228
Brenda Schultz, Drawing	102
Fees Earned			1,254
Wages Expense	307
Rent Expense	154
Insurance Expense	128
Utilities Expense	90
Supplies Expense	77
Depreciation Expense	51
Miscellaneous Expense	26
Totals	4,096		4,096
Net income (loss)

Prepare an income statement for Alert Security Services Co.

Alert Security Services Co.
Income Statement
For the Year Ended October 31, 2019
		$fill in the blank 899ff8005021077_2
Expenses:
	$fill in the blank 899ff8005021077_4
	fill in the blank 899ff8005021077_6
	fill in the blank 899ff8005021077_8
	fill in the blank 899ff8005021077_10
	fill in the blank 899ff8005021077_12
	fill in the blank 899ff8005021077_14
	fill in the blank 899ff8005021077_16
Total expenses		fill in the blank 899ff8005021077_17
		$fill in the blank 899ff8005021077_19

Prepare a statement of owner's equity for Alert Security Services Co. Negative amounts should be indicated by a minus sign.

Alert Security Services Co.
Statement of Owner's Equity
For the Year Ended October 31, 2019
		$fill in the blank 06f4d50a7ffdff0_2
	$fill in the blank 06f4d50a7ffdff0_4
	fill in the blank 06f4d50a7ffdff0_6
		fill in the blank 06f4d50a7ffdff0_8
		$fill in the blank 06f4d50a7ffdff0_10

Prepare a balance sheet for Alert Security Services Co.

Alert Security Services Co.
Balance Sheet
October 31, 2019
Assets
Current assets:
		$fill in the blank 2ecb26ff7f87f92_2
		fill in the blank 2ecb26ff7f87f92_4
		fill in the blank 2ecb26ff7f87f92_6
		fill in the blank 2ecb26ff7f87f92_8
Total current assets			$fill in the blank 2ecb26ff7f87f92_9
Property, plant, and equipment:
		$fill in the blank 2ecb26ff7f87f92_11
	$fill in the blank 2ecb26ff7f87f92_13
	fill in the blank 2ecb26ff7f87f92_15	fill in the blank 2ecb26ff7f87f92_16
Total property, plant, and equipment			fill in the blank 2ecb26ff7f87f92_17
Total assets			$fill in the blank 2ecb26ff7f87f92_18
Liabilities
Current liabilities:
		$fill in the blank 2ecb26ff7f87f92_20
		fill in the blank 2ecb26ff7f87f92_22
Total liabilities			$fill in the blank 2ecb26ff7f87f92_23
Owner's Equity
			fill in the blank 2ecb26ff7f87f92_25
Total liabilities and owner's equity			$fill in the blank 2ecb26ff7f87f92_26

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.