US GAAP Company Valuation and Analysis -Semi Cap

We need an expert in US GAAP public statements, who is strong in excel and familiar with Capital IQ and has MBA quality valuation skills. The project involves spreading financial numbers over last 10 quarters from the source documents, carefully reading the footnotes, adjusting the numbers for all non cash and one time charges, calculating Total enterprise value and adjusted EBITDA multiples based on fully diluted share count using the treasury method, and then doing basic valuation analysis including comparable company and precedent transaction analysis.

There will be very basic or no forecasting beyond guidance given in the transcript. If its not clear -we would expect no projections. We have a standard model and is accompanied by specific instruction steps (see below). We focus on accuracy vs. false [url removed, login to view] must read the footnotes and footnote all sources and assumptions.

The assignment is broken down into 2 parts to be delivered seqentially. The first part is purely on the quantitative portion (steps 1-4).

The 2nd part includes qualitative, but with a defined format (See Step 5) as well as actual valuation work. An example will be provided. We are not expecting in substantial primary research beyond the public documents and analyst research (which we will provide)-but the higher the quality the more assignments we will make available.

If we work well together you can assume we will be regularly sending you additional companies for review

PLease submit relevant examples of quantitative and qualitative work product.

Active Owners Fund Master Template Instructions

1. OP Model Tab

- Spread numbers of target company (i.e. historical and projected revenue by segment, revenue drivers / metrics, last 3 years and last 8 quarters, from revenue down to Net Income )

- EBITDA calculation - add back non-cash charges (i.e. SBC expense), 1x charges (i.e. restructuring, compensation, insurance, etc..) and show pro forma EBITDA

- Also show PF EBITDA - Capex

- Show y-o-y change in revs by segment as well as q-o-q sequential changes

- Show Margin analysis - gross margin, op margin, EBITDA margin, Net Income margin, etc...

- Show Op expense ratios - SG&A as % of sales, R&D as % of sales, etc...


2. Projections Tab

- illustrate your basic assumptions on your projections in order for us to be able to follow your logic

3. Master Tab Part I

- TEV Calculation -

a) determine latest common shares outstanding

b) determine if there are class b shares / units outstanding

c) Treasury Stock Method for option dilution (located outside of print area in cell T26)

d) RSU's & RSA's outstanding

e) fully diluted shares * share px = equity value

f) Less Cash + Debt + Min Interest / Pref Stock

- Update LTM Rev, EBITDA, EBITDA-Capex and show LTM Trading multiples, Run-Rate (seasonally adjusted), and NTM multiples

- Seasonality Adjustment - Tab labled "INC Quart" can be used to seasonally adjust latest Run-rate depending on Quarter

4. Comps Tab

- Lay out relevant comps using CapIQ "Quick Comps"for competitors (re-evaluate comps) but use your scrubbed numbers for target company

- Lay out Street expectations vs. AOF expectations to show divergence

- "M&A Comps Tab" - layout precedent M&A Comps

5. Master Tab Part II

- Qualitatitive description - thesis, risks / mitigants, value proposition, company history, business overview, market overview, comp advantages, recent transactions, market share over time (losing or gaining share?), customer concentration, competitor profiles, etc...

- we have included an example of some qualitative work we have performed on AH .

6. Calculations Tab / Earnings Power Value

- Top section allows you to view op margin %, D&A%, SBC%, Tax Rate% over various historical periods; however, we would like to input

assumptions in Column G and provide reasons for using the inputed values in Column H

7. DCF Tab

- straightforward DCF, link to your op model going forward

Kemahiran: Kajian Kewangan, Kajian Pasaran, Penilaian & Penaksiran

Lihat lagi: gaap cap analysis, who can expert in excel, treasury analyst, transaction focus, transaction charges, top segment, top financial analyst, top 10 competitors, the standard insurance, the power company, the n and o, the layout company, steps in market research, standard insurance company, skills of a business analyst, share cash, review for company, review a company, quantitative analyst, power part 2

Tentang Majikan:
( 5 ulasan ) New York, United States

ID Projek: #887378

Dianugerahkan kepada:


Hi Ben, As discussed

$200 USD dalam 3 hari
(5 Ulasan)

7 pekerja bebas membida secara purata $173 untuk pekerjaan ini


Experienced financial researcher

$200 USD dalam 3 hari
(12 Ulasan)

Take professionals advise ,, as Discussed

$200 USD dalam 2 hari
(1 Ulasan)

For steps 1-4 (Quant analysis) - $125 From Step 5 (Qualitative parts) - $75 Pl refer the sample research report I have attached.

$200 USD dalam 7 hari
(0 Ulasan)

$150 plus some bonus as per industry norms

$150 USD dalam 15 hari
(0 Ulasan)

I find your job essentials closely match my skills as I m a masters student in Financial markets and derivatives at one of the prestigious universities of London. You can expect and rely on me to perform your work with Lagi

$135 USD dalam 3 hari
(0 Ulasan)

The Job profile mentioned is my daily work profile, I am well versed with this profile and have my personal Capital IQ ID. Let me know ASAP if you are intrested.

$125 USD dalam 3 hari
(0 Ulasan)