cfs percent ratio

Upload: anshul-garg

Post on 04-Jun-2018

224 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/13/2019 Cfs Percent Ratio

    1/14

    Historical Income Statements and Balance Sheets for Vitex Corp.

    Income Statement ($ Million)

    Year Ending Dec. 31,

    2009 2010 2011 2012

    Sales $1,234.9 $1,251.7 $1,300.4 $1,334.4

    Cost of Sales $679.1 $659.0 $681.3 $667.0

    Gross Operating Income $555.8 $592.7 $619.1 $667.4

    Selling, General & Admn. Expenses $339.7 $348.6 $351.2 $373.3

    Depreciation $47.5 $52.0 $55.9 $75.2

    Other net (Income)/Expenses ($11.8) ($7.6) ($7.0) ($8.2)

    EBIT $180.4 $199.7 $219.0 $227.1

    Interest (Income) ($1.3) ($1.4) ($1.7) ($2.0)

    Interest Expense $16.2 $15.1 $20.5 $23.7

    Pre-Tax Income $165.5 $186.0 $200.2 $205.4

    Income Taxes $56.8 $64.2 $67.5 $72.6

    Net Income $108.7 $121.8 $132.7 $132.8

    Dividends $38.3 $38.7 $39.8 $40.1

    Addition to Retained Earnings $70.4 $83.1 $92.9 $92.7

    Balance Sheet ($ Million)Assets

    Cash and Marketable Securities $25.6 $23.0 $32.1 $28.4

    Accounts Receivable $99.4 $102.9 $107.3 $120.1

    Inventories $109.6 $108.0 $114.9 $116.8

    Other Current Assets $96.7 $91.4 $103.7 $97.5

    Total Current Assets $331.3 $325.3 $358.0 $362.8

    Property, Plant and Equipment, Gross $680.9 $734.3 $820.8 $913.1

    Accumulated Depreciation $244.8 $296.8 $352.7 $427.9

    Property, Plant and Equipment, Net $436.1 $437.5 $468.1 $485.2

    Other Non-Current Assets $203.2 $205.1 $407.0 $456.3

    Total Non-Current Assets $639.3 $642.6 $875.1 $941.5

    Total Assets $970.6 $967.9 $1,233.1 $1,304.3

    Liabilities and Shareholders' Equity

    Accounts Payable $82.8 $77.1 $71.8 $80.5

    Short-Term Debt $39.1 $29.7 $79.8 $110.3

    Other Current Liabilities $152.0 $123.8 $172.1 $111.3

    Total Current Liabilities $273.9 $230.6 $323.7 $302.1

  • 8/13/2019 Cfs Percent Ratio

    2/14

    Long-Term Debt $163.5 $145.0 $201.8 $218.1

    Deferred Income Taxes $22.3 $19.6 $15.0 $12.7

    Other Non-Current Liabilities $100.6 $80.1 $115.0 $94.5

    Total Liabilities $560.3 $475.3 $655.5 $627.4

    Paid-In Capital $46.9 $46.1 $38.2 $44.8Retained Earnings $363.4 $446.5 $539.4 $632.1

    Total Shareholders' Equity $410.3 $492.6 $577.6 $676.9

    Total Liabilities and Shareholders' Equity $970.6 $967.9 $1,233.1 $1,304.3

    Other Data

    Stock price (year-end) $55.50 $65.30 $55.70 $51.40

    Average number of shares outstanding (millions) 48.0 47.3 46.8 46.2

  • 8/13/2019 Cfs Percent Ratio

    3/14

    Create a Cash Flow Statement

    Year Ending Dec. 31,

    2010 2011

    Cash Flows from Operations

    Net Income

    Depreciation Expense

    Decrease/(Increase) in Accounts Receivable

    Decrease/(Increase) in Inventories

    Decrease/(Increase) in Other Current Assets

    Increase/(Decrease) in Accounts Payable

    Increase/(Decrease) in Other Current Liabilities

    Increase/(Decrease) in Deferred Income Taxes

    Increase/(Decrease) in Other Non-Current Liabilities

    Total Cash Flows from Operations

    Cash Flows from Investing

    (Additions to) Property, Plant & Equipment

    (Investment) in Other Non-Current Assets

    Total Cash Flows from Investing

    Cash Flows from Financing

    From Issuance/(Repayment) of Short-Term Debt

    From Issuance/(Repayment) of Long-Term Debt

    From Sale/(Repurchase) of Equity

    Cash Dividends Paid to Shareholders

    Total Cash Flows from Financing

    Net Change in Cash & Marketable Securities

    Beginning Cash & Marketable Securities

    Ending Cash & Marketable Securities

    Net Change in Cash & Marketable Securities

  • 8/13/2019 Cfs Percent Ratio

    4/14

  • 8/13/2019 Cfs Percent Ratio

    5/14

    2012

  • 8/13/2019 Cfs Percent Ratio

    6/14

    Historical Income Statements and Balance Sheets for Vitex Corp. CREATE COCALCULAT

    Income Statement ($ Million)

    Year Ending Dec. 31,

    2009 2010 2011 2012

    Sales $1,234.9 $1,251.7 $1,300.4 $1,334.4

    Cost of Sales $679.1 $659.0 $681.3 $667.0 Gross Operating Income $555.8 $592.7 $619.1 $667.4

    Selling, General & Admn. Expenses $339.7 $348.6 $351.2 $373.3

    Depreciation $47.5 $52.0 $55.9 $75.2

    Other net (Income)/Expenses ($11.8) ($7.6) ($7.0) ($8.2)

    EBIT $180.4 $199.7 $219.0 $227.1

    Interest (Income) ($1.3) ($1.4) ($1.7) ($2.0)

    Interest Expense $16.2 $15.1 $20.5 $23.7

    EBT $165.5 $186.0 $200.2 $205.4

    Income Taxes $56.8 $64.2 $67.5 $72.6

    Net Income $108.7 $121.8 $132.7 $132.8

    Dividends $38.3 $38.7 $39.8 $40.1

    Addition to Retained Earnings $70.4 $83.1 $92.9 $92.7

    Balance Sheet ($ Million)Assets

    Cash and Marketable Securities $25.6 $23.0 $32.1 $28.4

    Accounts Receivable $99.4 $102.9 $107.3 $120.1Inventories $109.6 $108.0 $114.9 $116.8

    Other Current Assets $96.7 $91.4 $103.7 $97.5

    Total Current Assets $331.3 $325.3 $358.0 $362.8

    Property, Plant and Equipment, Gross $680.9 $734.3 $820.8 $913.1

    Accumulated Depreciation $244.8 $296.8 $352.7 $427.9

    Property, Plant and Equipment, Net $436.1 $437.5 $468.1 $485.2

    Other Non-Current Assets $203.2 $205.1 $407.0 $456.3

    Total Non-Current Assets $639.3 $642.6 $875.1 $941.5

    Total Assets $970.6 $967.9 $1,233.1 $1,304.3

    Liabilities and Shareholders' Equity

    Accounts Payable $82.8 $77.1 $71.8 $80.5

    Short-Term Debt $39.1 $29.7 $79.8 $110.3

    Other Current Liabilities $152.0 $123.8 $172.1 $111.3

    Total Current Liabilities $273.9 $230.6 $323.7 $302.1

  • 8/13/2019 Cfs Percent Ratio

    7/14

    Long-Term Debt $163.5 $145.0 $201.8 $218.1

    Deferred Income Taxes $22.3 $19.6 $15.0 $12.7

    Other Non-Current Liabilities $100.6 $80.1 $115.0 $94.5

    Total Liabilities $560.3 $475.3 $655.5 $627.4

    Paid-In Capital $46.9 $46.1 $38.2 $44.8Retained Earnings $363.4 $446.5 $539.4 $632.1

    Total Shareholders' Equity $410.3 $492.6 $577.6 $676.9

    Total Liabilities and Shareholders' Eq $970.6 $967.9 $1,233.1 $1,304.3

    Other Data

    Stock price (year-end) $55.50 $65.30 $55.70 $51.40

    Average number of shares outstanding (m 48.0 47.3 46.8 46.2

  • 8/13/2019 Cfs Percent Ratio

    8/14

    MMON SIZE STATEMENTS AS A PERCENT OF SALES

    THE 4 YEAR AVERAGES FOR EACH LINE ITEM AS A % OF SALES

  • 8/13/2019 Cfs Percent Ratio

    9/14

    Historical Income Statements and Balance Sheets for Vitex Corp.

    Income Statement ($ Million)

    Year Ending Dec. 31,

    2009 2010 2011 2012

    Sales $1,234.9 $1,251.7 $1,300.4 $1,334.4

    Cost of Sales $679.1 $659.0 $681.3 $667.0 Gross Operating Income $555.8 $592.7 $619.1 $667.4

    Selling, General & Admn. Expenses $339.7 $348.6 $351.2 $373.3

    Depreciation $47.5 $52.0 $55.9 $75.2

    Other net (Income)/Expenses ($11.8) ($7.6) ($7.0) ($8.2)

    EBIT $180.4 $199.7 $219.0 $227.1

    Interest (Income) ($1.3) ($1.4) ($1.7) ($2.0)

    Interest Expense $16.2 $15.1 $20.5 $23.7

    Pre-Tax Income $165.5 $186.0 $200.2 $205.4

    Income Taxes $56.8 $64.2 $67.5 $72.6

    Net Income $108.7 $121.8 $132.7 $132.8

    Dividends $38.3 $38.7 $39.8 $40.1

    Addition to Retained Earnings $70.4 $83.1 $92.9 $92.7

    Balance Sheet ($ Million)

    Assets

    Cash and Marketable Securities $25.6 $23.0 $32.1 $28.4

    Accounts Receivable $99.4 $102.9 $107.3 $120.1Inventories $109.6 $108.0 $114.9 $116.8

    Other Current Assets $96.7 $91.4 $103.7 $97.5

    Total Current Assets $331.3 $325.3 $358.0 $362.8

    Property, Plant and Equipment, Gross $680.9 $734.3 $820.8 $913.1

    Accumulated Depreciation $244.8 $296.8 $352.7 $427.9

    Property, Plant and Equipment, Net $436.1 $437.5 $468.1 $485.2

    Other Non-Current Assets $203.2 $205.1 $407.0 $456.3

    Total Non-Current Assets $639.3 $642.6 $875.1 $941.5

    Total Assets $970.6 $967.9 $1,233.1 $1,304.3

    Liabilities and Shareholders' Equity

    Accounts Payable $82.8 $77.1 $71.8 $80.5

    Short-Term Debt $39.1 $29.7 $79.8 $110.3

    Other Current Liabilities $152.0 $123.8 $172.1 $111.3

    Total Current Liabilities $273.9 $230.6 $323.7 $302.1

  • 8/13/2019 Cfs Percent Ratio

    10/14

    Long-Term Debt $163.5 $145.0 $201.8 $218.1

    Deferred Income Taxes $22.3 $19.6 $15.0 $12.7

    Other Non-Current Liabilities $100.6 $80.1 $115.0 $94.5

    Total Liabilities $560.3 $475.3 $655.5 $627.4

    Paid-In Capital $46.9 $46.1 $38.2 $44.8Retained Earnings $363.4 $446.5 $539.4 $632.1

    Total Shareholders' Equity $410.3 $492.6 $577.6 $676.9

    Total Liabilities and Shareholders' Equity $970.6 $967.9 $1,233.1 $1,304.3

    Other Data

    Stock price (year-end) $55.50 $65.30 $55.70 $51.40

    Average number of shares outstanding (milli 48.0 47.3 46.8 46.2

    Financial Indicators for Vitex Corp. 2009 2010 2011 2012

    Valuation Ratios

    EPS

    Dividend per Share

    P/E Ratio

    P/B (price to book) Ratio

    Dividend Payout Ratio

    Profitability Ratios

    Return on Equity (ROE)

    Return on Sales (ROS)

    Growth Rates

    EPS Growth Rate

    Dividend Growth Rate

    Sales Growth Rate

    EBIT Growth Rate

    Net Income Growth Rate

    Liquidity Ratios

    Current Ratio

    Quick Ratio

    Operating Efficiency Ratios

    Inventory Turnover Ratio

    Receivable Turnover Ratio

    Leverage Ratios

    Total Debt to Total Capitalization

  • 8/13/2019 Cfs Percent Ratio

    11/14

    Long-Term Debt to Total Capitalization

    Total Debt to Equity

    Coverage Ratios

    Times Interest Earned (TIE)

    Cash Coverage Ratio

  • 8/13/2019 Cfs Percent Ratio

    12/14

  • 8/13/2019 Cfs Percent Ratio

    13/14

    Short term and long term/Short term and long term debt+total shh equity

  • 8/13/2019 Cfs Percent Ratio

    14/14

    EBIT+ depreciation/ Interest