Gaurav Chopra Email and Phone Number

Financial due diligence for buy side and sell side transactions:• Conducted analysis such as Quality of Earnings, Net Working Capital and Net Indebtedness of the target company• Analysing true revenue and cost drivers, any one- time or non-recurring, accounting adjustment, pro-forma adjustment activities of the target that shall not continue post transaction and quantification of their impact on the final headline price• Critical analysis such as churn and retention analysis, vintage analysis etc. for deals revolving around food and beverage or restaurant chains• Preparation of client deliverables and reports.

Financial due diligence and valuations , TS practice- USA region - Creating income statement and balance sheet statements of target companies and detailed lead sheets- Working capital analysis and highlighting key seasonality trends and peg- Net Indebtedness analysis as potential Enterprise value driver- Quality of earning analysis - driving normalised EBITDA value from reported EBITDA value by identifying one-off expenses/income and other management identified adjustments, audit adjustments, proforma adjustments, accounting adjustments etc. - Key customer concentration analysis, NLE (New/Lost/Existing) customer analysis, vintage analysis, Customer/store stratification analysis, revenue by channels, vintage analysis, Percentage of completion contract, run rate analysis and probable run rate impact on future revenue and Ebitda - Working hand in hand with the research and valuation team to identify the correct valuation method and applying the model to normalized Ebitda to ascertain the valuation of the company. - Methods such as DCF, comparing companies or comparing transactions within similar industry or sectors. - Worked on a big sell-side deal for one of the Top 3 pet food/grooming services retail chain store of the USA.

Lender due Diligence practice, Asset-based lending (ABL)- AR and inventory borrowing base calculation - Net borrowing amount banks can lend to their customers after considering certain ineligibles that are discussed in scope of engagement and on basis of Advance rate- Waterfall construction to identify the probable ineligibles- AR/AP/Inventory reconciliation - To tie-out the AR/AP per the agings and Inventory per the perpetuals to their respective amounts per the GL/TB and FS (BS) and identifying possible ineligibles for waterfall construction.- Top AR/AP concentration, past due concentration -Inventory by type/location-Shipping/aging test, Credit memo and cash application procedures, Inventory cost test, Gross margin procedures-Understanding cash cycle of the target from overview perspective-Report writing for client submission-Worked for ABL deals for Essar, Toys R US, O'Neal Steel

Business Analyst Intern

- Competitor analysis for Big 4 Banking firms of Australia like NAB, ANZ, Westpac, Commonwealth bank- Assisted in preparation of Fund sheets for Islamic Shariah banking firms of the GCC region like Qatar Islamic Bank, Bank of Bahrain and Kuwait, Al Rajhi, CIMB , understanding fundamentals of Islamic(Shariah) banking practices.- Assisted in Financial Statement Analysis for a Chinese Hedge Fund- Assisted in the validation processes for a European stock exchange for mass global distribution of unique identity numbers aftermath the Financial Crisis of 2008