Project Lead - Financial Modeling (MENA Consulting)

Jones Lang LaSalle (JLL); Gurugram District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Jones Lang LaSalle (JLL) in Gurugram is seeking a senior real estate financial modeller. You will own and build complex MS Excel models, perform cash flow projections, and conduct investment analyses using DCF methods for regional mega projects.

Prepare statutory-like financial statements and lead junior modelers while coordinating with clients. The role requires 4–6 years of experience in real estate financial modelling, strong Excel/VBA skills, and excellent communication.

Qualifications

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

Responsibilities

• Take ownership of the financial model for regional real estate mega projects.
• Perform cash flow projection and investment analysis using DCF.
• Prepare financial statements (CF, P&L and Balance Sheet) following standards.
• Run sensitivity and scenario analysis to mitigate risks.
• Lead a team of junior modelers and coordinate with clients.

Skills

Advanced Excel

VBA

Financial Modelling

DCF

Leadership

Communication

Education

Master's degree in real estate/finance/business

FMVA certification

Tools

MS Excel

Job description

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, PL 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

Gurugram

Scheduled Weekly Hours

40

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.