Question

In: Finance

You are trying to value ListoFact, a data processing company. The company generated $ 1 billion...

You are trying to value ListoFact, a data processing company. The company generated $ 1 billion in revenues in the most recent financial year and expects revenues to grow 3% a year in perpetuity. It generated $ 30 million in after-tax operating income in the most recent financial year and expects after-tax operating margin to double over the next 3 years (in equal annual increments ). After year 3, the margin will stabilize at year 3 levels forever. The firm is expected to have depreciation of $ 20 million and capital expenditures of $15 million each year for the next 3 years and to earn a 10% return on capital in perpetuity after that. There are no working capital requirements. The cost of capital will be 12% for the next 3 years and 10% thereafter. a. Estimate the free cashflows to the firm each year for the next 3 years. b. Estimate the value of the firm at the end of the third year (terminal value) c. Estimate the value of equity per share today, if the firm has $ 150 million in debt outstanding, $ 25 million as a cash balance and 10 million shares

Solutions

Expert Solution

Details Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
Sales with 3% growth rate $       1,000,000,000 $    1,030,000,000 $      1,060,900,000 $     1,092,727,000 $      1,125,508,810 $     1,159,274,074 $            1,194,052,297
After Tax operating Margin 3% 4% 5% 6% 6% 6% 6%
a After Tax operating Margin $ $         41,200,000 $            53,045,000 $          65,563,620 $            67,530,529 $          69,556,444 $                  71,643,138
b Add : Depreciation 20,000,000 20,000,000 20,000,000 0 0 0
c Less : Capital Expenditure             15,000,000                15,000,000              15,000,000                                -                                -                                        -  
d Free Cash Flow=a+b-c $         46,200,000 $            58,045,000 $          70,563,620 $            67,530,529 $          69,556,444 $                  71,643,138
e FCF Growth Rate 26% 22% -4% 3% 3%
So FCF growth Rate from Year 4 is g=3%
Let Us find the Enterprise value of ListoFact
Details Year 1 Year 2 Year 3
Free Cash flow $            46,200,000 $         58,045,000 $            70,563,620
PV factor @ Cost of Capital 12% 0.8929 0.7972 0.7118
PV of FCF for first 3 years $            41,251,980 $         46,273,474 $            50,227,185
f Sum of PV of FCF for fisrt 3 years = $          137,752,639
Terminal Value of FCF at Year 3
Growth rate =g=3%
Cost of Capital from Yr 4=10%
So Terminal Value of FCF at Yr3=67530529/(10%-3%)= $ 964,721,837.14
Cost of Capital till Yr 3=12%
g So PV of Terminal Value =$964,721,837.14/(1.12)^3= $ 686,669,948.31
h Now Enterprixe value of ListoFact=f+g= $    824,422,587.03
i Outstanding Debt = $          150,000,000
j Cash balance = $      25,000,000.00
k Market Value of Equity=EV-Debt+Cash=h-i+j= $    699,422,587.03
l No of Common Stock outstanding =                10,000,000
m Value of Equity share =k/l= $                      69.94

Related Solutions

Internet giant Zoidle, a U.S. company, generated sales of £2.5 billion in the United Kingdom in...
Internet giant Zoidle, a U.S. company, generated sales of £2.5 billion in the United Kingdom in 2013 (approximately $4 billion in U.S. dollars). Its net profits before taxes on these sales were £200 million, and it paid £6 million in corporate tax, resulting in a tax rate of 3 percent. The corporate tax rate in the United Kingdom is between 20 percent and 24 percent. The CEO of Zoidle held a press conference stating that he was proud of his...
You are trying to value the following project for your company. You know that the project...
You are trying to value the following project for your company. You know that the project will generate free cash flows in perpetuity that will grow at a constant annual rate of 2% after year 2. The applicable interest rate for this project is 11%. What is the NPV of this project? Express your result in $-millions (do not include the $-symbol in your answer). If you calculate a negative NPV enter a negative number. Free Cash Flow Forecasts (in...
An analyst is trying to value KL’s stock. The analyst has collected data from the company...
An analyst is trying to value KL’s stock. The analyst has collected data from the company and other sources to prepare the below financials, both actual and projected. Based upon these sources, the analyst expects the company’s free cash flows to grow at 8% in 2019, 6% in 2020, and at 4% on average thereafter. The analyst has estimated the company’s cost of capital to be 12.01%. Given this and the below information, what is the value of the firm?...
Question 1 You are trying to value the stock of Cowbell Inc. You know that the...
Question 1 You are trying to value the stock of Cowbell Inc. You know that the firm only uses dividends to return cash to its investors and you have forecasted the dividends for the 4 years (see table below). You believe that dividends will grow at a constant rate of 2% each year after year 4. The cost of equity is 13%. Given this information estimate the share price for Cowbell Inc. Round your answer to two decimals (do not...
The market value of​ Fords' equity, preferred stock and debt are $7 billion, $1 billion, and...
The market value of​ Fords' equity, preferred stock and debt are $7 billion, $1 billion, and $10 billion, respectively. Ford has a beta of 1.8​, the market risk premium is 7​%, and the​ risk-free rate of interest is 3​%. Ford's preferred stock pays a dividend of $4.50 each year and trades at a price of $26 per share. Ford's debt trades with a yield to maturity of 9.5​%. What is​ Ford's weighted average cost of capital if its tax rate...
7–2. Ethical Conduct. Internet giant Zoidle, a U.S. company, generated sales of £2.5 billion in the...
7–2. Ethical Conduct. Internet giant Zoidle, a U.S. company, generated sales of £2.5 billion in the United Kingdom in 2013 (approximately $4 billion in U.S. dollars). Its net profits before taxes on these sales were £200 million, and it paid £6 million in corporate tax, resulting in a tax rate of 3 percent. The corporate tax rate in the United Kingdom is between 20 percent and 24 percent. The CEO of Zoidle held a press conference stating that he was...
Explain the Data Processing Cycle? thank you
Explain the Data Processing Cycle? thank you
You working as a fund manager and trying to value the stock of MELUR Berhad. Company...
You working as a fund manager and trying to value the stock of MELUR Berhad. Company has 10 million shares outstanding. All the answer must be calculated in Microsoft Excel. Below are the projections for the next four years based on the following assumptions: MELUR Berhad -Sales will be RM 600 million in year 1 -Sales will grow at 20% in year 2 and 3 while at year 4 is 15% -Interest expenses will be RM30 million per year -Depreciation...
Define data processing and explain the steps to be followed for data processing
Define data processing and explain the steps to be followed for data processing
You are trying to value the stock of XYZ Corp. Total earningsfor year 1 are...
You are trying to value the stock of XYZ Corp. Total earnings for year 1 are forecasted to be $115 million. You know that the company plans on paying out 33% of its earnings in the form of dividends and 23% in the form of share repurchases each year, and that all of the growth in future earnings will be through retained earnings. The company's return on new investment is 15%, its cost of equity is 12% and it has...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT