Commercial Real Estate Financial Analyst
Current• Leading the preparation of quarterly reports for the investment partnerships and Goodman group.Analysing and reporting on net property income, arrears, leasing activity, and capex across a portfolio of 110+ logistics assets in continental Europe.• Managing a property master list for 2 investment partnerships, ensuring accurate financial reporting and analysis.• Presenting quarterly reports on the financial performance of the commercial real estate portfolios to senior management.• Overseeing and reporting on a portfolio of 30+ photovoltaic installations, including financial performance and maintenance costs.• Preparation of comprehensive financial overviews for 80+ customers, including credit risk analysis.• Calculation, analysis, and reporting of property services fees (e.g., property management, capex project management, leasing, legal).• Ensuring compliance with IFRS 16 standards through analysis and reporting of right-of-use assets.• Reviewing and reporting on judgmental items and doubtful debt provisioning, maintaining accuracy and compliance.• Participating in the setup of reporting structures for new investment products like PV installations, EVCI, and data centres.• Contributing to forward-looking projections including annual net property income, capex budget, and quarterly reforecast using TM1 IBM Planning Analytics.• Leveraging advanced IT tools including Yardi for portfolio management, U4F for accounting, and MS Excel for financial modelling and analysis.• Using MS Power BI, Power Query, and Power Pivot for data visualization and analysis, ensuring robust reporting capabilities.• Working with Data Warehouse and SQL Master Data Services to maintain data integrity and facilitate accurate financial reporting.