At a Glance
- Tasks: Develop an Excel model to calculate ROTE for UK residential mortgages.
- Company: Join a leading consultancy focused on innovative financial solutions.
- Benefits: Enjoy flexible working arrangements and the chance to enhance your skills.
- Other info: This is a consultancy role; IP rights remain with the company.
- Why this job: Make a real impact in the finance sector while honing your Excel expertise.
- Qualifications: Experience in UK mortgage modelling and advanced Excel skills are essential.
The predicted salary is between 48000 - 72000 £ 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:
- Servicing costs
- Origination fees
- 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
- Incorporate Constant Prepayment Rate (CPR) variables
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 in London employer: MPowered
As a leading player in the financial services sector, our company offers an exceptional work environment for consultants looking to make a significant impact in the UK mortgage market. With a strong focus on innovation and professional development, we provide opportunities for growth while fostering a collaborative culture that values expertise and creativity. Join us to leverage your skills in a dynamic setting where your contributions directly influence our strategic objectives.
StudySmarter Expert Advice🤫
We think this is how you could land Excel Modeller (UK Mortgage ROTE Analysis) Contract in London
✨Tip Number 1
Familiarise yourself with the specific requirements of ROTE calculations in the context of UK mortgages. Understanding the nuances of both Standardised and Internal Ratings-Based (IRB) regulatory capital regimes will give you a significant edge during discussions.
✨Tip Number 2
Brush up on your advanced Excel skills, particularly in building flexible models. Being able to demonstrate your proficiency in creating dynamic spreadsheets that can handle various inputs and scenarios will be crucial in impressing us.
✨Tip Number 3
Prepare to discuss your previous experience with UK mortgage modelling and how it relates to the role. Highlight any projects where you've successfully incorporated elements like servicing costs, origination fees, or expected credit losses into your models.
✨Tip Number 4
Network with professionals in the finance and mortgage sectors. Engaging with others who have experience in regulatory capital frameworks can provide insights and potentially valuable connections that may help you land the job.
We think you need these skills to ace Excel Modeller (UK Mortgage ROTE Analysis) Contract in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with Excel modelling, particularly in the context of UK mortgages and regulatory capital frameworks. Use specific examples to demonstrate your skills.
Craft a Strong Cover Letter:In your cover letter, explain why you are the ideal candidate for this consultancy role. Mention your familiarity with ROTE calculations and any relevant projects you've completed in the past.
Showcase Relevant Skills:Emphasise your advanced Excel skills in your application. Include details about your ability to build flexible models and incorporate various financial inputs, as outlined in the job description.
Proofread Your Application:Before submitting, carefully proofread your application for any errors or inconsistencies. A polished application reflects your attention to detail, which is crucial for this role.
How to prepare for a job interview at MPowered
✨Showcase Your Excel Skills
Be prepared to demonstrate your advanced Excel modelling skills during the interview. Bring examples of previous models you've built, especially those related to financial analysis or mortgage calculations, to showcase your expertise.
✨Understand Regulatory Frameworks
Familiarise yourself with both Standardised and Internal Ratings-Based (IRB) regulatory capital regimes. Be ready to discuss how these frameworks impact ROTE calculations and how you would incorporate them into your model.
✨Discuss Key Inputs Thoroughly
Prepare to talk about the various inputs that affect ROTE, such as servicing costs, origination fees, and expected credit losses. Having a clear understanding of how each factor influences the overall model will impress your interviewers.
✨Demonstrate Flexibility in Modelling
Highlight your ability to create flexible models that can adapt to different scenarios, such as varying loan-to-value ratios and fixed-rate terms. Discuss any past experiences where you successfully adjusted models based on changing assumptions.
