Excel Modeller (UK Mortgage ROTE Analysis) Contract

JR United Kingdom; England; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading consultancy firm is seeking a consultant to develop an advanced Excel model that calculates Return on Tangible Equity (ROTE) for new UK residential mortgages. The role involves detailed financial modeling, requiring expertise in UK mortgage frameworks and advanced Excel skills.

Qualifications

• Experience in UK mortgage modelling and regulatory capital frameworks is essential.

Responsibilities

• Develop a flexible Excel model to calculate ROTE for UK residential mortgages.
• Incorporate all relevant revenues and costs over the life of the loans.

Skills

Advanced Excel modelling

UK mortgage modelling

Regulatory capital frameworks

Job description

Social network you want to login/join with:

col-narrow-left

Client:

MPowered

Location:

england, United Kingdom

Job Category:

Other

-

EU work permit required:

Yes

col-narrow-right

Job Views:

2

Posted:

28.06.2025

Expiry Date:

12.08.2025

col-wide

Job Description:

We are seeking a consultant to develop a comprehensive Excel model that calculates Return on Tangible Equity (ROTE) for pools of newly-originated UK residential mortgages.

Key Requirements:

• Build a flexible Excel model to calculate ROTE at pool level.
• The model must support both Standardised and Internal Ratings-Based (IRB) regulatory capital regimes.

It must incorporate all relevant revenues and costs over the life of the loans, including:

• Expected credit losses (ECL) / impairment
• Liquidity transfer pricing
• Interest rate swap costs
• Any other material inputs

The model must:

• Have the ability to flex CET1 capital allocation input
• Factor in loan-to-value (LTV) ratios
• Assess different fixed-rate terms separately (e.g. 2-year vs. 5-year)
• Include assumptions for customer retention

Engagement Terms:

• This is a consultancy engagement. The individual will not be an employee or director of the company.
• All intellectual property (IP) in the final model and outputs will be retained by the company.

Candidates with experience in UK mortgage modelling, regulatory capital frameworks, and advanced Excel modelling will be prioritised.