AutoSave . Off) Summative_Assessment_Mod_7_Excel (2) - Protected View Search (Alt+Q) Lanna Taylor LT X File Home Insert Page Layout Formulas Data Review View Help Comments Share iPROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing A1 X Vfx AAA Inc. and ZZZ Inc. operate in the same manufacturing type industry. The financial statements and notes are below. B C D E F G H K 22 Inventory 87,000 72,000 Inventory 17,000 10,000 23 Total Current Assets 167,000 126,000 Total Current Assets 95,000 74,000 Property, Plant and Equipment net of $60,000 and $48,000 Property, Plant and Equipment net of $14000 and 6000 24 accumulated depreciation 140,000 112,000 accumulated depreciation 286,00 64,000 25 Intangibles 50,000 50,000 Intangibles 17,000 26 Total Assets 357,000 288,000 Total Assets 398,000 138,000 27 Accounts Payable 35,000 40,000 Accounts Payable 28,000 2,000 28 Accrued Liabilities 25,00 16,000 Accrued Liabilities 6,000 8,000 29 Total Current Liabilities 60,000 56,000 Total Current Liabilities 34,000 20,000 30 Bonds Payable 90,000 64,000 Bonds Payable 130,000 20,000 31 Total liabilities 150,000 120,000 Total liabilities 164,000 40,000 Common Stock $5 Par 100,000 shares authorized, 20,000 and 17,000 Common Stock $1 Par 500,000 shares authorized, 70,000 and 32 shares respectively issued 100,000 85,000 50,000 shares respectively issued 70,000 50,000 33 Retained Earnings 12,000 $8,000 Retained Earnings 68,000 $2,000 34 Treasury Stock 200 shares (5,000 5,000) Treasury Stock 400 shares 4,000 4,000) 35 Total Equity 207,000 168,000 Total Equity 234,000 98,000 36 Total liabilities and Shareholders Equity 357,000 288,000 Total liabilities and Shareholders Equity 398,000 138,000 37 38 39 Statement of Cash Flows (in 000) Year 1 Year 2 Statement of Cash Flows (in 000) Year 1 Year 2 40 Net Income 38,000 $5,400 Net Income 145,000 199,200 41 Add/subtract noncash Expenses/Gains/Losses 14,000 18,000 Add noncash Expenses 12,000 3,000 42 Changes in current assets and liabilities Changes in current assets and liabilities: 43 Accounts Receivable -20,000 -15,000 Accounts Receivable 10,000 12,000 44 Inventory 14,00 14,100 Inventory -5,00 -9,000 45 Accounts Payable 5,000 -7,000 Accounts Payable 16,00 20,000 46 Accrued Liabilities 7,000 -8,000 Accrued Liabilities 6,000 4,000 47 Net Cash Provided by Operations 20,000 29,300 Net Cash Provided by Operations 72,000 186,200 48 Purchase of Equipment 10,000 38,000 Purchase of Equipment 145,000 160,000 49 Sale of non-current assets 12,000 12,000 Sale of non-current assets 4,000 10,000 50 Net Cash Used by Investing 2,000 26,000 Net Cash Used by Investing 141,000 150,000 51 Issuance of Bonds -3,000 13,000 Issuance of Bonds 20,000 20,000 52 Payment of Dividend -14,000 14,000 Payment of Dividend 29,000 29,000 53 Net Cash Provided by Financing 17,000 -1,000 Net Cash Provided by Financing 9,000 -9,000 AAA Inc and ZZZ Inc Financials Tab 2 ratios | Tab 3 Income Statement D Ready + 896 Type here to search O 61.F Sunny 6:20 PM 4/19/2022