Excel Edit View Insert Format Tools Data Window Help Q 8 0 Mon Dec 5 4:08 PM AutoSave . OFF A B ? . CG9 ... HO 2Transaction Analysis Worksheet (to students).xIs [Read-Only] [Compatibility Mode] Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 10 AA = =1 ap Wrap Text v General Ex AY- O. Paste BIU BY SVAv E E Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data M43 + X V fx A C D E F G H 1 K L M N P Q R S T U V W SHAREHOLDERS EQUITY Transaction ASSETS LIABILITIES RETAINED EARNINGS A/R SUPPLY BUILD. MACH. TRUCK A/P N/P DP C.S. REV. -EXP -DIV. a) Issued 10,000 shares of Common Stock for $ 40,000 40000 25000 b) Borrowed $25,000 (note) from the bank. c) Purchased land and a building for $50,000 cash 11 12 d) Purchased machinery, issuing a note, for $ 15,000. 15000 13 14 e) Purchased a truck ($ 10,000). Gave $ 4,000 down and on for r 6000 15 16 f) Purchased $ 2,000 of supplies on credit. (A/P) 2000 17 18 g) Paid $ 1,000 of the amount due from transaction f). -1000 19 h) Stored personal computers for IBM for $ 5,000 cash 5000 21 22 i) Stored calculators for Texas Instruments for $6000 on credit. 6000 24 i) Paid the telephone company $ 500 for the year's phone bill. -500 25 26 k) The garbage company the year's garbage. Crum and Crock will 27 28 1) Collected $ 3,000 from Texas Instruments from transaction i). 29 30 m) Declared a dividend of $ .10 per share. 31 32 n) Paid the dividend declared in m). 33 34 35 36 37 38 39 40 41 96500 42 1700 43 98200 44 D Transaction Sheet Financial Statements Sheet3 + Ready ?Accessibility: Unavailable - 100% 48,007 DEC 1 5 City A X OExcel Edit View Insert Format Tools Data Window Help Q 8 0 Mon Dec 5 4:08 PM AutoSave . OFF A B ? . CG9 ... HO 2Transaction Analysis Worksheet (to students).xls [Read-Only] [Compatibility Mode] Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 10 AA = =1 ap Wrap Text v General Ex AY- O. Paste OvAv E E Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data B20 A B C D E F G H 1 J K L M N P Q R S T U v w X Income Statement Statement of RE Balance Sheet 4 Cash 5 Accounts Rec. Revenue Beg. RE Assets Liab. + SE 6 Supplies -Expenses +N #VALUE! Cash Liab. 7 Building Net Income #VALUE! Sub #VALUE! A/R A/P 8 Machine -Dividends Supplies N/P 9 Truck End RE #VALUE! Build D/P 10 Accounts Payable Machine Total Liab 11 Notes Payable Truck 12 Dividends Payable Total Assets SE 13 Common Stock CS Revenu RE #VALUE! 15 Expenses Total SE #VALUE! 16 Dividends 17 Total Liab and SE #VALUE! 18 19 20 21 22 23 24 25 44 AS Transaction Sheet Financial Statements Sheet3 + Ready ? Accessibility: Unavailable - 100% 48,007 DEC 1 5 tv 4 X O