代写HCA 2006 Full Firm Valuation: Deal Financing代做回归

HCA 2006

Full Firm Valuation: Deal Financing

Practice Case

Overview

You will be assisting Taylor Murphy in determining if her group of bidders can justify topping the $51 per share offer for HCA from the management-led consortium. Your valuation should take place as of December 31 2006 which will be the time any potential takeover could be closed. As a result, your valuation should be based on the projected free cash flows starting in 2007. The forecasts for year end 2006 numbers given in Exhibits 3 and 5 (denoted “2006E”) should be treated as the best possible approximations for the actual final balance sheet and income statement for 2006.

Assignment Questions

1. Project HCA’s free cash flows. Base your projections on management’s forecasts given in Exhibit 5 for the years 2007-2011. You should project free cash flows beyond 2011 until the steady state is reached (i.e. when estimated FCF growth becomes constant going forward). To do this, use the following information:

Revenue: After 2011, revenue growth is expected to average 4.5% annually into the foreseeable future.

Other Operating Income The forecasts in Exhibit 5 include “Other Operating Income” which refers to income (net of expenses) generated from HCA’s operations that are not related directly to patient care such as hospital cafeteria sales, hospital gift shop sales, medical research grants and hospital parking garage fees. In the historical income statements given in Exhibit 2 this income is included as part of “Revenue”.

Operating Margins: By 2011, operating margins will have reached their steady-state, long run levels. That is, EBIT will grow at the same rate as revenue after 2011.

Tax Rate: HCA will face a tax rate of 37.5%.

Non-Operating Income (net): In Exhibit 2 and Exhibit 5 “non-operating income (net)” refers to interest income and gains and losses related to HCA’s investments in cash and cash equivalents.

Net Property Plant and Equipment: After 2011 Net Property Plant and Equipment is expected to grow at the same rate as revenue.

Other Current Assets: Included in the balance sheet information in Exhibit 3 are “Other Current Assets”. These refer to HCA’s Prepaid Expenses.

Amortization of Fees: For tax purposes the $910M banking “Fees and Expenses” (see Exhibit 7) as well as the $300M breakup fee will be amortized straight line over four years starting in 2007. These fees will be incurred at the time of the deal: December 31 2006. This projected amortization is not included in the projections in Exhibit 5. Recall that for the purposes of calculating free cash flow that amortization should be treated in the same way as depreciation (it is a non-cash expense but does generate a tax shield).

Working Capital: The “Increase in Working Capital” in Exhibit 5 refers to the change from the previous year in the level of working capital where working capital is defined as:

Working Capital = Accounts Receivable + Inventory + Other Current Assets – Accounts Payable – Accrued Expenses

Note that this definition of working capital is incomplete because it does not include the reduction in the deferred tax liability (“reduction in deferred taxes”) that are listed separately in Exhibit 5 and relate to projected changes in the deferred income tax liability (“deferred income taxes”) on the balance sheet in Exhibit 3. You should think carefully about whether a reduction in a deferred tax liability represents an increase or a decrease to free cash flow when incorporating it in your forecasts. Beyond 2011 all items in working capital (i.e. including the level of deferred income taxes) are expected to grow at the same rate as revenue.

2. Estimate HCA’s optimal capital structure. Note that the proposed capital structure to finance the deal (Exhibit 7) might not be the optimal capital structure for HCA going forward. You expect that HCA will move towards the optimal capital structure going forward. Estimate what ND*/EV should be optimally for HCA. To do this, use the following information:

 The current proposed offer of $33,310M is an offer to buy all the equity AND debt of HCA. Put differently, it represents how much the buying group is prepared to pay to acquire all of the assets of the firm (Enterprise value and Cash). Use this information to form. your initial estimate of the enterprise value of HCA for your OCS calculations.

 When estimating the OPMRWC you should take into account how management’s forecasts of future operating profit margins (from Exhibit 5) compare to the margins that have been obtained over the last 10 years. If you are expecting margins to be higher or lower on average in the future than the minimum OPM that has been realized historically should be adjusted accordingly to forecast what OPMRWC is likely to be in the future. Use your own judgement in deciding how to do this and justify the choice you make. There is no one “right” way to do this.

 You will need to estimate the yield that HCA will pay on its debt (rD) at the optimal capital structure. To do this use the information on debt ratings and yields in Exhibit 9 and 11. Specifically, estimate HCA’s bond rating by computing the actual coverage ratio HCA would have had in 2006 if it had been at its optimal capital structure. Compare this to the information on “EBIT Interest Coverage (x)” in Exhibit 11 to estimate how HCA will be rated in the future.

Justify each of the judgments you make in arriving at your estimate for the optimal capital structure.

3. Estimate the weighted average cost of capital. You should estimate the WACC for HCA at the optimal capital structure. Choose comparable firms from those listed in Exhibit 10 to estimate the asset beta for HCA. Information on HCA’s own equity beta is not included in the case. Justify your choice of comparable firms. Assume that there are no non-operating assets at these comparable firms.

4. Estimate HCA’s residual value. You should estimate two different residual values for HCA:

Growing Perpetuity Assume that the free cash flows grow at a constant rate consistent with your forecasts. To do this you will need to find the year when, according to your forecasts the free cash flows begin to behave like a growing perpetuity (i.e. grow from that year forward at a constant rate).

Enterprise Value/EBIT Multiple Estimate the residual value using a EV/EBIT multiple based on comparable firms (in Exhibit 10). Justify which firms you use for your analysis. Do this to form. an estimate of the residual value at the same point in time as the other two residual value estimates. Hint: when applying this method the data in Exhibit 10 will produce a trailing multiple (Enterprise Value in year t divided by EBITt). In words they will give you an estimate of the enterprise value at a point in time as a multiple of the level of EBIT in the year leading up to that point in time. You should apply the multiple you get from these comparables to HCA’s forecasted EBIT in a consistent way. Refer to Lecture 9 if you need a refresher on this.

5. Valuation and Recommendation. Using each of the two residual values, estimate the value of the firm and the value of HCA’s equity. What is the share price implied by each valuation? Would you recommend that Roary make a bid for HCA above the current offer of $51 per share? Explain.





热门主题

课程名

mktg2509 csci 2600 38170 lng302 csse3010 phas3226 77938 arch1162 engn4536/engn6536 acx5903 comp151101 phl245 cse12 comp9312 stat3016/6016 phas0038 comp2140 6qqmb312 xjco3011 rest0005 ematm0051 5qqmn219 lubs5062m eee8155 cege0100 eap033 artd1109 mat246 etc3430 ecmm462 mis102 inft6800 ddes9903 comp6521 comp9517 comp3331/9331 comp4337 comp6008 comp9414 bu.231.790.81 man00150m csb352h math1041 eengm4100 isys1002 08 6057cem mktg3504 mthm036 mtrx1701 mth3241 eeee3086 cmp-7038b cmp-7000a ints4010 econ2151 infs5710 fins5516 fin3309 fins5510 gsoe9340 math2007 math2036 soee5010 mark3088 infs3605 elec9714 comp2271 ma214 comp2211 infs3604 600426 sit254 acct3091 bbt405 msin0116 com107/com113 mark5826 sit120 comp9021 eco2101 eeen40700 cs253 ece3114 ecmm447 chns3000 math377 itd102 comp9444 comp(2041|9044) econ0060 econ7230 mgt001371 ecs-323 cs6250 mgdi60012 mdia2012 comm221001 comm5000 ma1008 engl642 econ241 com333 math367 mis201 nbs-7041x meek16104 econ2003 comm1190 mbas902 comp-1027 dpst1091 comp7315 eppd1033 m06 ee3025 msci231 bb113/bbs1063 fc709 comp3425 comp9417 econ42915 cb9101 math1102e chme0017 fc307 mkt60104 5522usst litr1-uc6201.200 ee1102 cosc2803 math39512 omp9727 int2067/int5051 bsb151 mgt253 fc021 babs2202 mis2002s phya21 18-213 cege0012 mdia1002 math38032 mech5125 07 cisc102 mgx3110 cs240 11175 fin3020s eco3420 ictten622 comp9727 cpt111 de114102d mgm320h5s bafi1019 math21112 efim20036 mn-3503 fins5568 110.807 bcpm000028 info6030 bma0092 bcpm0054 math20212 ce335 cs365 cenv6141 ftec5580 math2010 ec3450 comm1170 ecmt1010 csci-ua.0480-003 econ12-200 ib3960 ectb60h3f cs247—assignment tk3163 ics3u ib3j80 comp20008 comp9334 eppd1063 acct2343 cct109 isys1055/3412 math350-real math2014 eec180 stat141b econ2101 msinm014/msing014/msing014b fit2004 comp643 bu1002 cm2030
联系我们
EMail: 99515681@qq.com
QQ: 99515681
留学生作业帮-留学生的知心伴侣!
工作时间:08:00-21:00
python代写
微信客服:codinghelp
站长地图