Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the information in the adjusted trial balance 2018&2019, prepare the statement of the financial position for the years ending December 31,2018&2019 Excel File Edit
Using the information in the adjusted trial balance 2018&2019, prepare the statement of the financial position for the years ending December 31,2018&2019
Excel File Edit Tools Data Window Help V 20% A Wed 8:27 PM Q View Insert Format DEU: AutoSave OFF Home Assignment Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri Bochyi 11 Ir sert v 22 Wrap Text General WE ~ A AY 27 42 LE I Delele Psic BIU dos Sart & Y Merpe & Center v Y Find Conditional Forma: Formatting Table Cell Styles Format v w Filter , B19 XVfx Accrued water charges A B C F F G H 1 x M N P R 5 T W 2018 200 1,250 500 150) 60 100 100 150 1.000 (100) 1 Adjusted Trial Balance for the year ended December 31, 2 10001 Casilin hand 3 3 10002 Cash at bank 4 10009 Trade receivables 5 10004 Allowance fur doubtful accounts 6 10005 Preaald rent 7 7 1000G Prepaid supplies 8 10007 Inventory 9 10008 Land 10 10009 Duilding 11 10010 Accumulate Depreciation for Buildire 12 10011 Long-Term investments 13 20001 Trade payables 14 20002 Zakat payable 15 20003 Employee accruals 16 20004 Materials accruals 17 20005 Services accruals 18 20006 Accrued electricity 19 20007 Accrued water charges 20 20008 Other scervels 21 2000 Long Term Loan from banke 22 30001 Share capital 23 30002 Relaire warnines 24 30003 Dividend declared 25 40001 Hevenue 26 10002 Cost of revenue 27 40003 Gand Amalaya salary 28 40004 Gand Amployee allowances 29 40005 Gand A Deprecation Expenses 30 40036 G and A Rent Expenses 40007 Gand A Utilities water and electricity 32 40008G and A Baddebt expense 33 40009 Zakat CD 34 40009 Sand Advertisment expenses 35 40011 Dividend receive 36 37 38 (550) (100) (100) (100) (150) 150 1501 150) (230) (100) 2019 110 115 350 (55) 56 110 310 1,255 1,000 (300) 1,000 () (395) (110) (110) (110) ) (165) (55) (55) (55) (850) (100) 11,730) 550 19,070) 7,185 155 220 200 53 220 55 110 GG (100) -9000 6,350 150 200 100 60 200 pa 50 100 GO Instructions for the Assignment Ajusted Trail Balance 20188 2019 Income Statement Retained Earnings Statement Statement of Financial Position STATEMENT OF CASH FLOWS (2) + 2 + 100% 4 A A w P .. Excel File Edit View Insert Format Tools Data Window Help V 20% A Wed 8:27 PM Q AutoSave OFF Home Assignment Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Firsert v Bookman Old Style 8 ~ A A 23 Wrap Text General AY 42 LE Pagic dA B 1 Find Ideas Merpa & Center v Y Conditional Forma: Formatting as Table Cell Styles Format v Sart & Filter w Select 15 + x fx D F F 1 M X Y AF Suau final site Asier 11 2019 2016 2011 15 11 THE FETISH 15 15 13 Laurel 2D 22 LULAL ASSELS 23 LIABILIES AND SERELOR DERE FACITY 2 26 28 20 Nuru Yetic 23 99 ACP Las 24 16 Tv 3 23 40 Lamenty 21 4 TOTAL LIABILITIES AND SHAREHOLDER EQUITY 49 22 42 2 4 Instructions for the Assignment Ajusted Trail Balance 2018 2019 Income Statement Retained Earnings Statement Statement of Financial Position STATEMENT OF CASH FLOWS (2) + + 75% 4 m A W X PStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started