I need some assistance like asap Thanks w 01P12 Excel O X

I need some assistance like asap. Thanks !

w 01P.1-2 - Excel - O X Announce x Ps 1 Wint x \\ c Survey i x \\ C sos ..IN X E - e a Secure | https://tritoned.ucsd.edu/bbcswebdav/pid-1179924-dt... @ # : PS 1 Winter 2018.pdf 2/4 CO + + what you want to do altrejo@outlook.com E - OX e Share E AutoSum . AYO V Fill - Insert Delete Format Sort & Find & Clear Filter - Select - Editing h. What amounts of local assets, labilmes, and equity wII IN CO. report on the year-end balance sheet? O Search Screenshots Cells Problem 2-2 Cairns Inc started their business in 2017 and had the following transactions W X Y Z AA AB AC AD AE AF A Cairns Inc Acquired $157,500 cash from the issue of common stock Cairns Provided services for $36.000 cash. Cairns Provided S99,000 of services on account. Cairns Collected $31,500 cash from the account receivable created in Event 3. Cairns Paid $8.100 cash to purchase supplies, Treat this transaction as Operating Expenses ps Cairns Collected S63,000 cash from the account receivable created in Event 3. Cairns Received $19,800 cash in advance for services to be performed in the future. Cairns Performed 90.0% of the services agreed to in Event 7. Cairns Paid S54.000 cash for salaries expense. Caims Incurred S12,600 of other operating expenses on account. Statement of Cash | 10 Expense: = Net Inc. CF Type REQUIRED Record the preceding transactions in the horizontal statements model. Also, in the Cash Fkows column, classify the cash flows as operating activities (OA), investing activities (IA), or financing activities (FA). See \"Horizontal Statements Model\" file on TritonEd for guidance. 1/9/20 181:44 PM Problem 3-1 The following information is available for two different types of businesses for the 2016 accounting period. Earl CPAs is a service business that provides accounting services to small businesses. Griffin is a merchandising business that sels sports clothing to college students. Data for Earl CPAs E O - - + 7096 1 0 Type here to search po e o L \" a 9 x wa 2. ENG 4:17 PM * ao » INTL 1/22/2018 i

Solution

Balance Sheet Income Statement Cash Flow Assets = Liabilities + Stock Holders\' Equity Revenue - Expenses Event Cash + Accounts + Supplies Accounts + Unearned Common + Retained Service - Salaries + Operating Receivable Payable Revenue stock Earnings Revenue Expense Expenses CF CF type 1 157500 + + = + + 157500 + - + 157500 Financing 2 36000 + + = + + + 36000 36000 - + 36000 Operating 3 + 99000 + = + + + 99000 99000 - + 4 31500 + -31500 + = + + + - + 31500 Operating 5 -8100 + + 8100 = + + + - + -8100 Operating 6 63000 + -63000 + = + + + - + 63000 Operating 7 19800 + + = + 19800 + + - + 19800 Operating 8 + + = + -17820 + + 17820 17820 - + 9 -54000 + + = + + + -54000 - -54000 + -54000 Operating 10 + + = 12600 + + + -12600 - + -12600 Totals 245700 + 4500 + 8100 = 12600 + 1980 + 157500 + 86220 152820 - -54000 + -12600 245700