Assistant VP - Global Markets

.

Overall purpose of role

The Mumbai team supports the CMBS Underwriting and Origination team through financial modelling and deal review of the loan requests that they receive. The team prepares Loan Review Forms, Preliminary Underwriting/ Cash Flow Models, and Asset Summary Reports that help in determining whether Barclays should proceed with each transaction; and the loan amount, loan structure and spreads to be charged. The team is also responsible for creating and maintaining a database of static information for all the Conduit and SASB Deals issued since 2015 which allows easy comparisons for current deals and better due diligence.

The candidate would be based out of Mumbai and help the team to size the number of deals that the team currently works on with the CMBS underwriters and Originators in New York and Los Angeles.

Key Accountabilities

• Review Offering Memos prepared by brokers and/or Borrowers to gain an understanding of the real estate and the requested financing
• Evaluate and compile property level income statements, rent roll, reimbursements, occupancy statics, sales and occupancy cost information and other information into excel-based models
• Compile market research to determine and verify a project’s economics and assumptions in the model. Market research will include third party sources (such as CoStar, Reis, Smith Travel Research and others) as well as public information available on the internet
• Review tenant leases and related documentation and prepare an abstract of key terms.
• Evaluate historical and projected capital expenditure budgets
• Prepare asset summary reports which cover short descriptions of property and market characteristics, and strengths and weaknesses of the transaction
• Underwriting & Due Diligence of the Acquisition facilities
• Quarterly performance analysis of Balance Sheet loans which include analysing the financial statements, rent rolls, occupancy statistics, covenants tracking, and transaction updates for the loans
• Manage CMBS data and aid in aggregating, sourcing, and populating centralized databases

Stakeholder Management and Leadership

• The candidate would directly interact with the CMBS Origination teams. They would have to interact with the team members on a regular basis to make sure that the various models, reports and projects that they are developing are as per requirements

Decision-making and Problem Solving

• The candidate will have to be proactive in identifying issues and getting them resolved by coordinating with various stakeholders
• The candidate needs to work on several time sensitive activities and hence is required to be meticulous and efficient
• The candidate should have great eye for detail and should ensure that he/she meets the zero-error tolerance requirement as most output forms a critical input for business decision making

Risk and Control Objective

Ensure that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Barclays Policies and Policy Standards.

Person Specification

Personal attributes essential to performing role including competencies, expertise, knowledge, and experience. 

Essential Skills/Basic Qualifications:

• Postgraduate Degree (or equivalent)
• With prior experience in Real Estate finance or securitized products like CMBS, RMBS, etc
• Excellent knowledge of Real Estate metrics and financial statements
• Experience working in CMBS issuances and managing data
• Excellent in Analytical skills and will be responsible for analyzing the results of the tests that they have developed
• Experience in preparing Narratives or Asset Summary reports of the transaction
• Proficiency in MS Excel, Word and PowerPoint

Desirable skills/Preferred Qualifications:

• Experience in Due Diligence process
• Experience of working on Argus Software
• Familiar with Bloomberg or Trepp
• Familiar with various market reports like CoStar & REIS