Vibhor Rastogi
Delhi
Overview
3
3
years of professional experience
1
1
Certification
Work History
Analyst Grade 1
Mcube Advisors Private Limited
Gurugram
07.2023 - Current
- On-Site Client: Citibank and 3650REIT
- Preparation of rent rolls for property types such as multifamily, commercial, Self-Storage and Hotels aimed at determining the annualized in-place rent against the market rent prevailing.
- Compiling the cash flows i.e. historical, Broker statements or budget for understanding growth/decline among different years.
- Underwriting the broker statement in client based model, through rent roll based annualized income for determination of net operating income for calculating in-place value of the property as per the capitalization rate provided by the broker.
- Sizing the loan provided using ratios such as DSC and LTV as per banking standards provided.
Finance Intern
Bata India Limited
Gurugram
06.2022 - 07.2022
- Prepared a brief report stating YoY and QoQ growth in revenue and PBT margins.
- Analyzed monthly statements of competitor firm with Bata through diving deeper into income and expenses. Understanding major role of expenses in each company through segregating income and expenses line items, and further preparing key parameter index for the same.
- Analyzing of each vertical of Bata for determining of major contributing vertical.
- Further calculating PAT margins for each company for comparison purposes.
Finance Analyst
Nirvana Solutions
Gurugram
12.2020 - 05.2021
- On-site client: Think Investments
- Matched instruments bought, held and sold electronically with custodian and internal statements.
- Tax-lot Reconciliation: Kept record for dates of sale and purchase, transaction size for each security in the portfolio with custodian and internal statements.
- P&L Reconciliations: Summarizing the profit/loss booked at any squaring off of positions.
- Cash Reconciliations: Recording the cash balance at the end of the day and reconciling with custodian and internal statements.
Education
MBA - Finance
G.D Goenka University
Gurugram06-2023
Commerce
Delhi University
Delhi10-2020
High School Diploma -
Bal Bharati Public School
Delhi03-2017
Skills
- Commercial Real Estate Loan Sizing
- Data Analysis
- P&L Analysis
- Internal Trade Reconciliations
- Financial Modeling
- MS Excel, Word and Powerpoint
- Fundamental Analysis
Accomplishments
- Student Core Committee Member in Fintech Virtual Conference, 2021.
- E-Sports Competition (Ist Position, held in G.D Goenka University)
- Participated in Table Tennis tournaments in college
- Black Belt in Karate
Certification
- NISM-Series-XVIII: Financial Education Certification Examination
- Financial Analysis Fundamentals (CFI)
- Advanced Technical Analysis (Udemy)
- Swing trading and Options trading.
- Business Valuation Modeling (CFI)
- Learnt DCF Valuation.
- Economics & International Business (IBMI)
- Value Investing (Udemy)
Timeline
Analyst Grade 1
Mcube Advisors Private Limited
07.2023 - Current
Finance Intern
Bata India Limited
06.2022 - 07.2022
Finance Analyst
Nirvana Solutions
12.2020 - 05.2021
MBA - Finance
G.D Goenka University
Commerce
Delhi University
High School Diploma -
Bal Bharati Public School
Similar Profiles
Archit AgarwalArchit Agarwal
Financial Analyst at MCube AdvisorsFinancial Analyst at MCube Advisors
Mudarakola Lokesh KumarMudarakola Lokesh Kumar
Revenue & Accounts Receivables at Kristal Advisors Private LimitedRevenue & Accounts Receivables at Kristal Advisors Private Limited
Aditya GargAditya Garg
Accounts Executive at Right Advisors Private LimitedAccounts Executive at Right Advisors Private Limited
Selva Prabhu JSelva Prabhu J
Senior Planning Engineer at Larsen & Toubro ConstructionSenior Planning Engineer at Larsen & Toubro Construction
Abhishek MandalAbhishek Mandal
Senior Customer Service Representative at ConcentrixSenior Customer Service Representative at Concentrix