Adv. Excel, Financial modelling

Manya Bhadauria

E-mail :- *********@*****.***

Contact No. :- +918*********

Address :- Paras Seasons, Sector-168, Noida- 201301

OBJECTIVE

Looking for an opportunity in Finance to gain valuable exposure to financial practices, and explore my skill sets to effectively deliver assigned responsibilities & contribute to organizational growth.

SKILLS

Basic & Adv. Excel, Financial Modelling, Financial Analysis, Financial Reporting, Forecasting, Valuations: DCF, Relative Valuation, M & A Analysis, VBA Programming.

PROFESSIONAL EXPERIENCE

9 Months of Experience in Banking as Assistant Manager in ICICI Bank ltd.

Administered Financial process including financial transactions/outward remittance/NPS, Service requests, Overdraft facilities.

Cultivated strong relationship with privilege customers to drive business development.

Assess compliance with financial regulations and controls.

Handling end to end process of pitching product, sourcing business leads & services to customers.

PROJECT UNDERTAKEN

Title: Financial and DCF Model of APACHE CORPORATION

Synopsis: Financial projection combined with valuation of stock & recommendation based on Discounted Cash Flow (DCF)

Learning Outcomes:

Projected the Financial Statements with schedules and assumptions drivers.

Implemented and streamlined cutting-edge data management procedures.

Developed and maintained Financial Model and Standard templates.

Analysis of Debt and Equity to calculate WACC

Calculate Diluted Shares Outstanding of a listed Company

Title: Accretion & Dilution Analysis of Procter and Gamble co & Gillette Co

Synopsis: Analyze the merger impact on EPS of the combined company post merger.

Learning Outcome:

Preparation of Performa Balance Sheet & Income Statement.

How to use transaction Assumption, Calculation of outstanding Shares .

Calculate the effect of Dilutive Securities.

Sensitivity Analysis & Contribution Analysis

CERTIFICATION

Certification in Financial Modelling & Company Valuation using Excel and VBA from Investment Banking Institue, New Delhi.

Certification in Core & Advance Excel from Microsoft (USA)

Certification in Tally ERP.9

ACADEMIA

MBA (Finance) Chandigarh Unversity, Punjab 2019 Secured 8.1/10 CGPA

B.com B. D. Kanya Mahavidyalaya, Agra 2017 Secured 68%

12th (Commerce) GyanDeep Sr. Sec. Public School, Shikohabad 2014 Secured 84.5%

10th GyanDeep Sr. Sec. Public School, Shikohabad 2012 Secured 9.6/10 CGPA

EXTRAMURAL ACTIVITIES

Appreciation Certificate by Regional Head for Best Performance in Delhi NCR.

Summer Internship Project in Axis Bank in the study of Loans.

Participated in various Quizzes, Extempore and Panel discussion events during MBA.

Worked as an Event Coordinator for various events held in Campus during graduation and Postgraduation.

Elected as “Class Representative” during MBA.

Best Prefect Certificate during B.com.

Personal Details

●Father’s Name :- Devendra Kumar Singh Bhadauria

●Date of Birth :- 15 August 1997

●Language Known :- English & Hindi

●Marital Status :- Single

●Gender :- Female

DECLARATION

I do hereby declare that the above information is true to the best of my knowledge.

Signature:-

Manya Bhadauria

Contact this candidate