Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    CF Project Part - 1

    Uploaded by

    Maitri shah
    The document contains a cash flow statement and calculations to value a company using discounted cash flow analysis over 10 years. It includes projections for sales, expenses, EBIT, tax, PAT, depreciation, and terminal value calculation. The value per share is calculated to be 30.

    Copyright:

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

    CF Project Part - 1

    Uploaded by

    Maitri shah
    8 views3 pages
    The document contains a cash flow statement and calculations to value a company using discounted cash flow analysis over 10 years. It includes projections for sales, expenses, EBIT, tax, PAT, depreciation, and terminal value calculation. The value per share is calculated to be 30.

    Original Title

    CF-Project-part_1

    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 a cash flow statement and calculations to value a company using discounted cash flow analysis over 10 years. It includes projections for sales, expenses, EBIT, tax, PAT, depreciation, and terminal value calculation. The value per share is calculated to be 30.

    Copyright:

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

    CF Project Part - 1

    Uploaded by

    Maitri shah
    The document contains a cash flow statement and calculations to value a company using discounted cash flow analysis over 10 years. It includes projections for sales, expenses, EBIT, tax, PAT, depreciation, and terminal value calculation. The value per share is calculated to be 30.

    Copyright:

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

    Learner Name

    Variable Factors
    Calculate the value per share using DCF Techn
    Operating Expenses 50%
    Sales 500.00
    Tax 30% 30

    ESTIMATED CASH FLOW STATEMENT

    DATE Mar-16 Mar-17 Mar-18


    0 1 2
    Initial Investment "-100"
    Sales (Sales*Growth Rate to calculated sales on YOY) 500.00 550.00
    Operating Expenses @50% NA 250.00 275.00
    EBDIT (earning before depreciation in Tax) NA 250.00 275.00
    Depreciation NA 15.00 15.00
    EBIT (Operating Profit) earning before interest in tax NA 235.00 260.00
    Tax =@30% *EBIT 71 70.50 78.00
    PAT=EBIT-Tax (Profit after Tax) NA 164.50 182.00
    Depreciation added NA 15.00 15.00

    Terminal Value FORMULA


    =CF/(r-g)*cost of equity
    NA 2224.75
    Cash Flows NA 179.50 197.00

    Annual Generated Cash Flows in Today's Value


    PV=FV/(1+r)^n 143.6 126.08
    Value= 3038
    Number of Share 100
    Value per Share 30
    Assumptions
    value per share using DCF Technique Investment 100
    Salvage Value 0
    Depreciation 15.00
    r Cost of Equity 25.00%
    g Growth rate 10%
    Number of shares 100
    Market Price 10
    SH FLOW STATEMENT

    Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25 Mar-26


    3 4 5 6 7 8 9 10

    605.00 665.50 732.05 805.26 885.78 974.36 1,071.79 1,178.97


    302.50 332.75 366.03 402.63 442.89 487.18 535.90 589.49
    302.50 332.75 366.03 402.63 442.89 487.18 535.90 589.49
    15.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00
    287.50 317.75 351.03 387.63 427.89 472.18 520.90 574.49
    86.25 95.33 105.31 116.29 128.37 141.65 156.27 172.35
    201.25 222.43 245.72 271.34 299.52 330.53 364.63 402.14
    15.00 15.00 15.00 15.00 15.00 15.00 15.00 15.00

    216.25 237.43 260.72 286.34 314.52 345.53 379.63 417.14

    110.72 97.25 85.43 75.06 65.96 57.97 50.95 2224.75


    Terminal Value FORMULA
    =CF/(r-g)*cost of equity

    You might also like