I need help filling out the excel sheet. (the last screenshot). This first two screenshots contain the information that was given. I started filling out some of the excel sheet, but I do not believe I am correct. Please help!
A B C D E F G H Clear Type all entries, DO NOT cut & paste values Review Use a formula format [ =n+n+n...] to add multiple 6 Dec 31, 2013 Dec 31, 2012 financial statement line items into a single cell LAWN- Depreciation and amortization 712 870 Enter a negative amount to bracket the number Stock-based compensation 631 577 Restructuring and impairment charges Increase (decrease) in provision for deferred income taxes (Gain) loss on sales of investments, acquisitions, and securities (Gain) loss on sales of property, plant, and equipment Other non-cash items, net (Increase) decrease in receivables (Increase) decrease in inventories (973) (2,678) (Increase) decrease in other current assets Increase (decrease) in accounts payable, accrued liabilities, and income taxes payable Increase (decrease) in deferred liabilities Other assets and liabilities, net Purchases of property, plant, and equipment (939) (424) A negative number is expected Sales of property, plant, and equipment Purchases of marketable securities and short-term investments A negative number is expected Sales of marketable securities and short-term investments Acquisitions, net of cash acquired A negative number is expected 5 Other investing activities, net 18 Short-term borrowings, net 39 Proceeds from long-term borrowings Payment of long-term borrowings A negative number is expected Proceeds from sales of common stock Repurchase of common stock / treasury stock A negative number is expected Dividends to shareholders A negative number is expected Other financing activities, net Net cash provided by (used for) discontinued operations Effect of exchange rate changes on cash, net 307 Cash and equivalents, beginning of period 13,020 IT the following two items do not appear on the Cash How Statement, Cash paid during the year for: research the Notes Interest 8 3 Enter paid Interest as a positive amount Income taxes (refunded) No enterable fields exist below this point 59CHAPTER 4 Statement of Cash Flows 203 Investing activities Proceeds from disposal of property, plant and equipment - 26 Purchase of property, plant and equipment (939) (424) Purchase of intangible assets (32) (2) Cash used in investing activities (971) (400) Financing activities Payment of repayable government contributions (note 11) (393) (308) Proceeds of borrowings, net of transaction costs (note 11) 1,782 1,621 Proceeds of operating borrowings 1,412 1,182 Repayment of operating borrowings (1,412) (1,182) Common shares issued and warrants exercised, net of issuance costs (note 12) 7,230 5,173 Cash provided by financing activities 8,669 6,491 Effect of exchange rate uctuations on cash and cash equivalents held 302 307 Increase (decrease) in cash and cash equivalents during the year (1,197) 5,235 Cash and cash equivalents - Beginning of year 13,020 7,785 Cash and cash equivalents - End of year 11 23 13 020 Supplemental disclosure Income taxes paid Interest paid 8 3 in l '93 I The accompanying notes form an integral part of these consolidated financial statements. Note 25. Consolidated Statements of Cash Flows Components of the net change in non-cash working capital are as follows: 2013 2012 (Increase) decrease in current assets Trade and other receivables $ 334 $ (L632) Grants receivable 17 108 Inventories (9'73) (2,678) Prepaid expenses and other current assets (64) (289) Increase (decrease) in current liabilities Trade, other payables and provisions (1,614) 984 Deferred revenue (6,629) 15,138 Subtotal $ (8,379) $ 11,631 Liabilities for compensation indexed to share price 4,223 768 $ (4,656) $ 12,399
