Job Title: CMBS Origination & Underwriting
Location: Mumbai About Barclays
Barclays is a British universal bank. We are diversified by business, by different types of customers and clients, and by geography. Our businesses include consumer banking and payments operations around the world, as well as a top-tier, full service, global corporate and investment bank, all of which are supported by our service company which provides technology, operations and functional services across the Group. Risk and Control Objective
Take ownership for managing risk and strengthening controls in relation to the work you do. Working Flexibly We\xe2\x80\x99re committed to providing a supportive and inclusive culture and environment for you to work in. This environment recognises and supports ways to balance your personal needs, alongside the professional needs of our business. Providing the opportunity for all our employees, globally to work flexibly empowers each of us to work in a way that suits our lives as well as enabling us to better service our customers\xe2\x80\x99 and clients\xe2\x80\x99 needs. Whether you have family commitments or you\xe2\x80\x99re a carer, or whether you need study time or wish to pursue personal interests, our approach to working flexibly is designed to help you balance your life. If you would like some flexibility, then please discuss this with the hiring manager, and your request will be reviewed subject to business needs Hybrid Working Structured hybrid role:
At Barclays, we offer a hybrid working experience that blends the positives of working alongside colleagues at our onsite locations, together with working from home. We have a structured approach where colleagues work at an onsite location on fixed, \xe2\x80\x98anchor\xe2\x80\x99, days of the week, for a minimum of two days a week or more, as set by the business area (or nearest equivalent if working part-time hours). Please discuss the working pattern requirements for the role you are applying for with the hiring manager. Please note that as we continue to embed our hybrid working environment, we remain in a test and learn phase, which means that working arrangements may be subject to change on reasonable notice to ensure we meet the needs of our business.

Introduction: 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.

What will you be doing? o Review Offering Memos prepared by brokers and/or Borrowers to gain an understanding of the real estate and the requested financing
o Evaluate and compile property level income statements, rent roll, reimbursements, occupancy statics, sales and occupancy cost information and other information into excel-based models
o Compile market research to determine and verify a project\xe2\x80\x99s 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
o Review tenant leases and related documentation and prepare an abstract of key terms.
o Evaluate historical and projected capital expenditure budgets
o Prepare asset summary reports which cover short descriptions of property and market characteristics, and strengths and weaknesses of the transaction
o Underwriting & Due Diligence of the Acquisition facilities
o 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
o Manage CMBS data and aid in aggregating, sourcing, and populating centralized databases What we\xe2\x80\x99re looking for:

• 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

Skills that will help you in the role:

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

Where will you be working?
Mumbai

Be More at Barclays
At Barclays, each day is about being more \xe2\x80\x93 as a professional, and as a person. \xe2\x80\x98Be More @ Barclays\xe2\x80\x99 represents our core promise to all current and future employees. It\xe2\x80\x99s the characteristic that we want to be associated with as an employer, and at the heart of every employee experience. We empower our colleagues to Be More Globally Connected, working on international projects that improve the way millions of customers handle their finances. Be More Inspired by working alongside the most talented people in the industry, and delivering imaginative new solutions that are redefining the future of finance. Be More Impactful by having the opportunity to work on cutting-edge projects, and Be More Valued for who you are.
Interested and want to know more about Barclays? Visit home.barclays/who-we-are/ for more details.
Purpose, Values and Mindset

We deploy finance responsibly to support people and businesses, acting with empathy and integrity, championing innovation and sustainability, for the common good and the long term.
Our values underpin everything we do: Respect, Integrity, Service, Excellence and Stewardship.

Respect
We harness the power of diversity and inclusion in our business, trust those we work with, and value everyone\'s contribution.
Integrity
We operate with honesty, transparency and fairness in all we do.
Service
We act with empathy and humility, putting the people and businesses we serve at the centre of what we do.
Excellence
We champion innovation, and use our energy, expertise and resources to make a positive difference.
Stewardship
We prize sustainability, and are passionate about leaving things better than we found them.

Our Mindset shapes how we take action, living by our Values, driven by our Purpose, always with our customers and clients at the heart of what we do; our Mindset is to Empower, Challenge and Drive.

Empower
Trust and support each other to deliver. Make decisions with those closest to the topic. Include diverse perspectives. Celebrate success and learn from failure.
Challenge
Question whether things can be done better. Use insights based on data to inform decisions. Be curious about how we can adapt and improve. Speak up and be open to alternative viewpoints.
Drive
Focus on outcomes. Deliver with pace. Be passionate and ambitious about what we do. Take personal responsibility. Actively build collaborative relationships to get things done.