Project Lead - Financial Modeling (MENA Consulting)
GurugramFull-time4–6 yrsPosted 4 days ago
Mid-level finance role at Jones Lang LaSalle Building Operations in Gurugram. Needs 4–6 years and a B.Com, BBA or MBA.
About the role
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.
What you'll do
- Taking complete ownership of the financial model of the real estate mega projects in the region
- Run the various sensitivity and scenario analysis to mitigate the potential risk
- Create a dynamic real estate development model in MS Excel using DCF method. Prepare all financial statements with financial reporting standards
- Develop the various partnership models in real estate sector including JV with private developer (promote structure using cash flow waterfall model)
What you need
- Financial modelling
- Excel
- Financial statements
- Cash flow
- Financial reporting
- Compliance
Good to have
- VBA
- Due diligence