Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    FCF Model 5 Years

    Uploaded by

    ayush
    model

    Copyright:

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

    FCF Model 5 Years

    Uploaded by

    ayush
    14 views2 pages
    model

    Original Title

    Fcf Model 5 Years

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    model

    Copyright:

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

    FCF Model 5 Years

    Uploaded by

    ayush
    model

    Copyright:

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

    Free Cash Flow Estimate (In INR Crs)

    2011 - 12
    Net cash from Operating Activities 205.0
    Capital Expenditures 15.0
    Free Cash Flow (FCF) 190.0
    3 Year Average Free Cash flow

    Inputs
    Number of years considered 10
    FCF Growth rate for first 5 years 10%
    FCF Growth rate for last 5 years 10%
    Terminal Growth Rate 3.50%
    Discount Rate 9%
    2012 - 13 2013 - 14
    296.0 256.0
    4.0 62.0
    292.0 194.0
    225.3

    Cash flow & Present Value Table


    Sl No Year Cash flow PV of Cash flow
    1 2014 - 15 247.87 227.40
    2 2015 - 16 272.65 229.49
    3 2016 - 17 299.92 231.59
    4 2017 - 18 329.91 233.72
    5 2018 - 19 362.90 235.86
    1,158.06

    Terminal value 7258.03173


    PV of TV 4717.22263
    IV 140.42

    You might also like