Freelance Financial Modeller - Real Estate Private Equity

4 More Capital Partners; London; Remote; Confidential; Full time

Job summary

An established industry player in real estate investment is seeking a talented financial modeller to enhance their investment strategies. This role offers the opportunity to design sophisticated financial models that inform decision-making across various asset classes. Join a small, agile team where your contributions will have a direct impact on investment outcomes. With a completely remote work arrangement and flexible hours, this position allows you to balance your commitments while engaging in meaningful work. If you are passionate about financial modelling and eager to make a difference, we encourage you to apply!

Benefits

Completely remote work arrangement

Flexible hours

Direct impact in a small team

Exposure to diverse investment strategies

Opportunity for long-term partnership

Development of proprietary tools and systems

Qualifications

• Proven experience in developing complex financial models.
• Deep understanding of loan structures and financing terms.

Responsibilities

• Design and develop comprehensive real estate financial models.
• Create tenant-by-tenant cash flow projections and advanced lease models.

Skills

Advanced Excel proficiency

Real estate financial modeling

Loan structures and debt modeling

Tax modeling in real estate

Communication skills

Fluent English

German language skills

VBA skills

Python skills

Job description

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 that drive our investment decisions and asset management strategies.

Tasks

1. Design and develop comprehensive real estate financial models for our investment portfolio across CRE and residential assets.
2. Create meticulous tenant-by-tenant cash flow projections with advanced lease modelling capabilities.
3. Use Weibull distribution to model residential lease durations and all other dependencies.
4. Build sophisticated loan models including senior debt, mezzanine financing, capex facilities, refinancing scenarios, and various amortization structures.
5. Develop detailed tax calculation modules covering EBITDA, book values, depreciation, tax loss carried forward accounts, and capital gains analysis.
6. Model complex capital expenditure plans using S-curve methodologies.
7. Create residual land appraisal models for development projects.
8. Implement scenario and sensitivity analysis including Monte Carlo simulations with multi-variable data tables.
9. Generate clear, presentation-ready output tables and dashboards for investment committees and external stakeholders.
10. Potentially assist with actual reporting for banks and investors as our partnership develops.

Requirements

1. Advanced Excel proficiency with expert-level formula knowledge (3D references, sumproduct with multiple conditions, index match with multiple conditions).
2. Proven experience in developing complex real estate financial models, particularly in commercial and residential sectors.
3. Demonstrated expertise in several real estate markets (Germany, UK, and US experience is a plus).
4. Deep understanding of loan structures, financing terms, and debt modelling techniques.
5. 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).
6. Experience with tax modelling in real estate investments.
7. Ability to create transparent, easy-to-follow models with clear documentation.
8. Self-motivated with excellent communication skills.
9. Fluent English (required).
10. German language skills (advantageous).
11. VBA and/or Python skills (advantageous).

Benefits

1. Completely remote work arrangement.
2. Flexible hours that accommodate your existing commitments.
3. Direct impact in a small, agile team environment.
4. Exposure to diverse real estate investment strategies.
5. Opportunity to develop into a long-term partnership.
6. Opportunity to contribute to the development of proprietary tools and systems.
7. Potential for full-time / part-time retainer arrangement.

If 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.

Please submit your CV along with a short cover letter containing a detailed compensation proposal (hours available per month × USD rate per hour) and examples of your previous work (anonymised as needed).

We're excited about the possibility of working together!

NO RECRUITERS!