We're now looking to expand our financial capabilities with a talented real estate financial modeller who can develop sophisticated models that drive our investment decisions and asset management strategies.
Tasks
- Design and develop comprehensive real estate financial models for our investment portfolio across CRE and residential assetsCreate meticulous tenant-by-tenant cash flow projections with advanced lease modelling capabilities
- Weibull distribution to model residential lease durations (and all other dependencies)
- Build sophisticated loan models including senior debt, mezzanine financing, capex facilities, refinancing scenarios, and various amortization structures
- Develop detailed tax calculation modules covering EBITDA, book values, depreciation, tax loss carried forward accounts, and capital gains analysis
- Model complex capital expenditure plans using S-curve methodologies
- Create residual land appraisal models for development projectsImplement scenario and sensitivity analysis including Monte Carlo simulations with multi-variable data tables
- Generate clear, presentation-ready output tables and dashboards for investment committee and external stakeholders
- Potential to assist with actual reporting for banks and investors as our partnership develops
- Advanced Excel proficiency with expert-level formula knowledge (3D references, sumproduct with multiple conditions, index match with multiple conditions)
- Proven experience in developing complex real estate financial models, particularly in commercial and residential sectors
- Demonstrated expertise in several real estate markets (Germany, UK, and US experience a plus)
- Deep understanding of loan structures, financing terms, and debt modelling techniques
- Comprehensive knowledge of key real estate performance metrics and how they are calculated (net initial yields, yield on cost, debt yield, DSCR ratios, IRR, equity multiples)
- Experience with tax modelling in real estate investments
- Ability to create transparent, easy-to-follow models with clear documentationSelf-motivated with excellent communication skills
- Fluent English (required)
- German language skills (advantageous)
- VBA and/or Python skills (advantageous)
- Completely remote work arrangement
- Flexible hours that accommodate your existing commitments
- Direct impact in a small, agile team environment
- Exposure to diverse real estate investment strategies
- Opportunity to develop into a long-term partnership
- Opportunity to contribute to the development of proprietary tools and systems
We're excited about the possibility of working together!
NO RECRUITERS!