OUR CLIENT is the successful private equity property company who are well known name in developing and trading of both commercial and residential property and who operate and manage real estate funds. Now they are seeking a Financial Manager / Analyst to join their Real Estate finance team on 12-month contract basis to 'own' and update their complex Excel appraisal model amongst other related tasks.
THE ROLE responsibilities for the Financial Manager - Modeller will include:
- Producing 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 investments, across different real estate sectors with differing funding and profit-sharing arrangements. Sense checking assumptions through to underlying documentation.
- Updating group business plans/forecasts.
- Preparing sensitivity analysis of the project appraisals, modelling various funding and exit scenarios.
- Assisting team members with operational project.
- Preparing the detailed investor call and distribution calculations.
- Producing and managing the quarterly investor return reporting, completing Fund and investment level metrics via investor portals/templates.
- Assisting with various ad hoc accounting tasks (account reconciliations (e.g. inter-co, VAT, equity invested) NAV calcs, corporate disposal/liquidation support, management account reviews).
THE PERSON - Required Skills to apply:
- You will be a fully qualified (ACCA/CIMA/ACA or similar) with proven transferable skills gained in the real estate sector.
- Strong Excel skills with the ability to model.
- Prior experience of manipulating and maintaining appraisal models.
- Resourceful, self-starter and prepared to roll sleeves up.
- Detail orientated and an independent thinker.
- Investigative - not prepared to accept anything at face value.
- Good presentation and communication skills.
BENEFITS:
- Hybrid working model - c 3 days in office (4/5 initially).
- Completion Bonus
- 25 days holiday
- Pension
Please visit our website to view all our vacancies. Follow us or connect with us on LinkedIn
Please note that due to volume we cannot get back to everyone, however every application is looked at and considered and will be held on Trident International's database for review. If you have not heard back from us within 5 working days you should assume your initial application has been unsuccessful, however if suitable roles arise in the future we will make every effort to contact you.