how to use excel spreadsheet to complete the following two problems.

P4-48: Part a what are changes in cash that occurred in2016

and how to prepared a statement of cash flow 2016 by indirect method

P4-49

L03, 4 P448. Preparing l Stimulant OICIIII KIWI (Inlrcct W) Amic Company'u incur": :ttttcmcnt and wmpttrtttivc baltttwc them fwllw. "mm mm lhmmu,ml all\"................................................... 0720.000 GadqooduwId.....H.. H...\" 8531.000 Wugouuwann....... . 190.000 Adv-mung autumn . 01.000 Datamation-mun 22.000 Immnpann... . 10.000 Glinunllhafllndn . 5.000} 770.000 Nlthll 0(42.0W] \"mum mm hall. 0.3.\". \"10 I1! All-ll Gnh...................... .......................H.. 349.000 020.0\") AMUI'IMMGWIHIM I... IN...\" . 42.000 50.00.!) Immrywn... . 107.000 110.000 ledav'llnn. .... .......... . 10.00) 13.000 Fllnllum.............. ..... .......... ... $0.000 222.000 Ammulaaddwmlmhn..nunu...........u.........h (78.000) E0010] Ulbllll. In! mil-0' innit} mummmh.......... 817M\" 051.0110 Immnaylhda. 0.000 Map-\"hi... 200.000 Cummmt dealt\" . 245.000 245.000 Whammy. . 52.000 04.000 muwmock.......... 50.000) 1w Imam.- Ind .qutty . . . . 5570.000 During 2016. Arctic said land for 570.000 cash lltttl had urigirtally oust \"5.000. Alan's also pur- chund aquipmcnl fur cult. Mquimd treasury ock for cash. and itlued bonds payable for suit in 2016. Aocnunlu payable mine to merchandise purchlm. R EDU IR E 0 a. Cumpulcthc change in cash Ihal accurmd timing 2016. i). Pm I 2016 mlcmcnt uI' cash ow: using the indirect mclhod. r. Campulcand intcrwclArctic's (I) operating oath ow to curmnt liabilities min. and (2) operating oath ow to capiu] expenditure! ratio. L02 N49. Cnutpudltg Cllh FIW Ennn OperathtgmdUH ('Dlrwt Mulnd) Rem to the income statement and comparative human shuts format: Comm! Wesmlud in P443. R Euu I n E n 0. Compute Arctic Compsny'l cult ow hum npmtn'rtg activities uling the direct method. Use the [mat illum'nted in Exhlhlt 45 in the chapter. b. What can w: lam fwm Ihc diwcl mcthud that may :tu1 0: 1:10in amnnt whctt micwing a cash ow statement mpnred wins the indirectmethod