Financial Modeller & Analyst
- Recruiter
- Marks Sattin
- Location
- England, London, City of London
- Salary
- £35000.00 - £45000.00 per annum
- Posted
- 02 Aug 2022
- Closes
- 09 Aug 2022
- Ref
- BBBH170801
- Contact
- Rebekah Froom
- Job Title
- Finance Analyst
- Category
- Banking and Financial Services
- Experience Levels
- Entry Level
- Contract Type
- Permanent
- Hours
- Full Time
A STEPPING STONE INTO FRONT OFFICE.
A UK based fund manager, with 60 years experience in real estate funds, is looking to add a junior financial modeller & analyst to their team.
This role will be best suited to a graduate or junior who has had some exposure to financial modelling, whether that is through a degree, internship or work experience.
In this role you will be working closely with the asset management and investment management teams and you will be able to learn the different return structures since you will be updating the appraisals and cash flow modelling in this role.
The hiring manager has mentioned that they foresee someone progressing onto a front office or investment management role after 1-2 years in this role, as he believes this will be a great stepping stone for someone looking to get into front office.
Responsibilities of financial modeller and analyst:
- Responsible for production of quarter end Fund reports including completion of detailed project level (excel) appraisals (with updated actuals), consolidated Fund level cash flow forecasts and returns.
- Modelling and reviewing existing and new investments, across different real estate sectors with differing funding and profit-sharing arrangements. Sense checking assumptions through to underlying documentation and working with the asset management/investment teams.
- Sensitivity analysis of the project appraisals, modelling various funding and exit scenarios.
- Assisting the finance and asset management team with operational project management.
- Preparation of the detailed investor call and distribution calculations (including fee and carry calculations).
- Production and management of the quarterly investor return reporting, completing Fund and investment level metrics via investor portals/templates.
Requirements of financial modeller and analyst:
- Strong excel skills
- Knowledge of financial modelling and experience in financial modelling (through a degree/internship/work experience)
- Part of the interview process will involve building a cash flow forecast model from scratch so understanding and demonstration is required