In: Finance
You are preparing a valuation for an acquisition target, C Corporation. A team member has created the following list of facts assumptions: o The company has a mix of debt and common stock in its capital structure. The mix is expected to remain constant, and the WACC for the foreseeable future is 9.5%. o For the last full year (which has just ended), NOPLAT2018 was $225M, with FCF2018 of $145M. o Over the last 5 years, the investment rate (IR) has consistently averaged 25% and return on investment (ROIC) has consistently averaged 11%. The company has an opportunity to increase growth over the next three years by investing in a new product update. This will require additional investment, such that over the three years, IR will average 40%. Due to promotional expenses and additional R&D during these three years, ROIC on new investment will fall to 10%. AFTER the three years of increased growth, both IR, and ROIC on new investments, will return to their pre-growth averages of 25% and 11%.
Estimate the enterprise value (EV) of C Corporation Today
| F0 | FCF last year(Free Cash flow) | $145,000,000 | ||||
| Growth Rate=ROIC*IR | ||||||
| g | Expected Growth Rate next 3 years | 0.04 | (0.4*0.1) | |||
| F1=F0*(1+g) | Expected FCF in year1 | $150,800,000 | ||||
| F2=F1*(1+g) | Expected FCF in year2 | $156,832,000 | ||||
| F3=F2*(1+g) | Expected FCF in year3 | $163,105,280 | ||||
| g1 | Growth Rate during last 5 years | 0.0275 | (0.25*0.11) | |||
| g1 | Constant growth rate fromyear 4 | 0.0275 | (0.25*0.11) | |||
| F4=F3*(1+g1) | Expected FCF in year 4 | $167,590,675 | ||||
| Required return =Cost of capital=9.5% | 0.095 | |||||
| H3=F4/(0.095-g1) | Horizon Value in year3 | $2,482,824,818 | ||||
| Enterprice value =Present value of Future Cash flows | ||||||
| Present Value (PV) of Cash Flow: | ||||||
| (Cash Flow)/((1+i)^N) | ||||||
| i=Discount Rate=Cost of Capital=0.095 | ||||||
| N=Year of Cash Flow | ||||||
| N | A | PV=A/(1.095^N) | ||||
| Year of Cash flow | Cash Flow | PV of cash flow | ||||
| F1 | 1 | $150,800,000 | $137,716,895 | |||
| F2 | 2 | $156,832,000 | $130,799,608 | |||
| F3 | 3 | $163,105,280 | $124,229,765 | |||
| H3 | 3 | $2,482,824,818 | $1,891,053,085 | |||
| SUM | $2,283,799,352 | |||||
| Enterprise Value(EV) of c corporation Today | $2,283,799,352 | |||||
| Rounded to | $2,284 | Million | ||||