Financial Modeller - Real Estate Private Equity

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 also invested in a small trading business and intend to keep buying 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 that drive our investment decisions and asset management strategies.TasksDesign 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 capabilitiesWeibull 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 structuresDevelop detailed tax calculation modules covering EBITDA, book values, depreciation, tax loss carried forward accounts, and capital gains analysisModel complex capital expenditure plans using S-curve methodologiesCreate residual land appraisal models for development projectsImplement scenario and sensitivity analysis including Monte Carlo simulations with multi-variable data tablesGenerate clear, presentation-ready output tables and dashboards for investment committee and external stakeholdersPotential to assist with actual reporting for banks and investors as our partnership developsRequirementsAdvanced 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 sectorsDemonstrated expertise in several real estate markets (Germany, UK, and US experience a plus)Deep understanding of loan structures, financing terms, and debt modelling techniquesComprehensive 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 investmentsAbility to create transparent, easy-to-follow models with clear documentationSelf-motivated with excellent communication skillsFluent English (required)German language skills (advantageous)VBA and/or Python skills (advantageous)BenefitsCompletely remote work arrangementFlexible hours that accommodate your existing commitmentsDirect impact in a small, agile team environmentExposure to diverse real estate investment strategiesOpportunity to develop into a long-term partnershipOpportunity to contribute to the development of proprietary tools and systemsIf you're passionate about financial modelling excellence and want to contribute to real estate investment strategies with tangible impact, we'd love to hear from you.We're excited about the possibility of working together!NO RECRUITERS!