Varun Rohatgi

Address: Ras Vihar Apartment, IP Extension, New Delhi-110092 (India)

Mobile: +91-886**-*****

E-mail: adgk3v@r.postjobfree.com

OBJECTIVE

To work in an esteemed organization where I can continuously learn new skills and utilize the acquired knowledge to deliver outstanding results fostering a rewarding career. PROFESSIONAL QUALIFICATION

Pursuing Certified Financial Planner (CFP) course from Financial Planning Standard Board

Chartered Accountant from Institute of Chartered Accountants of India in November 2015 – Scored 53% (1st attempt)

o IPCC Group II in November 2013 – Scored 53%

o IPCC Group I in November 2012 – Scored 68%

o CPT in December 2011 – Scored 65%

EDUCATIONAL QUALIFICATION

Master of Commerce (Finance & Taxation) from Indira Gandhi National Open University in 2015 – Scored 57%

Bachelor of Commerce from Delhi University in 2014 – Scored 52%

12th from Central Board of Secondary Education in 2011 – Scored 73%

10th from Central Board of Secondary Education in 2009 – Scored 67% PROFESSIONAL CERTIFICATIONS & SKILLS

Certification in NCMP Level-1 (NSE Certified Market Professional) and Investment Banking

Well versed with MS-Office Applications including MS-Excel, MS-PowerPoint and MS-Word

Key Skills - Valuation, Financial Modelling, Financial Statement Analysis, Ratio Analysis, Financial Due Diligence, Accounting & Book keeping, Project Appraisal, Information Memorandums, Teasers, Company Profiles, Research, Target Screening, Competitive Benchmarking, etc.

Softwares acquainted with Capital IQ, Pitchbook, Merger Market, LCD Research, BVD Orbis, Factiva, Factset, Preqin, VCCEDGE, Venture Intelligence, Tally ERP, Alteryx, Index Destination, Prowess IQ and Capital Line database

Sectors worked on Consumer & Retail, Healthcare, Real Estate, Education, Automotive, Technology, Media & Telecom, Manufacturing, Gaming, etc.

Experience of working on projects with global clients operating in India, US, UK, Netherlands, Germany, Sweden, Finland, Denmark, Switzerland, Italy, Norway, Japan, etc. WORK EXPERIENCE

Acuity Knowledge Partners (earlier Moody's Analytics Knowledge Services - MAKS), Gurgaon (Jul’19- Present) – Delivery Lead

Key result areas-

Understanding company's business model, evaluating market size, identifying growth drivers, analyzing trends, SWOT analysis, competitive benchmarking on various financial and operating parameters

Financial Analysis, including trend analysis/variance analysis, comparing performance of companies during business cycles, ratio analysis, identifying relevant KPIs of the industries

Creation and updation of detailed financial models including DCF, M&A, etc.

Trading & transaction comps, valuation analysis through different techniques

Conducting industry research and preparation of company profiles

Application of analytical methods used in the start-up ecosystem like unit economics and cohort analysis Corporate Catalyst India Private Limited, Gurgaon (Oct’18- Jul’19) – Associate Key result areas-

Prepared company profiles/teasers and pitch books

Sell side advisory for Aluminum Curtain Wall solution provider company based out of India having turnover of USD 40 Mn

Due Diligence of Braking company catered to Automobile segment having turnover of around USD 35 Mn

Company valuation- Business valuation and/or RBI valuation using Discounted Cash Flow Method o Business valuation of Pre- School, Insulation product based company, Car Distributor company and Technology device company

o Valuation using Companies Comparable/ Companies Transaction Multiple method EY Global Delivery Services, Gurgaon (Mar’18- Oct’18) – Senior Analyst Key result areas-

Summarizing and analyzing financial information (trial balances, income statements, balance sheets and cash flows)

o Reconciliation of information provided by management with the audited financial statements o Highlighting unusual trends, observations and frame questions for management

Prepared data books and company profiles

Data book, due diligence report and financial model consistency/review Nangia & Co. LLP, Noida (Jun’17- Mar’18) – Associate Key result areas-

Sell side advisory for a

o North India based Lingerie Manufacturing company with a turnover of USD 6 Mn o Snacks & savory company with a turnover of USD 4 Mn

Preparation of pitch books, Teasers, Information Memorandums and Financial Models

Research and transaction analysis of specific industry segments and potential targets

Analysis of financial statements, ratio analysis Haribhakti & Co. LLP, New Delhi (Apr’16– Jun’17) – Associate Key result areas-

Financial due diligence – Responsibilities were to vouch business plan, review, update and prepare financial models, financial analysis of historical financial statements, preparation of data books, sending queries to the management for any variances, writing due diligence report and preparation of PowerPoint presentations for different committees, review of report prepared by team. Clients handled including: o National Skill Development Corporation (Education sector) o Real Estate company based out of Gurgaon

Application of ‘Discounted Cash Flow’ valuation method and been part in writing valuation report

Data room creation for company based out of Healthcare sector: Responsibilities were to create data room for financial, tax and legal due diligence and deal closure activities like reviewing Term sheet

Project Appraisal for National Institute of Rural Development under Deen Dayal Upadhyaya Grameen Kaushalya Yojana (DDU-GKY) scheme

Building relationship with new clients

Analysis of financial statements, business and industry analysis, research on potential target INTERNSHIP

Tandon Brij & Co., New Delhi (Apr‘13 to Jan’15) and Aditya & Associates, New Delhi (Jan’15 to Mar’16)

Worked as a team leader/ team member in various Statutory audit assignments

Exposure of Direct tax and Tax audit assignments

Exposure of Accounting, book keeping and filing of various statutory returns PERSONAL DOSSIER

Date of Birth: 6th

October 1993

Languages: English and Hindi

Marital Status: Unmarried

Passport Holder: Yes (Passport No. Z3540022)

(Varun Rohatgi)

Contact this candidate