Financial Modeller - Real Estate Private Equity at 4 More Capital Partners

, , Colombia -

Full Time

Start Date

Immediate

Expiry Date

17 Jan, 26

Salary

0.0

Posted On

19 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Financial Modelling, Excel Proficiency, Real Estate Markets, Loan Structures, Financing Terms, Debt Modelling, Real Estate Performance Metrics, Tax Modelling, Communication Skills, VBA Skills, Python Skills, Cash Flow Projections, Lease Modelling, Scenario Analysis, Sensitivity Analysis, Monte Carlo Simulations

Industry

Financial Services

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 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. Tasks Design 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 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 S-curve methodologies Create residual land appraisal models for development projectsImplement scenario and sensitivity analysis including Monte Carlo simulations with multi-variable data tables Generate clear, presentation-ready 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 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 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, easy-to-follow models with clear documentationSelf-motivated 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 long-term partnership Opportunity to contribute to the development of proprietary tools and systems 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. We're excited about the possibility of working together! NO RECRUITERS!

Responsibilities

Design and develop comprehensive real estate financial models for the investment portfolio, including cash flow projections and loan models. Implement scenario and sensitivity analysis to support investment decisions and asset management strategies.