BUS523Unit3WGCCashFlowTemplate.xlsx

    Cash Flow Statement

    Cash Flow Statement 2016
    ($ Thousands)
    Cash Flow from Operating Activities Line(s) Used (e.g., 2015 Accounts Payable – 2016 Accounts Payable)
    Net income
    Change in Accounts Payable
    Change in Accounts Receivable
    Change in Inventory
    Other Adjustments:
    Accrued Expenses
    Depreciation Expense
    Income Taxes
    Net Cash provided by Operating Activities
    Cash Flow from Investing Activities Line(s) Used
    Sale of Plant, Property and Equipment
    Purchase of Assets (Intangibles)
    Sales of other assets
    Income from short term investments (assumption from IS)
    Net Cash used in Investing Activities
    Cash Flows from Financing Activities Line(s) Used
    Additions to long-term debts
    Cash dividends
    Repurchase of Treasury Stock
    Net cash used in Financing Activities
    Increase/Decrease in cash and cash equivalents
    Cash and Cash Equivalents at the beginning of the period
    Cash and Cash Equivalents at the end of the period
    ERROR:#REF! ERROR:#REF!

    Balance Sheet

    ANNUAL BALANCE SHEET
    ($ Thousands)
    31-Dec-15 31-Dec-16
    ASSETS
    Cash & Short-Term Investments $17.11 $25.05
    Net Receivables $1.62 $1.84
    Inventories $42.72 $39.68
    Prepaid Expenses $0.00 $0.00
    Other Current Assets $3.38 $2.93
    Total Current Assets $64.84 $69.49
    Gross Plant, Property & Equipment $63.75 $58.28
    Accumulated Depreciation $36.16 $32.61
    Net Plant, Property & Equipment $27.58 $25.67
    Intangibles $5.88 $6.01
    Other Assets $6.16 $5.81
    TOTAL ASSETS $104.47 $106.98
    LIABILITIES
    Long Term Debt Due In One Year $0.00 $0.00
    Accounts Payable $10.59 $11.91
    Taxes Payable $1.87 $2.01
    Accrued Expenses $7.19 $6.91
    Other Current Liabilities $1.88 $1.85
    Total Current Liabilities $21.54 $22.67
    Long Term Debt $6.95 $19.79
    Deferred Taxes $1.16 $2.32
    Other Liabilities $3.04 $2.43
    TOTAL LIABILITIES $32.68 $47.21
    EQUITY
    Common Stock $0.07 $0.06
    Capital Surplus $27.25 $24.31
    Retained Earnings $73.89 $61.10
    Less: Treasury Stock $29.42 $25.71
    TOTAL EQUITY $71.79 $59.77
    TOTAL LIABILITIES & EQUITY $104.47 $106.98
    Common Shares Outstanding $5.14 $5.05

    Income Statement

    Annual Income Statement
    ($ Thousands, except per share )
    2015 2016
    Sales $179.24 $164.28
    Cost of Goods Sold $95.71 $91.99
    Gross Profit $83.53 $72.29
    Selling, General, & Administrative Exp. $56.36 $50.65
    Operating Income Before Deprec. $27.17 $21.64
    Depreciation,Depletion,&Amortization $5.85 $5.89
    Operating Profit $21.33 $15.74
    Interest Expense $0.88 $0.56
    Non-Operating Income/Expense $0.93 $0.31
    Special Items $0.00 $0.00
    Pretax Income $21.38 $15.49
    Total Income Taxes $7.23 $5.60
    Income Before Extraordinary
    Items & Discontinued Operations $14.15 $9.90
    Savings Due to Common Stock Equiv. $0.00 $0.00
    Adjusted Net Income $14.15 $9.90
    EPS Basic from Operations $0.26 $0.19
    EPS Diluted from Operations $0.25 $0.19
    Dividends Per Share $0.02 $0.00
    Com Shares for Basic EPS $5.06 $5.12
    Com Shares for Diluted EPS $5.21 $5.27

                                                                                                                                      Order Now