Freelance 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 handson asset management. We operate across Germany Austria and the UK focusing on delivering transparent resultsdriven 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.

Were 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 tenantbytenant 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 Scurve methodologies
• Create residual land appraisal models for development projectsImplement scenario and sensitivity analysis including Monte Carlo simulations with multivariable data tables
• Generate clear presentationready output tables and dashboards for investment committee and external stakeholders
• Potential to assist with actual reporting for banks and investors as our partnership develops

Requirements

• Advanced Excel proficiency with expertlevel 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 easytofollow models with clear documentationSelfmotivated with excellent communication skills
• Fluent English (required)
• German language skills (advantageous)
• VBA and/or Python skills (advantageous)

Benefits

• 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 longterm partnership
• Opportunity to contribute to the development of proprietary tools and systems
• Potential for fulltime / parttime retainer arrangement

If youre passionate about financial modelling excellence and want to contribute to real estate investment strategies with tangible impact wed love to hear from you.

Please submit your CV along with a short cover letter containing a detailed compensation proposal and examples of your previous work (anonymised as needed).

Were excited about the possibility of working together!

NO RECRUITERS!