Question: PLEASE SHOW ALL CACULATION STEPS USING EXCEL. IDEX Labs is a privately held developer of advanced securities systems. Its owners are considering taking company public

PLEASE SHOW ALL CACULATION STEPS USING EXCEL.

IDEX Labs is a privately held developer of advanced securities systems. Its owners are considering taking company public and they need to estimate intrinsic value of the stock to be issued. The plan is to sell 50 million shares in IPO.

Use the following information:

Debt: $30 million

Excess cash: $100 million

Expected FCF in 2015: $52.5 million

FCF growth rate: 4.5%

WACC: 8.8%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Asbat Pharmaceuticals (Asbat) is a leading pharmaceutical company that has been in existence for 22 years. Asbat has a calendar year-end and is audited annually. Asbat only operates in the United...

1.IDEX Labs is a privately held developer of advanced securities systems. Its owners are considering taking company public and they need to estimate intrinsic value of the stock to be issued. The...

You will be asked to select a company that is publicly traded. You must research and secure the SEC 10-K Annual Report for the most recent year. This is often available at the company web site. Look...

. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on a...

1. What are the advantages and disadvantages of Rosetta Stone going public? 2. What do you think the current value of a share of Rosetta Stone is (at the time of the case)? Justify your valuation on...

Please use the numbers provided on the financial statements found on pages 59 through 63. 20 1 5 A N N UA L R E P ORT \u0007\u0003\u0006\u0003\u0016\u0003\u0003 \u0003...

You will write a 2 - 3 page paper, single spaced, one inch margins, 12 pt font, with double space between paragraphs. Your paper should comment on the financial statements for your company as they...

Attached are both the full project description and the General Motors SEC report. 2-3pagesinglepagepaper,1inchmargins,12pt.font...

Hello, I havetwo articles about S Corp. and C Corp., and IJUST need towrite a conclusion paragraph based on professor's questions. can you help me to write it? Articles are attached Accounting...

Northwest Cape Pty Ltd offers very selected long-term customers 14-day credit terms relating to their offshore deep-sea fishing tours. Whilst the company has few bad debts, the business does maintain...

An employer has a duty to accommodate the special needs of a physically or mentally disabled employee unless the accommodation causes undue hardship. What is the duty to accommodate? What are some...

Let vec ( r ) ( t ) = ( : t 5 - 4 , 2 e 4 t , - 4 s i n ( 3 t ) : ) Find the unit tangent vector vec ( T ) ( t ) a t the point t = 0 vec ( T ) ( 0 ) =

Data on the physical inventory of Katus Products Co. as of December 31 follows: Quantity and cost data from the last purchases invoice of the year and the next-to-the-last purchases invoice are...

Given the following hypotheses: H 0 : 10 H 1 : > 10 A random sample of 10 observations is selected from a normal population. The sample mean was 12 and the sample standard deviation 3. Using the...

Use MATLAB and the Symbolic Math Toolbox to input and form LTI objects in polynomial and factored form for the following frequency functions: a. b. 45(s? + 37s+ 74)(s + 28s? + 32s + 16) (s+ 39)(s+...

For the unity feedback system shown in Figure P8.3, where do the following: a. Sketch the root locus. b. Find the asymptotes. c. Find the range of gain, K, that makes the system stable. d. Find the...

It has been suggested that the use of closed-loop feedback in ventilators can highly reduce mortality and health problems in patients in need of respiratory treatments (Hahn, 2012). A good knowledge...

The five essential functions that every manager must perform include: Question 1 8 options: planning organizing directing staffing controlling

Who holds the power in recruitment and selection?

Explain the effectiveness of various selection methods

Explain the nature of attraction in recruitment