Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Valuation for M&A and Capital Budgeting

VIEWS: 89 PAGES: 12

Valuation of M&A and Capital Budgeting projects and decision making.

More Info
									©GK
                                                                          1)   If M&A, enter targets stand-alone inputs fo
Email Me                                                                  2)   If Capital Budgeting, enter CASH FLOWS or N
                                                                          3)   Project Start Year ( YYYY )
                                                                          4)   1 = M&A 2 = Mutually Exclusive Projects,
                                                                          5)   Project Name




                                               No. Yrs          4
                                               No. Yrs          5
                                               No. Yrs          6
                                               No. Yrs          7
                                               No. Yrs          8
                                               No. Yrs          9
                                               No. Yrs          10
           Clear Data

           DCF Valuation                       Initial         2012                  2013

           EBITDA
           ∆ Working Capital
           Taxes
           Investments                                   -

                            Cash Flow                    -            -                     -
                        Cummulative CF                                -                     -
                                                                          0                     0
                                   NPV
                                    IRR
                               Payback




                                                 Yr 1          2012

                                          Initial Investment
                                               Currency        USD
           Clear Data
DCF Valuation                  Initial       2012           2013

EBITDA
∆ Working Capital
Taxes
Investments                              -

                Cash Flow                -          -              -
            Cummulative CF                          -              -
                                                        0              0
                        NPV
                         IRR
                    Payback
A, enter targets stand-alone inputs for A and after synergy inputs for B
tal Budgeting, enter CASH FLOWS or NOPAT in place of EBITDA
t Start Year ( YYYY )                    2012
&A 2 = Mutually Exclusive Projects, 3 = Independent Projects




             TV Calc.                   INPUT
             EBITDA Multiple              5.5
             WACC / K                     8%
             INPUT

              Initial Investment
             Currency                    USD



                    2014                 2015               2016            Terminal Value




                                                                                         -

                            -                    -                                       -
                            -                    -                  -                    -
                                0                    0                  0




             TV Calc.                   INPUT
             EBITDA Multiple              5.5
             WACC / K                     8%
             INPUT
2014           2015           2016           Terminal Value




                                                          -

       -              -                                   -
       -              -              -                    -
           0              0              0
DECISION HQ




              THE DECISION SHOWN HERE IS NOT A GUARANTEE OF SUCCESS OR FAILURE OF THIS INVESTMENT.
              FOR MORE ANALYSIS AND/OR QUESTIONS
OF SUCCESS OR FAILURE OF THIS INVESTMENT.
                      EMAIL
WACC   NPV


                       1

                       1

                       1

                       1

                       1

                       1

             NPV       0

                       0

                       0

                       0

                       -
                           0%   5%   10%




WACC   NPV


                   1

                   1
      1

      1

      1

      1

      1




NPV
      0

      0

      0

      0

      -
          0%   5%   10%
                         NPV
                         Linear (NPV)




15%    20%   25%   30%

WACC
                           NPV
                           Linear (NPV)




15%      20%   25%   30%

      WACC

								
To top