Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

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
04.2025 - 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)
05.2021 - 04.2025


  • 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
05.2020 - 06.2020
  • 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
05.2017 - 06.2017
  • 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, India
03-2021

BBA - Finance

Galgotias University
Greater Noida, India
04.2001 - 05.2018

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
04.2025 - Current

Creativity, problem solving and generating alternatives, Udemy

06-2021

Consulting Approach to problem solving Udemy

06-2021

Solution Advisor

Deloitte USI (Offices of the US)
05.2021 - 04.2025

Real Estate Financial Modeling Bootcamp, Deloitte, In-House Training

05-2021

Advanced Excel Skills, Deloitte In-House Training

05-2021

Intern

Reserve Bank of India, RBI
05.2020 - 06.2020

Intern

Steel Authority of India, SAIL
05.2017 - 06.2017

BBA - Finance

Galgotias University
04.2001 - 05.2018

MBA - Finance

IFMR GSB Krea University

Similar Profiles

CREATE PROFILE
Kshitij AgarwalAssociate