Project Lead - Financial Modeling (MENA Consulting)

Jones Lang LaSalle Incorporated; Gurugram District; On-site; INR 1,500,000 - 2,600,000; Full time

Job summary

Jones Lang LaSalle Incorporated is seeking a seasoned real estate financial modeller to take ownership of regional mega project financial models. You will build DCF-based cash flow projections, prepare P&L/CF/Balance Sheet statements, and analyze investment viability for real estate developments.

Strong Excel/VBA skills and leadership to guide junior modelers are essential. The role requires 4-6 years of relevant experience, a Master’s in real estate/finance/business, and excellent English

Qualifications

• 4-6 years of financial modelling experience in MS Excel for regional projects.
• Previous technical background in real estate financial modelling.
• Excellent written and verbal communication in English.

Responsibilities

• Create a dynamic real estate development model in MS Excel using DCF method.
• Prepare all financial statements with financial reporting standards.
• Develop partnerships models and determine optimal capital structure for real estate investments.

Skills

Financial modelling

Excel

DCF analysis

Leadership

Communication

Education

Master’s degree in real estate / finance / business

Tools

MS Excel

VBA

Job description

JLL empowers you to shape a brighter way. Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether you’ve got deep experience in commercial real estate, skilled trades or technology, or you’re looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.

Overview: Taking complete ownership of the financial model of the real estate mega projects in the region. Financial modelling, cash flow projection and investment analysis for real estate projects using DCF method. Preparation of Financial Statements (CF, P&L and Balance Sheet) for real estate adhering to the relevant financial reporting standards and local/regional compliance. Calculation of return analysis and other financial performance indicators to prepare the investment memorandum. Run the various sensitivity and scenario analysis to mitigate the potential risk. Financial due diligence of real estate mega projects. Advanced Excel skills. VBA is added advantage. Excellent analytical skills.

General Competencies

• Strong leadership quality – able to lead a team of junior modelers and develop strong relationships with clients.
• Bright, intelligent, fast learner, enthusiastic, motivated.
• Clear communicator with strong presentation skills.
• Strong analytical background with attention to detail.
• Strong organizations skills with the ability to work on multiple tasks and prioritize.
• Show proof of rigor and autonomy when working.
• Ability to work to meet deadlines, even when timeframes are demanding.

Professional Competencies

• Create a dynamic real estate development model in MS Excel using DCF method.
• Prepare all financial statements with financial reporting standards.
• Excellent understanding and modelling skills of various development strategy for a masterplan megaproject (self-development, land sale and land lease to sub developer).
• Excellent understanding to run the optimal capital structure of a real estate investment including detailed financing structure with refinancing flexibility.
• Develop the various partnership models in real estate sector including JV with private developer (promote structure using cash flow waterfall model).
• Excellent understanding and modelling skills of a real estate fund model.
• Excellent Knowledge and understanding of various local/GCC compliance law (VAT modelling, escrow modelling for UAE and KSA).
• Able to run the sensitivity and scenario analysis of the real estate investment to mitigate the potential risks.

Other Competencies

• Excellent verbal and written communication skills in English.
• Corporate written communication.
• Willingness to take on new challenges.
• Efficiently use words to communicate complex ideas.
• Be capable of managing stress & accepting constructive feedback.

Experience

• 4-6 years’ financial modelling experience in MS Excel for the regional projects.
• Previous technical background in real estate financial modelling.

Education Qualifications

• Master’s degree in real estate / finance / business.
• FMVA certification is added advantage.

Location

On-site –Gurugram, HR Scheduled Weekly Hours: 40

Job Tags

Real Estate Industry Knowledge

Jones Lang LaSalle (“JLL”) is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLL’s recruitment process. We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely. For more information about how JLL processes your personal data, please view our Candidate Privacy Statement. For additional details please see our career site pages for each country.

Jones Lang LaSalle (“JLL”) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities.

At JLL, we harness the power of artificial intelligence (AI) to efficiently accelerate meaningful connections between candidates and opportunities. Using AI capabilities, we analyze your application for relevant skills, experiences, and qualifications to generate valuable insights about how your unique profile aligns with the specific requirements of the role you're pursuing.

At JLL, we give you the opportunity, knowledge and tools to own your success, because we value what makes each of us unique. We help our people thrive, grow meaningful careers and find a place where they belong. Together, we strive to be exceptional and shape a better world. For over 200 years, JLL (NYSE: JLL), a leading global commercial real estate and investment management company, has helped clients buy, build, occupy, manage and invest in a variety of commercial, industrial, hotel, residential and retail properties. A Fortune 500® company with operations in over 80 countries around the world, our employees bring the power of a global platform combined with local expertise. Driven by our purpose to shape the future of real estate for a better world, we help our clients, people and communities SEE A BRIGHTER WAYSM.

JLL is the brand name, and a registered trademark, of Jones Lang LaSalle Incorporated. For further information, visit jll.com.