4 More Capital Partners is a boutique real estate investment firm specializing in solving complex corporate and real estate challenges through strategic advice and hands-on asset management. We operate across Germany, Austria, and the UK, focusing on delivering transparent, results-driven solutions for our clients. Since 2023, we have also invested in a small trading business and plan to acquire more businesses outside the real estate space. We're now looking to expand our financial capabilities with a talented real estate financial modeller who can develop sophisticated models to 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 assets. Create detailed tenant-by-tenant cash flow projections with advanced lease modelling capabilities. Use Weibull distribution to model residential lease durations and dependencies. Build sophisticated loan models including various financing structures and refinancing scenarios. Develop detailed tax calculation modules covering EBITDA, depreciation, tax loss carryforwards, and capital gains. Model complex capital expenditure plans using S-curve methodologies. Create residual land appraisal models for development projects. Implement scenario and sensitivity analysis, including Monte Carlo simulations with multi-variable data tables. Generate clear, presentation-ready output tables and dashboards for investment committees and external stakeholders. Potentially assist with reporting for banks and investors as our partnership develops. Requirements Advanced Excel proficiency with expert-level formulas (3D references, SUMPRODUCT with multiple conditions, INDEX MATCH with multiple conditions). Proven experience in developing complex real estate financial models, especially in commercial and residential sectors. Experience in multiple real estate markets (Germany, UK, US experience a plus). Deep understanding of loan structures, financing terms, and debt modelling techniques. Knowledge of key real estate performance metrics (net initial yields, yield on cost, debt yield, DSCR, IRR, equity multiples). Experience with tax modelling in real estate investments. Ability to create transparent, well-documented models. Self-motivated with excellent communication skills. Fluent English required; German skills are advantageous. VBA and/or Python skills are advantageous. Benefits Remote work arrangement. Flexible hours. Impactful role in a small, agile team. Diverse exposure to real estate investment strategies. Opportunity for long-term partnership development. Contribute to proprietary tools and systems. If you're passionate about financial modelling and eager to contribute to impactful real estate strategies, we'd love to hear from you. We're excited about the possibility of working together! NO RECRUITERS! #J-18808-Ljbffr