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%