Freelance Financial Modeller - Real Estate Private Equity

4 MORE Capital Partners; United Kingdom; Remote; GBP 50,000 - 70,000; Full time

Job summary

A boutique real estate investment firm seeks a talented financial modeller to develop sophisticated models for investment decisions and asset management strategies. The role offers remote work, flexible hours, and an opportunity for long-term partnership in a small, agile team.

Benefits

Remote work arrangement

Flexible hours

Impactful role in a small team

Diverse exposure to investment strategies

Opportunity for long-term partnership

Qualifications

• Proven experience in developing complex real estate financial models.
• Deep understanding of loan structures and financing terms.
• Fluent in English; German skills advantageous.

Responsibilities

• Design and develop comprehensive real estate financial models.
• Build sophisticated loan models and tax calculation modules.
• Generate clear, presentation-ready output tables for stakeholders.

Skills

Advanced Excel

Financial Modeling

Communication

Self-motivated

Fluent in English

Tools

VBA

Python

Job description

Get AI-powered advice on this job and more exclusive features.

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

We're now looking to expand our financial capabilities with a talented real estate financial modeller who can develop sophisticated models to inform 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. Create detailed tenant-by-tenant cash flow projections with advanced lease modeling capabilities.
2. Use Weibull distribution to model residential lease durations and other dependencies.
3. Build sophisticated loan models including senior debt, mezzanine financing, capex facilities, refinancing scenarios, and various amortization structures.
4. Develop detailed tax calculation modules covering EBITDA, book values, depreciation, tax loss carryforwards, and capital gains analysis.
5. Model complex capital expenditure plans using S-curve methodologies.
6. Create residual land appraisal models for development projects. Implement scenario and sensitivity analyses, including Monte Carlo simulations with multi-variable data tables.
7. Generate clear, presentation-ready output tables and dashboards for investment committees and external stakeholders.
8. Potentially assist with reporting for banks and investors as our partnership develops.

Requirements

1. Advanced Excel proficiency with expert-level formulas (e.g., 3D references, SUMPRODUCT with multiple conditions, INDEX-MATCH with multiple conditions).
2. Proven experience in developing complex real estate financial models, especially in commercial and residential sectors.
3. Experience in several real estate markets (Germany, UK, US experience is a plus).
4. Deep understanding of loan structures, financing terms, and debt modeling techniques.
5. Knowledge of key real estate performance metrics (net initial yields, yield on cost, debt yield, DSCR, IRR, equity multiples).
6. Experience with tax modeling in real estate investments.
7. Ability to create transparent, easy-to-follow models with clear documentation. Self-motivated with excellent communication skills.
8. Fluent in English (required). German language skills are advantageous.
9. VBA and/or Python skills are advantageous.

Benefits

1. Remote work arrangement.
2. Flexible hours to accommodate your commitments.
3. Impactful role in a small, agile team environment.
4. Diverse exposure to real estate investment strategies.
5. Opportunity for long-term partnership.
6. Contribute to developing proprietary tools and systems.
7. Potential for full-time or part-time retainer arrangement.

If you're passionate about financial modeling and want to contribute to impactful real estate investment strategies, we'd love to hear from you.

Please submit your CV, a short cover letter with a detailed compensation proposal (hours per month × USD rate/hour), and examples of your previous work (anonymized if needed).

We're excited about the possibility of working together!

NO RECRUITERS!

Seniority level

• Associate

Employment type

• Contract

Job function

• Finance

Industries

• Professional Services