Scribd Logo
Upload

Welcome to Scribd!

  • 23 views

    SCF

    Uploaded by

    Nidhi Kaushik
    The document contains financial data for a company from 2012 to 2015 including cash, assets, liabilities, equity, revenue, expenses, earnings, and share information. The Altman Z-score, which measures financial distress, increased over the period indicating improving financial health for the company.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    SCF

    Uploaded by

    Nidhi Kaushik
    23 views4 pages
    The document contains financial data for a company from 2012 to 2015 including cash, assets, liabilities, equity, revenue, expenses, earnings, and share information. The Altman Z-score, which measures financial distress, increased over the period indicating improving financial health for the company.

    Original Description:

    Altman

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains financial data for a company from 2012 to 2015 including cash, assets, liabilities, equity, revenue, expenses, earnings, and share information. The Altman Z-score, which measures financial distress, increased over the period indicating improving financial health for the company.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    23 views4 pages

    SCF

    Uploaded by

    Nidhi Kaushik
    The document contains financial data for a company from 2012 to 2015 including cash, assets, liabilities, equity, revenue, expenses, earnings, and share information. The Altman Z-score, which measures financial distress, increased over the period indicating improving financial health for the company.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 4

    2012 2013 2014 2015

    cash 100.00 170.00 120.00 200.00


    accounts receivable 200.00 280.00 160.00 320.00
    inventory 300.00 400.00 220.00 430.00
    other CA 400.00 450.00 300.00 470.00
    total CA 1000.00 1300.00 800.00 1420.00
    FA 4000.00 3800.00 3700.00 3600.00
    total Assets 5000.00 5100.00 4500.00 5020.00
    accounts payable 100.00 140.00 30.00 110.00
    notes payable 150.00 210.00 70.00 200.00
    Other CL 250.00 300.00 90.00 260.00
    total CL 500.00 650.00 190.00 570.00
    Long term debt 3200.00 2850.00 2550.00 2300.00
    total Liabilities 3700.00 3500.00 2740.00 2870.00
    common shares 1200.00 1400.00 1500.00 1800.00
    retained earning 100.00 200.00 260.00 350.00
    total equity 1300.00 1600.00 1760.00 2150.00
    total Liabilities & Equity 5000.00 5100.00 4500.00 5020.00

    altman Z-score
    1.2a+1.4b+3.3c+0.6d+e

    2012 2013 2014 2015


    a 0.1 0.127451 0.135556 0.169323
    b 0.02 0.039216 0.057778 0.069721
    c 0.088 0.085294 0.065556 0.075697
    d 1.243243 1.428571 1.605839 1.916376
    e 0.18 0.196078 0.177778 0.219124

    2012 2013 2014 2015


    1.2 0.12 0.152941 0.162667 0.203187
    1.4 0.028 0.054902 0.080889 0.09761
    3.3 0.2904 0.281471 0.216333 0.249801
    0.6 0.745946 0.857143 0.963504 1.149826
    1 0.18 0.196078 0.177778 0.219124

    Z-score 1.364346 1.542535 1.60117 1.919547


    Final Result

    The lower the Z-score, the higher the chances that a company is heading towards Ba
    an increase in Z-score is observed, over the period, so, the company's financial he
    2012 2013 2014 2015
    revenue 900.00 1000.00 800.00 1100.00
    COGS 400.00 500.00 450.00 650.00
    GP 500.00 500.00 350.00 450.00
    Operating Exp 20.00 25.00 15.00 30.00
    Depreciation 40 40 40 40
    EBIT 440.00 435.00 295.00 380.00
    Interest payable 160 142.5 127.5 115
    EBT 280.00 292.50 167.50 265.00
    taxes 84 87.75 50.25 79.5
    Net Income 196.00 204.75 117.25 185.50
    dividends 146 104.75 57.25 95.5
    share o/s (millions) 100.00 100.00 100.00 100.00
    Market Price ($/share) 46.00 50.00 44.00 55.00
    pany is heading towards Bankruptcy. However
    , the company's financial health is improving

    You might also like