Project Lead - Financial Modeling (MENA Consulting)

Overview

Own the financial model of real estate mega projects in the MENA region, covering financial modelling, cash flow projection, investment analysis and financial due diligence, and lead a team of junior modelers.

What you'll do

• Take complete ownership of the financial model of the real estate mega projects in the region.
• Carry out financial modelling, cash flow projection and investment analysis for real estate projects using the DCF method.
• Prepare financial statements (cash flow, P&L and balance sheet) for real estate in line with the relevant financial reporting standards and local/regional compliance.
• Calculate return analysis and other financial performance indicators to prepare the investment memorandum.
• Run various sensitivity and scenario analyses to mitigate potential risk.
• Conduct financial due diligence of real estate mega projects.
• Create a dynamic real estate development model in MS Excel using the DCF method.
• Prepare all financial statements in accordance with financial reporting standards.
• Model various development strategies for a masterplan megaproject (self-development, land sale and land lease to sub developer).
• Run the optimal capital structure of a real estate investment, including detailed financing structure with refinancing flexibility.
• Develop partnership models in the real estate sector, including JV with private developer (promote structure using a cash flow waterfall model).
• Model a real estate fund.
• Model VAT and escrow for UAE and KSA compliance.
• Run sensitivity and scenario analysis of the real estate investment to mitigate potential risks.
• Lead a team of junior modelers and develop strong relationships with clients.

What you'll need

• 4-6 years' financial modelling experience in MS Excel for regional projects.
• Previous technical background in real estate financial modelling.
• Master's degree in real estate, finance or business.
• Advanced Excel skills.
• Excellent analytical skills, with strong attention to detail.
• Strong leadership qualities.
• Excellent understanding of various local/GCC compliance laws (VAT modelling, escrow modelling for UAE and KSA).
• Excellent verbal and written communication skills in English.
• Ability to work to meet deadlines, even when timeframes are demanding.

Nice to have

• VBA skills.
• FMVA certification.

Details

• Location: On-site, Gurugram, HR.
• Scheduled weekly hours: 40.