Kshitij Agarwal
Associate
Summary
Experienced professional bringing self-motivated mindset and in-depth background of completing valuations of commercial real estate, property appraisal review, lease abstraction, accounting and administration. Motivated professional with business acumen and willingness to take on challenging roles.
Overview
8
8
years of professional experience
2038
2038
years of post-secondary education
4
4
Certifications
2
2
Languages
Work History
Associate
Morgan Stanley
2025.04 - Current
- Preparation of appraisal reports for the collaterals within 3 - 6 months based on the downgrade/upgrade of loan.
- Analysis of the collateral values based on the credit reviews and documents that have loan performance i.e. NOI or tenant changes, vacancy and all other critical assumptions.
- Reviewed and assessed third-party appraisal reports and client-prepared valuations model Challenged and tested assumptions and sensitivities at an asset level and provided insightful valuation analysis.
Solution Advisor
Deloitte USI (Offices of the US)
2021.05 - 2025.04
- Comparable Company and Comparable Transaction Analysis, Cost Approach using MS Excel and Argus Enterprise software.
- Extensively worked on three approaches of valuation (Income - DCF and Direct Capitalization method, Cost and Market).
- Fair Value Measurement and Audit Review (ASC 820): Executed and coordinated several valuation and fair value audit review engagements by testing the logical and mathematical accuracy of complex valuation models of various asset classes (CRE, Residential, Data Centers, Industrial and Senior Housing).
- Managed all aspects of real estate and non-real estate lease abstraction engagements, involving lease data validation and lease covenants analysis based on easement contracts specialized in validating monetary obligations of the tenants with the lease documents, operating statements, general ledger, and other invoices.
- Managed engagements involving implementation of new Lease Accounting Standards (ASC 842). Additionally, worked on Lease Data Migration engagements involving tools like LeaseAccelerator, Tririga, Co-Star Real Estate Manager and Lucernex Performed in-depth market research with hands-on experience in using financial databases such as Co-Star, S&P Capital IQ, REIS (Moody's Analytics), RCA (Real Capital Analytics).
- Managed Deloitte's Learning and Development team across Advisory group Provided training and mentoring to new/ junior team members and assisted intra team knowledge transfer program's.
Intern
Reserve Bank of India, RBI
2020.05 - 2020.06
- Analyzed the roles and scope of Local Area Banks in the Indian Banking System.
- Assessed and examined problems faced by these Local Area banks and recommended solutions to Local Area Bank to make them more profitable entity.
- Collected the data from various banks and then analyzed the situation and gave recommendations to the RBI to make these entities more viable.
Intern
Steel Authority of India, SAIL
2017.05 - 2017.06
- Aim of this internship was to find the power consumption in different plants and find the ways to curb these expenditures.
- Collected the data from various plants and then analyzed how much amount they are spending on power and fuel.
- Analyzed data through variance analysis.
Education
MBA - Finance
IFMR GSB Krea University
Chittoor, India2021-03
BBA - Finance
Galgotias University
Greater Noida, India 2001.04 - 2018.05
Skills
- Valuation
- Lease Advisory Services
- Financial Modeling
- Argus
- Audit Review
- Data Analysis
- MS - Office
Accomplishments
- Awarded Spot Awards (2021, 2022, 2024) and an Applause Award (2022) for exemplary performance.
- Runner up in Finnix at (2019) a finance case study competition, IIT Madras.
- Core Member of HBR Ascend Select
Certification
Creativity, problem solving and generating alternatives, Udemy
Timeline
Associate
Morgan Stanley
2025.04 - Current
Creativity, problem solving and generating alternatives, Udemy
2021-06
Consulting Approach to problem solving Udemy
2021-06
Solution Advisor
Deloitte USI (Offices of the US)
2021.05 - 2025.04
Real Estate Financial Modeling Bootcamp, Deloitte, In-House Training
2021-05
Advanced Excel Skills, Deloitte In-House Training
2021-05
Intern
Reserve Bank of India, RBI
2020.05 - 2020.06
Intern
Steel Authority of India, SAIL
2017.05 - 2017.06
BBA - Finance
Galgotias University
2001.04 - 2018.05
MBA - Finance
IFMR GSB Krea University