CMBS Originations & Underwriting - AVP

Overview

Assistant Vice President in CMBS Originations & Underwriting at Barclays, supporting the team through financial modelling and deal review of loan requests, and leading a team on complex tasks that impact the wider business function.

What you'll do

• Review offering memos prepared by brokers and/or borrowers to understand the real estate and the requested financing.
• Evaluate and compile property-level income statements, rent rolls, reimbursements, occupancy statistics, 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, using third-party sources (such as CoStar, Reis, Smith Travel Research and others) and public information.
• Review tenant leases and related documentation and prepare an abstract of key terms.
• Evaluate historical and projected capital expenditure budgets.
• Prepare asset summary reports covering property and market characteristics, and the strengths and weaknesses of the transaction.
• Perform underwriting and due diligence of acquisition facilities.
• Carry out quarterly performance analysis of Balance Sheet loans, including analysing financial statements, rent rolls, occupancy statistics, covenant tracking, and transaction updates.
• Manage CMBS data and aid in aggregating, sourcing, and populating centralized databases.
• Drive streamlining, automation and tool building to assist decision making and increase efficiency, including optimisation and automation of databases and standardised reports.
• Set objectives and coach employees, appraise performance relative to objectives, and determine reward outcomes.
• Advise and influence decision making, contribute to policy development, and take responsibility for operational effectiveness.

What you'll need

• Basic/essential qualifications as stated in the source are the core requirements for this role.

Nice to have

• Postgraduate degree (or equivalent).
• Prior experience in real estate finance or securitized products such as CMBS or RMBS.
• Excellent knowledge of real estate metrics and financial statements.
• Experience working in CMBS issuances and managing data.
• Experience preparing narratives or asset summary reports of the transaction.
• Good at senior stakeholder engagement.
• Strong analytical skills and a hands-on approach to problem solving.
• Expert in PowerPoint presentations, writing reports and designing storyboards.
• Strong knowledge and hands-on experience in one of Python, VBA, R or C++ (highly preferred).
• Proficiency in MS Excel, Word and PowerPoint.
• Programming skills or exposure to Tableau, Qlikview or Python (added benefit).
• Exposure to Generative AI/ML.
• Experience working on Argus Software.
• Familiarity with Bloomberg or Trepp.
• Familiarity with market reports such as CoStar and REIS.

Details

• Based in Mumbai (Nirlon Knowledge Park, 9th and 11-12 floors).