Scribd Logo
Upload

Welcome to Scribd!

  • 36 views

    Project Hard

    Uploaded by

    Talha Khan Sherwani
    The document contains income statements and balance sheets for two companies (Case A and Case B) for the year ending December 31, 2009. Case A reported revenues of $110 million, expenses of $70 million, and net income of $40 million. It had total assets of $410 million including current assets of $230 million and total liabilities of $200 million. Case B reported revenues of $250 million, expenses of $150 million, and net income of $48 million.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Project Hard

    Uploaded by

    Talha Khan Sherwani
    36 views12 pages
    The document contains income statements and balance sheets for two companies (Case A and Case B) for the year ending December 31, 2009. Case A reported revenues of $110 million, expenses of $70 million, and net income of $40 million. It had total assets of $410 million including current assets of $230 million and total liabilities of $200 million. Case B reported revenues of $250 million, expenses of $150 million, and net income of $48 million.

    Original Title

    project hard copy

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains income statements and balance sheets for two companies (Case A and Case B) for the year ending December 31, 2009. Case A reported revenues of $110 million, expenses of $70 million, and net income of $40 million. It had total assets of $410 million including current assets of $230 million and total liabilities of $200 million. Case B reported revenues of $250 million, expenses of $150 million, and net income of $48 million.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    36 views12 pages

    Project Hard

    Uploaded by

    Talha Khan Sherwani
    The document contains income statements and balance sheets for two companies (Case A and Case B) for the year ending December 31, 2009. Case A reported revenues of $110 million, expenses of $70 million, and net income of $40 million. It had total assets of $410 million including current assets of $230 million and total liabilities of $200 million. Case B reported revenues of $250 million, expenses of $150 million, and net income of $48 million.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 12

    Income Statement Dec 31, 2010

    Statement of retained earning Dec 31, 2010

    Dec 31, 2010


    Rs. Dec 31, 2010
    Studio revenue 165,000 Rs.
    Balance of retained earning 40000
    Gross profit 165,000
    Net income -36000
    Expenses
    Rent expense -12000 Dividends -6000
    Supply expense -3900
    Insurance expense -1900
    Advertisement expense -500 Balance of retained earning -2,000
    Salries -85000

    EBITDA 61,700
    Deprecition -1800

    EBIT 59,900
    Interest -900

    EBT 59,000
    Income tax -23000

    Net income 36,000


    Balance Sheet

    Dec 31, 2010


    ASSETS
    NON-CURRENT ASSETS
    Equipment 18000
    Accumulated depritiation -7200
    10,800

    CURRENT ASSETS
    Cash 171100
    Unexpired insurance 7200
    Account recivable 9400
    Pre-paid studio rent 3000
    Supplier 500
    191,200

    202,000

    EQUITY AND LIABILITIES

    CURRENT LIABILITIES
    Accounts Payable 3200
    Salaries payable 4000
    Unearned studion revenue 8800
    Income tax payable 6000
    Notes payable 10000
    32,000

    EQUITY
    capital stock 100000
    retained earning 70000
    170000
    202,000
    PARTICULARS CASE A

    Revenues 200000
    Expenses 160000
    Net income 40000
    Retained earnings, Jan 1 300000
    Dividents paid 70000
    Retained earnings, Dec 1 270000
    Current assets , Dec 31 80000
    Non current assets,Dec 31 850000
    Total assets, Dec 31 930000
    Current liabilities, Dec 31 40000
    Non current liabilities, Dec 31 100000
    Total liabilities, Dec 31 140000
    CS and capital in excess of par, Dec 31 520000
    Total stockholders equity, Dec 31 790000

    return on equity 0.191183679 0.99728913 0.99943617 0.99819844

    4. current market price of common stock


    2009 2007 2006 2005
    price earning ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0!

    dividend yield ratio 1.062182362 0.79740583 0.71592242 1.67685518


    PARTICULARS CASE B

    Sales 500000
    COGS 200000
    Gross profit 300000
    Operatin expense 60000
    Operating income (EBIT) 240000
    Interest expense 10000
    Income before Taxes (EBT) 230000
    Tax expense (40%) 92000
    Net income 138000
    PARTICULARS CASE A

    Revenues 110000 PARTICULARS CASE B


    Expenses 70000
    Net income 40000 Sales 250000
    Retained earnings, Jan 1 100000 COGS 100000
    Dividents paid 30000 Gross profit 150000
    Retained earnings, Dec 1 110000 Operatin expense 60000
    Current assets , Dec 31 230000 Operating income (EBIT) 90000
    Non current assets,Dec 31 180000 Interest expense 10000
    Total assets, Dec 31 410000 Income before Taxes (EBT) 80000
    Current liabilities, Dec 31 60000 Tax expense (40%) 32000
    Non current liabilities, Dec 31 140000 Net income 48000
    Total liabilities, Dec 31 200000
    CS and capital in excess of par, Dec 31 100000
    Total stockholders equity, Dec 31 210000
    Income Statement Dec 31, 2009

    Dec 31, 2009


    EPS = NI / No. Of shares
    Millions of Dollars 2.44

    Net sales 2850 DPS = Total dividends / No. Of shares


    Operating cost -2497 1.06
    Gross profit 353
    BVPS = Total equity / No. Of shares
    EBITDA 353 17.6
    Deprecition -90
    CFPS = (NI + Depreciation + Amortization) / No. Of shares
    EBIT 263 4.24
    Interest -60
    NCF = NI + Depreciation + Amortization
    EBT 203 1310000000
    Income tax -81.2

    Net income 122

    Common Dividends -53


    Retained earning addition 69
    Income Statement Dec 31, 2009

    Dec 31, 2009 EPS = NI / No. Of shares


    2.36
    Millions of Dollars
    DPS = Total dividends / No. Of shares
    Net sales 3000 1.15
    Operating cost -2616.2
    Gross profit 384 BVPS = Total equity / No. Of shares
    18.8 CFPS= NI + Dep. + Amortiz
    EBITDA 384 4.35
    Deprecition -100 CFPS = NI + Depreciation + Amortization

    EBIT 284
    Interest -88 NCF = NI + Depreciation + Amortization
    218000000
    EBT 196
    Income tax -78.3 NOWC = TCA - TCL
    690000000
    Net income 118
    TOC = NOWC + Net fixed assets
    Common Dividends -57.5 1690000000
    Retained earning addition 60
    NOPAT =

    OCF = NOPAT + Depreciation + Amortization OCF :


    FCF =

    MVA = MVA:

    EVA = CFPS :

    NOWC:

    NOPAT :

    FCF :
    CFPS= NI + Dep. + Amortization

    4.35

    OCF = NOPAT + Dep. + Amortization


    -21837.74
    MVA= 1150 - 6500
    -5350

    CFPS= NI + Dep. + Amortization


    117500000 + 100000000 + 0 / 50000000
    4.35

    NOWC= TCA - TCL


    1000000000- 310000000
    6.9E+08

    NOPAT = EBIT (1- tax)


    283.8 (1-78.3)
    -21937.74

    FCF= OCF - Gross investment in fixed assests


    -21837.7 -1100
    -22937.74

    You might also like