Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, I could use some help solving this. This was the information I was given. Thanks! Appendix 1: Financial Statements From an End-ofPeriod Spreadsheet Alert

Hi, I could use some help solving this. This was the information I was given. Thanks!

image text in transcribedimage text in transcribedimage text in transcribed
Appendix 1: Financial Statements From an End-ofPeriod Spreadsheet Alert Security Services Co. offers security services to business clients. Alert Security Services Co. End-ofPeriod Spreadsheet For the Year Ended October 31, 2018 Adjusted Trial Balance Income Statement Balance Sheet Account Title Dr. Cr. Dr. Cr. Dr. Cr. Cash 222 Accounts Receivable 1,628 Supplies 74 Prepaid Insurance 56 Land 1,850 Equipment 740 Accum. Depr. Equipment 148 Accounts Payable 566 Wages Payable 74 Common Stock 40 Retained Earnings 3,180 Dividends 148 Fees Earned 1,313 Wages Expense 444 Rent Expense 222 Insurance Expense 185 Utilities Expense 1.30 Supplies Expense 111 Depreciation Expense - Equip. 74 Miscellaneous Expense 37 5,921 5,921 Prepare an income statement for Alert Security Services Co. Alert Security Services Co. Income Statement For the Year Ended October 31, 2018 Fees earned Expenses: Wages expense Rent expense HEB Insurance expense Utilities expense 130 Supplies expense Depreciation expense - equipment 74 Miscellaneous expense 37 \"Q Total expenses Net income Prepare a retained earnings statement for Alert Security Services Co. Alert Security Services Co. Retained Earnings Statement For the Year Ended October 31, 2018 Retained earnings, November 1, 2017 a Net income D C] Dividends Change in retained earnings Retained earnings, October 31, 2013 D Prepare a balance sheet for Alert Security Services Co. Alert Security Services Co. Balance Sheet October 31, 2018 Assets Current assets: Cash $ Cl Accounts receivable E] Cl C] Supplies Prepaid insurance Total current assets $:] Property, plant, and equipment: ) Land $ Equipment $C] Accumulated depreciation - equipment C] Accounts payable C] Total property, plant, and equipment C] Total assets Liabilities Current liabilities: Accounts payable $C] Wages payable C] Total liabilities $C] stockholders' Egung Common stock $C] Cl Total stockholders' equity [:1 Total liabilities and stockholders' equity $C]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Human Resource Management

Authors: Raymond Noe

5th Edition

0471737933, 9780471737933

More Books

Students also viewed these Accounting questions