Mayank Bhardwaj
Financial Analyst
New Delhi
Summary
Financial professional with 3 years of comprehensive experience in financial data analysis and strategic forecasting. Known for strong collaborative efforts and delivering consistent results in dynamic environments. Skilled in financial modeling, data interpretation, and strategic planning, with a proactive approach to adapting to changing business needs.
Overview
3
3
years of professional experience
7
7
years of post-secondary education
2
2
Languages
Work History
Financial Analyst
Vichara Technologies Pvt. Ltd.
10.2022 - Current
- Replication of financial models.
- Worked on various Property types such as Office, Multi family, self storage and Retail.
- Creating Standard operating procedures on how the underwriting models and asset plans work and explaining each step in detail.
- Detail Quality check for Client Deliverables.
- Update and mapping of financial statements in Argus.
- Finding the bug in the model and finding the solution.
- Modification of formulas and made toggles if required in the financial models.
- Build a model from scratch and linking of financial statements.
- Goodwill Impairment (ASC-350) and Purchase Price Allocation (ASC 805).
- Valuation of various companies using the Income and Market approach.
- Calculating DCF, WACC,IRR,NPV and FCFF.
- Research of various companies and make reports according to requirements.
- Use the various Macro template for calculating volatility and the Option price model (Backsolve-409a).
- Math check of Financial models.
Analyst
JLL, Jones Lang LaSalle
01.2022 - 09.2022
- Analyzed financial statements of U.S commercial real estate.
- Worked on various capital sources such as FNMA, FMAC CMBS, GA, FHA.
- Reconciliation of operating statements and analyzed the balance sheet.
- Consolidation of financial data and ratio analysis
- Analyzed income, expenses, and net operating income.
- Used Advanced MS-excel techniques for managing financial data.
- Quality analysis of the published tasks.
- Monitor and audit the accuracy of processed financial statements.
- Prepare the Qc matrix and variance reports.
- Depth analysis of rent rolls and update the occupancy.
- Compared the previous year's analysis with the current and created meaningful report for the clients.
- Interacting with clients for guidelines changes and task deadlines.
Education
Master of Commerce -
School of Open Learning, Delhi University
New Delhi, India 07.2020 - 06.2022
Bachelor of Commerce -
Sri Venkateswara College, Delhi University
New Delhi, India 07.2017 - 06.2020
CBSE -12th - Commerce With Mathematics
Red Roses Public School
New Delhi, India 04.2016 - 03.2017
CBSE - 10th -
Red Roses Public School
New Delhi, India 04.2014 - 03.2015
Skills
Financial modeling
Problem solving
Stakeholder management
Microsoft Excel
Budget compliance
GAAP and statutory reporting
Preparing budgets
Financial and operational reporting
Due diligence
Financial management
Financial statement analysis
Financial modeling
Timeline
Financial Analyst
Vichara Technologies Pvt. Ltd.
10.2022 - Current
Analyst
JLL, Jones Lang LaSalle
01.2022 - 09.2022
Master of Commerce -
School of Open Learning, Delhi University
07.2020 - 06.2022
Bachelor of Commerce -
Sri Venkateswara College, Delhi University
07.2017 - 06.2020
CBSE -12th - Commerce With Mathematics
Red Roses Public School
04.2016 - 03.2017
CBSE - 10th -
Red Roses Public School
04.2014 - 03.2015
Similar Profiles
Palash JainPalash Jain
Cloud and Storage Engineer L2 at Vichara TechnologiesCloud and Storage Engineer L2 at Vichara Technologies
Avnish KumarAvnish Kumar
Technical Lead at Vichara Technology India Pvt. Ltd.Technical Lead at Vichara Technology India Pvt. Ltd.
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)