Preview

Comrail

Good Essays
Open Document
Open Document
1335 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Comrail
rf | g | βfor CC | βfor NC | rm-rf | CAPM for CC | CAPM for NC | Share outstanding | tax | 0.0680 | 0.0300 | 1.3300 | 1.2300 | 0.0750 | 16.78% | 16.03% | 90,500,000 | 0.35 | Total gain in Operating imcome (in million) | 1997 | 1998 | 1999 | 2000 | 2001 | Terminal value | CSX | 0 | 240 | 521 | 730 | 752 | 5620.90 | Norfolk Southern | 0 | 231 | 429 | 660 | 680 | 5375.29 | NPV(in million) | 1997 | 1998 | 1999 | 2000 | 2001 | Terminal | Total | CSX | 0 | 114.3997 | 212.6677 | 255.1742 | 225.1033 | 1682.557 | 2489.902 | Norfolk Southern | 0 | 111.5378 | 178.5319 | 236.7287 | 210.2153 | 1661.717 | 2398.731 | Case 2 Memo
Team name: Leopard
Team member: Chia-Yu Liou, Tzu-Yu Liu, Haoxin Guan, Siqi Hu

1. What is the per share value of Conrail to Norfolk Southern? To CSX? What factors account for the difference? To find out the per share value of Conrail to Norfolk Southern and to CSX, first we use DCF to calculate the total gain in operating income which come from acquisition. We assume the 30-year U.S. Treasury rate (6.8% from exhibit 10) as the risk-free rate and the historical average market risk premium to be 7.5%. As for the beta, we use the average of the pre-merger betas of Conrail and CSX, which is 1.33 {(1.3+1.35)/2}.
Also, for Conrail and CSX, the beta will be 1.23 {(1.3+1.15)/2}. From these data, we can calculate the discount rate by using CAPM. CAPM for Conrail and CSX= 6.8+1.33*7.5=16.78 CAPM for Conrail and Norfolk Southern = 6.8+1.23*7.5=16.03
Take CSX for example: The terminal value can be projected in perpetuity growth method with g= 3% after year 5 and discount each year with r=16.78%.
NPV=1-0.35*240(1.1678)2+1-0.35*521(1.1678)3+1-0.35*730(1.1678)4+1-0.35*752(1.1678)5+752*(1.03)0.1678-0.03*1-0.351.16785=$ 2489.902 million If Conrail choose to merger with CSX, it financial project generates $2489.902 million and on the other hand if Conrail merger with Norfolk Southern then it

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Before coding the Inpatient Cases (IP), review the following definitions.NOTE: All diagnoses and procedures are coded according to ICD-9-CM.Admission Diagnosis – the condition assigned to the patient upon admission to the facility (e.g., hospital outpatient department, ambulatory surgery center, and so on) and coded according to ICD-9-CM.Principal Diagnosis – that condition, established after study, which resulted in the patient’s admission to the hospital.NOTE: when there is no definitive diagnosis, assign codes to signs, symptoms, and abnormal findings, selecting one as the principal diagnosis code (because there always is just one principal diagnosis).Secondary…

    • 1246 Words
    • 5 Pages
    Satisfactory Essays
  • Good Essays

    fra mid term

    • 2907 Words
    • 43 Pages

    The present value factor of an annuity of $1 per period for 5 periods at 10% is 3.7908…

    • 2907 Words
    • 43 Pages
    Good Essays
  • Better Essays

    a) In the first set of calculations, the staff used a discount rate of 20%, a five-year time horizon, and ignored taxes and terminal value. What is the relative attractiveness of these three alternatives?…

    • 1278 Words
    • 6 Pages
    Better Essays
  • Powerful Essays

    The going interest rate per year = 10%, the number of years, N = 20, future value, FV = 1,000, and present value, PV = 865.…

    • 1735 Words
    • 7 Pages
    Powerful Essays
  • Better Essays

    Terminal value is the continuing value determined for a company at the end of the…

    • 1961 Words
    • 6 Pages
    Better Essays
  • Better Essays

    Please complete the following 7 exercises below in either Excel or a word document (but must be single document). You must show your work where appropriate (leaving the calculations within Excel cells is acceptable). Save the document, and submit it in the appropriate week using the Assignment Submission button.…

    • 971 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Hbs Cases

    • 358 Words
    • 2 Pages

    Why does CSX want to buy Conrail? How much should CSX be willing to pay per share?…

    • 358 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Case 4 Brownforman

    • 308 Words
    • 2 Pages

    long term growth rate – affects the terminal value. ( explain why the conclusion )…

    • 308 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Telus: the Cost of Capital

    • 1178 Words
    • 5 Pages

    In calculating the cost of equity, we will use the average between the dividend growth model and the CAPM. Since R-squared = 0.13 we know that the correlation is not strong enough and the sole use of the beta given to us will prove unreliable. For this reason, we choose to take the average between the dividend growth model and the CAPM model if possible. Also, as described above, we decide not to count the underwriter fees in our calculation.…

    • 1178 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    3.) Please refer to my calculations in the sheet named “Question #3”. 59% of year 7’s terminal value must be distributed to Comet Capital to produce its required 25% before-tax rate of return. The value created under the debt scenario is $37,089,386.37. The value created under the equity scenario is $53,099,690.74.…

    • 548 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Valuation of AIrthread

    • 279 Words
    • 2 Pages

    4. Valuation done for the cash flows and terminal value at a discount rate corresponding to industry average D/V Ratio…

    • 279 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Union Pacific

    • 1212 Words
    • 5 Pages

    North America has one of the largest transportation systems in the world. Union Pacific Railroad is the largest railroad in the North America currently covering over 23 states across the western two-thirds of the United States with over 36,000 miles of track. The Union Pacific Railroad maintains coordinated schedules with other rail carriers for the handling of freight to and from the Atlantic Coast, the Pacific Coast, the Southeast, the Southwest, Canada, and Mexico. Union Pacific Railroad commodity revenue totaled $13.0 billion in 2005 and is comprised of six commodity groups: Agricultural, Automotive, Chemicals, Energy, Industrial Products, and Intermodal (Kenefick, 1985).…

    • 1212 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Sampa

    • 524 Words
    • 3 Pages

    The annual projected free cash flows which are presented in the Exhibit 1 are $-112,000; $6,000; $151,000; $314,000; $495,000 respectively for year from 2002 to 2006. After year 2006, the free cash flow would grow at 5%, so we can calculate the terminal value of the project at the end of 2006 using the perpetual-growth DCF formula.…

    • 524 Words
    • 3 Pages
    Good Essays
  • Good Essays

    I don’t think it is at all correct to assume the terminal value will be $40 million in 15 years. Projecting 15 years out is a very long time to make such an assumption even with a consultant forecast. A lot can happen in 15 years, there could be…

    • 712 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    At&T's Acquisition of Mccaw

    • 2275 Words
    • 10 Pages

    As mentioned in the business life cycle section( Exhibit A), cellular companies are in huge demand due to their outstanding growth potential. From the period of October 1989 and September 1991, eleven mergers and acquisitions transaction took place in the cellular industry. Careful analysis of these transactions is required in order to determine the appropriate Value/POP multiple. It is important to mention that these multiples incorporate all four steps of the valuation process (As-Is, Improvements, Synergies, Future Options).…

    • 2275 Words
    • 10 Pages
    Powerful Essays