Yash Bansal
Faridabad
Summary
Analytical commercial real estate professional with 3+ years of experience in underwriting, Argus modeling, Lease Abstraction, Rockport Val, and Asset Summary Reports. Proficient in analyzing leases, assessing asset performance, and delivering actionable insights for strategic decisions. Experienced in reviewing appraisals, inspections, and financial assessments with a focus on accuracy and value optimization. Worked on more than 100+ lease portfolios and argus portfolios.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Analyst - 2
Newmark
Hyderabad
08.2023 - Current
- Performed detailed Argus modeling based on lease abstracts, financial statements, and market data, ensuring accurate and reliable financial forecasting.
- Independently managed retail Argus modeling with over 150 tenants, preparing comprehensive Argus models for more than 100 property portfolios.
- Detailed modeling on Rockport Val, with the help of the rent roll, operating statements, and CAM info.
- Reviewed lease amendments and renewals, ensuring accurate updates to abstracts. Worked on more than 100+ lease abstraction portfolios.
- Systematically researched landlord lookup and true owner data to support tenant and property management activities.
- Collaborated with the U.S. Brokers to implement a streamlined Ownership Lookup and Tenancy Write process.
Analyst - 1
Mcube Financial LLC
Gurugram
01.2022 - 08.2023
- Conducted comprehensive rent roll, unit mix, and cash flow analyses for self-storage, office, and retail properties to support underwriting processes.
- Performed thorough assessments of fixed-rate mortgage underwriting and CMBS loans.
- Prepared detailed Asset Summary Reports through extensive online research and analysis of third-party reports, appraisal reports, property condition reports (PCRs), and environmental site assessments (ESAs).
- Reviewed and abstracted leases, amendments, and other real estate documents to evaluate lease economic terms and renewal schedules.
- Successfully co-managed a diverse portfolio of 50+ leases, maintaining compliance with operational policies and financial protocols.
Education
BBA.LLB - Corporate Law
University of Petroleum and Energy Studies
Dehradun01.2022
Class XII -
Modern Delhi Public School
Faridabad01.2017
Class X -
Modern Delhi Public School
Faridabad01.2016
Skills
- Lease abstraction
- Cash flow Analysis
- Asset Summary Report
- Market Research
- Landlord lookup
- Valuation
- Argus Modeling
- Rockport Val Modeling
- Excel Valuation
- Rent Roll Audit and Memo
Accomplishments
- Extra Miller Award – Q4, Year-End 2024, Newmark
- Rockstar Award - Q2, Q3, Year-End 2024, Newmark
- Rockstar Rookie Award - Q1, Year-End 2024, Newmark
- Extra Miller Award – Q3, Year-End 2023, Newmark
Certification
- Commercial Real Estate Lease Modelling - Hosted by Udemy
- National Moot Court - Hosted by University of Jharkhand
- Coordinated various events at school and college department level.
- Four times scholar badge holder at school for excellent academic performance.
- Awarded Merit Certificate by CBSE for excellent performance in volleyball.
Timeline
Analyst - 2
Newmark
08.2023 - Current
Analyst - 1
Mcube Financial LLC
01.2022 - 08.2023
- Commercial Real Estate Lease Modelling - Hosted by Udemy
- National Moot Court - Hosted by University of Jharkhand
- Coordinated various events at school and college department level.
- Four times scholar badge holder at school for excellent academic performance.
- Awarded Merit Certificate by CBSE for excellent performance in volleyball.
BBA.LLB - Corporate Law
University of Petroleum and Energy Studies
Class XII -
Modern Delhi Public School
Class X -
Modern Delhi Public School
Similar Profiles
Enrique Rick ReyesEnrique Rick Reyes
Corporate Facility EH&S Manager at NewmarkCorporate Facility EH&S Manager at Newmark
Nicole GendrauNicole Gendrau
Tenant Service Coordinator at NewmarkTenant Service Coordinator at Newmark
Arul KumaresanArul Kumaresan
Manager at NewmarkManager at Newmark