Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop an Excel model to calculate ROTE for UK residential mortgages.
- Company: Join a forward-thinking consultancy focused on innovative financial solutions.
- Benefits: Enjoy flexible working arrangements and the chance to enhance your Excel skills.
- Why this job: Make a real impact in the finance sector while gaining valuable experience.
- Qualifications: Ideal for those with advanced Excel skills and knowledge of UK mortgage modelling.
- Other info: This is a consultancy role, not an employee position, with IP retained by the company.
The predicted salary is between 30000 - 42000 £ per year.
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
- 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.
Excel Modeller (UK Mortgage ROTE Analysis) Contract employer: MQube
Contact Detail:
MQube Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Excel Modeller (UK Mortgage ROTE Analysis) Contract
✨Tip Number 1
Familiarise yourself with the UK mortgage market and regulatory capital frameworks. Understanding the nuances of Standardised and Internal Ratings-Based (IRB) regimes will give you an edge in discussions during the interview.
✨Tip Number 2
Brush up on your advanced Excel skills, particularly in building flexible models. Be prepared to discuss specific functions or techniques you've used in past projects that relate to ROTE calculations.
✨Tip Number 3
Prepare examples of how you've handled complex financial modelling in the past. Highlight any experience with expected credit losses (ECL) or liquidity transfer pricing, as these are key components of the role.
✨Tip Number 4
Network with professionals in the finance and mortgage sectors. Engaging with industry experts can provide insights into current trends and challenges, which may come in handy during your interview.
We think you need these skills to ace Excel Modeller (UK Mortgage ROTE Analysis) Contract
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the requirements of the Excel Modeller position. Familiarise yourself with ROTE calculations and the specific needs for UK residential mortgages.
Highlight Relevant Experience: In your CV and cover letter, emphasise any previous experience you have with UK mortgage modelling, regulatory capital frameworks, and advanced Excel skills. Use specific examples to demonstrate your expertise.
Tailor Your Application: Customise your application materials to reflect the key requirements mentioned in the job description. Show how your skills align with the need for a flexible Excel model that incorporates various financial inputs.
Proofread Your Documents: Ensure that your CV and cover letter are free from errors. A polished application reflects attention to detail, which is crucial for a role that involves complex financial modelling.
How to prepare for a job interview at MQube
✨Showcase Your Excel Skills
Make sure to highlight your advanced Excel modelling skills during the interview. Be prepared to discuss specific functions and techniques you've used in previous projects, especially those related to financial modelling and ROTE calculations.
✨Understand Regulatory Capital Frameworks
Familiarise yourself with both Standardised and Internal Ratings-Based (IRB) regulatory capital regimes. Being able to explain how these frameworks impact mortgage modelling will demonstrate your expertise and understanding of the industry.
✨Prepare for Technical Questions
Expect technical questions related to UK residential mortgages, including topics like expected credit losses (ECL) and liquidity transfer pricing. Brush up on these concepts so you can answer confidently and accurately.
✨Discuss Flexibility in Modelling
Be ready to talk about how you would build a flexible model that accommodates various inputs, such as CET1 capital allocation and loan-to-value ratios. Providing examples from past experiences can help illustrate your approach.
