Can you help me with this comparable companies assignment by doing this for around 10 similar companies
Illumina Business Description Input Page to come] General Information Reported Income Statement Balance Sheet Data Company Name Company A Prior Current 2007A 9/30/2008 Ticker AAA Fiscal Year Ending December 31. Stub Stub LTM Cash and Cash Equivalents Stock Exchange NYSE 2005A 2006A 2007A 9/302007 9/30/2008 9/30/2008 Accounts Receivable Fiscal Year Ending Dec-31 Sales Inventories Moody's Corporate Rating NA COG Prepaids and Other Current Assets S&P Corporate Rating NA Gross Profit Total Current Assets Predicted Beta 1.00 SG&A Marginal Tax Rate Other Expense / [Income) Property, Plant and Equipment, net Selected Market Data EBIT Goodwill and Intangible Assets Interest Expensi Other Assets Current Price 1/0/1900 Pre-taz Income Total Assets Income Takes 52-week High Price 1/0/1900 Joncontrolling Interest Accounts Payable 52-week Low Price 1/0/1900 Preferred Dividends Accrued Liabilities Dividend Per Share [MRQ) Net Income Other Current Liabilities Effective You Rate Total Current Liabilities Fully Diluted Shares Outstanding Equity Value Weighted Avg. Diluted Shares Total Debt Diluted EPS NA NA NA NA Other Long-Term Liabilities Plus: Total Debt Total Liabilities Plus: Preferred Stock Plus: Noncontrolling Interest Adjusted Income Statement Noncontrolling Interest Less: Cash and Cash Equivalents Reported Gross Profit Preferred Stock Enterprise Value Non-recurring Items in COGS Shareholders' Equity Adj. Gross Profit Total Liabilities and Equity Trading Multiples Balance Check LTM NFY NFY-1 9/30/2008 2008E 2009E Reported EBIT Calculation of Fully Diluted Shares Outstanding Ev/Sales NA NA NA Jon-recurring Items in COGS Basic Shares Outstanding Metric Other Non-recurring Items Plus: Shares from In-the-Money Options EWEBITDA NA NA NA Adjusted EBIT Less: Shares Repurchased Metric Net New Shares from Options EVEBIT NA NA NA Plus: Shares from Convertible Securities Metric Depreciation & Amortization Fully Diluted Shares Outstanding PIE NA NA NA Adjusted EBITDA Metric Options/Warrant Number of Exercise In-the-Money LTM Return on Investment Ratios Reported Net Income Tranche Shares Price Shares Proceeds Return on Invested Capita Non-recurring Items in COGS Tranche 1 Return on Equity Other Non-recurring Items Return on Asset Non-operating Non-rec. Items Implied Annual Dividend Per Share . . Tranche 2 Tranche 3 Tax Adjustment Tranche 4 Adjusted Net Income Tranche 5 LTM Credit Statistics Total Debt/Total Capitalization Total Debt/EBITDA Adjusted Diluted EPS Convertible Securities Net Debt/EBITDA Conversion Conversion New EBITDA/Interest Expense Amount Price Ratio Shares (EBITDA-capex)/Interest Expense Cash Flow Statement Data Issue 1 EBIT/Interest Expense Depreciation & Amortization ssue 2 Issue 3 Growth Rates Capital Expenditures Issue 4 Sales EBITDA EPS Issue 5 Cover List Benchmarking 1 Benchmarking 2 Ouput TargetCo CompCo 1 CompCo 2 CompCo 3 CompCo 4 CompCo 5 CompCo 6 CompCo 7
