Scribd Logo
Upload

Welcome to Scribd!

  • 5 views

    Tutorial 3

    Uploaded by

    1235ngoclinh
    PHÂN TÍCH BÁO CÁO TÀI CHÍNH

    Copyright:

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

    Tutorial 3

    Uploaded by

    1235ngoclinh
    5 views9 pages
    PHÂN TÍCH BÁO CÁO TÀI CHÍNH

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    PHÂN TÍCH BÁO CÁO TÀI CHÍNH

    Copyright:

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

    Tutorial 3

    Uploaded by

    1235ngoclinh
    PHÂN TÍCH BÁO CÁO TÀI CHÍNH

    Copyright:

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

    Given

    Divident/Netincome
    Growth 10%
    Income Statement present future
    Sales 4,250.00 4,675.00
    Cost 3,936.70 92.63% 4,330.37
    Taxable income 313.30 344.63
    Tax (21%) 65.80 72.37
    Net income 247.50 272.26
    dividend 82.60 33.37% 90.86
    retained earning 164.90 66.63% 181.40

    4,250.00 4675
    Balance sheet present future
    Current Assets 900.00 21.18% 990.00
    Fixed assets 2,200.00 51.76% 2,420.00
    Total 3,100.00 72.94% 3,410.00

    Current liabilities 500 11.76% 550.00


    Long-term Debt 1,800.00 n/a 1,800.00
    Equity 800.00 n/a 981.40
    Total 3,100.00 3,331.40
    EFN 78.60

    Given
    Divident/Netincome
    Growth 0.1
    Income Statement present future
    Sales 4,250.00 4,675.00
    Cost 3,936.70 92.63% 4,330.37
    Taxable income 313.30 344.63
    Tax (21%) 65.80 72.37
    Net income 247.50 272.26
    dividend 82.60 33.37% 90.86
    retained earning 164.90 66.63% 181.40

    4,250.00 4675
    Balance sheet present future
    Current Assets 900.00 21.18% 990.00
    Fixed assets 2,200.00 51.76% 2,299.00
    Total 3,100.00 72.94% 3,289.00
    Current liabilities 500.00 11.76% 550.00
    Long-term Debt 1,800.00 n/a 1,800.00
    Equity 800.00 n/a 981.40
    Total 3,100.00 3,331.40
    EFN (42.40)

    3 Internal growth rate 5.62%


    ROA 7.98%
    b 66.63%

    Sustainable growth rate 25.96%


    ROE 30.94%
    Fixed assets capacity sales
    95% 4250
    2200 100% 4473.684 <
    2299 104.5% 4675
    Q1 Given
    sales increase 15%

    Income Statement present future


    Sales 38,000.00 43,700.00
    Cost 32,600.00 86% 37,490.00
    Netincome 5,400.00 14% 6,210.00

    Balance sheet present future


    Assets 27,300.00 31,395.00
    Total 27,300.00 31,395.00

    Debt 6,700.00 7,705.00


    Equity 20,600.00 23,690.00
    Total 27,300.00 31,395.00
    there is no need for a plug variable because the balance sheet still balances after applying the 15% increase

    Q2 Given
    Divident/Netincome 50%

    Income Statement present future


    Sales 38,000.00 43,700.00
    Cost 32,600.00 86% 37,490.00
    Net income 5,400.00 14% 6,210.00
    dividend 2,700.00 3,105.00
    retained earning 2,700.00 3,105.00

    Balance sheet present future


    Assets 27,300.00 31,395.00
    Total 27,300.00 31,395.00

    Debt 6,700.00 6,700.00


    Equity 20,600.00 23,705.00
    Total 27,300.00 30,405.00
    EFN 990.00
    r applying the 15% increase.
    17%
    Income Statement present future
    Sales 7,200.00 8,424.00
    Cost 4,730.00 66% 5,534.10
    Net income 2,470.00 34% 2,889.90
    dividend - -
    retained earning 2,470.00 2,889.90

    Balance sheet present future


    Assets 21,700.00 25,389.00
    Total 21,700.00 25,389.00

    Debt 9,100.00 9,100.00


    Equity 12,600.00 15,489.90
    Total 21,700.00 24,589.90
    EFN 799.10
    Income Statement present future
    Sales 25,400.00 29,210.00
    Cost 17,300.00 68% 19,895.00
    Taxable Income 8100 9,315.00
    Taxes (21%) 1701 1,956.15
    Net income 6,399.00 25% 7,358.85
    dividend 2,100.00 33% 2,415.00
    retained earning 4,299.00 67% 4,943.85

    Balance sheet present future


    Assets 61,000.00 2.401575 70,150.00
    Total 61,000.00 70,150.00

    Debt 26,900.00 26,900.00


    Equity 34,100.00 39,043.85
    Total 61,000.00 65,943.85
    EFN 4,206.15

    You might also like