Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please refer to image attached Accr # 1020 1030 1040 1100 1110 1 20 1 30 I OO 1210 1300 1310 1320 1330 1340 1510
please refer to image attached
Accr # 1020 1030 1040 1100 1110 1 20 1 30 I OO 1210 1300 1310 1320 1330 1340 1510 1520 1S2S 1560 1S6S 1 rry 1600 1610 1650 165 s 1700 1710 1800 1810 1850 1900 2010 2010 2010 2010 2010 2010 2010 2010 2020 2200 2210 2220 2230 2240 2250 2260 2300 2310 2400 2 soo 2800 2900 3100 3200 3300 Using the pivot table you created for Phoenix, what is the change total for Current Assets? item rrent Cur rent Current Cur r rent Cur rent Current Cur rent Cur r rent Cur rent Current A sset A sset A SSet A sset A sset A sset A SSet A Sset A sset A sset Cash Accts Receiva Accts A Rece Accts Receivable e paid pr e paid E en tory Inventory C he Ck i Cha Se Market 3 month CDWells Far o 6 rnonth CD Cha Acct RecWallv's Wheels Acct RecSports First Rec Nat Acct RecFast Sports Prepaid prepaid Rent Raw Materials Raw Materials Raw Materials Finished Goods ASSetS Property, plant. Equii Long-Term Assets Depreciation Dep. E Long-Term Asset S Property, plant. Equil Machinery - A I urninum - & Bearings - Plastics u i ment Term A Dep_ Machinery Long-Terrn Assets Property, Plant. Equil Welding Machinery Tern. A Dep_ - Welding Mach- Long-Term Assets Property, Plant, Equil Office Equipment ACCum. Dep. - Office Equipment Long-Term Asset S Depreciation Long-Term Assets Property, Plant. Equil Computer Equipment Long-Term A SSetS ACCum. Depreciation ACCum. Dep. - Computer Equipment Terr-n Plant, Equil F Long-Term Assets Depreciation Accum. Dep. Furniture Tern. Invest I Fargo Long-Term Assets Investments est ments-Chase Long-Term s I Good'" ill r rent Cur rent Current Cur rent Cur r rent Cur rent Current Cur r rent Cur rent Current Cur -Terr" Assets Property, Plant. EquilLa d Liabilitie! ACCtS payable Ats Payable Liabilities Accts Payable Liabilitie Ats payable Liabilities Accts payable Liabilitie! ACCtS payable Payable Liabilitie! ACCtS payable Liabilities Wages Payable Wages payable Liabilities Wages payable Liabilitie! Wages payable Wages Payable Liabilities Wages payable Liabilities Wages Payable Liabilities Interest Payable Interest payable A CCt A A cct A Acct A cc:t A CCt Pay Luigi Rodriguez PanMarket Supplies Pay-Popa Fabrication Pay -Wa It e r s pay a Weldi Pay-JT Inc. PayOlsen Industrial pay S Out hway Distributing Harper Lester Mila Wy a t t Scott Dylan DeLong Vicki Tyler Z y A rts Interest Payable-Notes Interest payable-Bonds Liabilitie: Current pcxtion LT de Current portion, Notes a ble Liabilitie! Tax payable Te m Liabilit LT Bonds Payable Long-Term Liabilit LT Notes Payable Equ Stk Stockholders' Eq' Preferred Stock Stockholders' Equ Retained Earnings Income Tax payable Notes Payable Preferred Stock Retained Earnings S S S S S S S S S S S S S S S S S S S S S S 560.021 1.4S4.971 769.116 379.886 777,330 1.276.182 1.2sa.862 1,499.420 96 .ooo 600,000 845.991 576.310 159.750 681.240 426.000 925.610 452,953 548 *000 1 sa,860 685.000 78.994 540.000 45.700 725.300 175.940 3 so,ooo 110.640 200.000 ,000 340.000 750,000 64.885 415.621 184.779 488.759 185.000 495.750 s 74,680 196.370 48.315 2.415 1.566 1,124 513 1.837 2.054 1.124 11.250 27.000 30,000 210.600 67 s,ooo 3 75.000 1.600.000 200.000 1.954.000 Bala S S S S S S S S S S S S S S S S S S Dec 31 621.510 1.388. soo 851,200 450.000 925,884 1.288.203 1,477.558 101.500 7 SO, 000 758.460 62s,3ao 296.810 712,675 362.100 1.025.661 51 s, 843 449.201 167,820 595.630 72,630 480.000 42.330 s Is,aoo 123.500 220,000 89.500 375. ooo 320,000 300. ooo ooo 42.661 475,881 221.301 49 s. 887 136,5S2 54 s. 687 521,660 233.661 S3,991 1.154 1.325 1,229 1.127 1,67S 1.665 9S1 9,855 IS. ooo 25,000 295.700 sso,ooo 305.000 1.8so.ooo 300,000 2.121>11 S S S 61.489 (66.471) 82.084 70.114 148,ssa 12.021 48.3S9 (21.862) s.soo 1 so,ooo (87.531) 49,030 137.060 31.435 (63.900) 100.051 62, 890 (98.799) 12,960 (89.370) (6.364) 60.000) (3.370) (209, goo) (52.440) (130,000) (21.140) 175 .ooo (25.000) (40.000) (2 s o,otN)) (22.224) 60,260 36.522 7.128 48.448) 49.937 (s 3,020) 37.291 s, 676 (1.261) (241) 614 (162) (389) (173) (1.395) (12.000) (SOOO) 85.100 (12 s ,000) (70.000) 2 s 0.000 100.000 167.511 Using the pivot table you created for Phoenix, what is the change total for Accounts Receivable? o A. o B. o c. o A. o B. o c. o D. $555,882 $67,446 $187,072 $138,320 $555,882 Using the Excel file you created for Phoenix, what is the "Net cash provided by (used by) operating activities" for the past fiscal year? o B. o D. $147,216 $555,882 $2,639,864 $381,231
Step 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