Financial Modeller

3 months ago

London, United Kingdom Inspired Villages Full time

We’re driven by our purpose to build real communities, which enhance the lives of our residents every single day. We are seeking a **Financial Modeller** to join our expanding real estate analysis team.

After six years of phenomenal growth and numerous awards, we are backed by a joint venture partnership between Legal & General PLC and NatWest Group Pension Trustee Limited. We are on course to significantly transform the later living experience in the UK with a commitment to expand our portfolio to 34 retirement villages, which equates to around 5,000 age-appropriate homes for retirees.

If you’re looking for a career which means more and gives you more, personally, and professionally, there’s a place for you here at Inspired Villages.

**The Role**:
***Business Planning Model**
- Building a new integrated three statement financial model (cash flow, P&L and balance sheet)
- Using the model to forecast the cash funding requirements as fully occupied villages are acquired by the Real Estate Investment Trust (REIT), portfolio IRR, income yields, PBT and other shareholder return metrics
- Designing the model to input key site data that is output from the separate DevCo business planning model
- Updating the model for the latest actual historic financial data provided by the management accountants and the latest forecast data provided by departmental heads
- Tracking and forecasting tests and conditions that need to be monitored for a REIT, and to calculate forecast profit distributions
- Developing and maintaining model risk documentation.

**REIT Annual business plan and quarterly forecast updates**
- Developing the annual REIT business plan and the forecast updates for the quarterly Board meetings, using the newly developed REIT model
- Collating and challenging assumptions with Directors across the business
- Leading the maintenance and updating of the business planning model to ensure it is accurate and up to date, including latest timings for when fully occupied villages are acquired
- Supporting the preparation of Board papers for the Directors and Shareholders
- Tracking in-year actual financial performance versus the Plan. Work with Finance and Department Heads to understand reasons for key variances and the impact on key financial metrics.

**Valuation modelling**
- Developing detailed understanding of how key income streams such as event fees, rental receipts and zero carbon income are valued
- Developing detailed discounted cash flow based valuation calculations and run sensitivities to assess impact of key assumptions, such as churn rates, market values, house price inflation and discount rate / yield compression
- Helping manage the six-monthly external valuation, taking responsibility for the collation and provision of data for the villages in the REIT, reviewing the output from the external valuers, identifying where assumptions differ and potential implications on the Plan.

**Strategic projects**:

- Providing financial modelling and analytical support for the Real Estate Analysis team on key strategic and investment projects (i.e., debt financing, new investments, transactions, new income streams, sales/rental velocity and long-term estate / asset management forecasting)
- Developing new financial models and tools, agreeing assumptions with project stakeholders, using discounted cash flow analysis to calculate key investment metrics such as IRR, drawing commercial insights from the analysis, drafting Board papers and business cases, and presenting the outputs and key findings to senior stakeholders.

**Key Requirements**:

- Experience working for a similar type of organisation in a financial modelling / data analysis role would be ideal. I.e., a real estate developer, investor, or house builder; or for another industry with capex-based projects for example infrastructure, energy, transport sectors
- Knowledge of and experience in calculating cash-based metrics including IRR, NPV, peak debt and shareholder equity
- Relevant professional qualification (e.g. CFA, qualified accountant) or a degree in a numerical area (such as mathematics, science, engineering, finance, accounting, economics or real estate) combined with relevant experience.

**The Benefits**:

- £60,000 to £70,000 per annum (negotiable depending on experience) + bonus
- 25 days annual leave (plus bank holidays)
- Giving Something Back - 3 additional days leave for charity or voluntary work per year
- Big birthdays off (those ending in a 0)
- Medicash health plan
- Enhanced family benefits and sickness policies
- Private Medical Insurance
- Life Assurance at x4 your annual salary
- 5% matched pension scheme
- Access to SMART tech
- Retail discounts on a variety of outlets
- Cycle to work scheme
- Electric car scheme
- Access to an incredible workspace, with a gym, social areas, and parking.

  • Financial Modeller

    3 months ago

    London, United Kingdom Walters People Full time

    Are you a skilled Financial Modeller with a passion for analysing and understanding the financial impact of projects? Are you looking for an exciting opportunity to work on a wide variety of interesting projects? If so, we have the perfect role for you. My client are a leading consultancy working primarily with public sector clients. They are seeking a...

  • Financial Modeller

    5 days ago

    London, United Kingdom Reed Full time

    Financial Modeller Location: LondonJob Type: Full-time We are seeking an experienced Financial Modeller to join our client who operate within the transport & infrastructure sector. This role is pivotal in supporting internal teams and business development for strategic tenders and M&A projects. The successful candidate will work closely with various...

  • Financial Modeller

    1 month ago

    London, United Kingdom Altum Consulting Full time

    We're partnering with a well-known and very highly regarded international NGO to find a a talented Financial Modeller to help us shape the financial future and ensure maximum impact and sustainability of the programmes.With strong excel skills, you will help to develop a robust long-term planning model that will guide the strategic decision-making processes....

  • Financial Modeller

    1 month ago

    London, Greater London, United Kingdom Zopa Bank Full time

    We started our journey back in 2005, building the first ever peer-to-peer lending company. Fast forward to 2020 and we launched Zopa Bank. A bank that listens to what our customers don't like about finance and does the opposite. We're redefining what it feels like to work in finance. Our vision for a new era of banking puts people front and centre - we've...

  • Financial Modeller

    7 days ago

    London, United Kingdom Cedar Remote Work Freelance Full time

    Cedar is currently partnered with private-equity backed technology and infrastructure business to secure an Interim Financial Modeller. The role is a 3-6 month contract, paying a day rate between £500-700 per day. The Company This rapidly growing private equity-backed infrastructure business based in London, has developed at an enviable pace in recent...

  • Models Mission Control

    5 months ago

    London, United Kingdom Chatham Financial Full time

    **Overview**: Models Mission Control is a sub-team of the larger Models Team. The focus of Models Mission Control is supporting Chatham's ongoing models and valuations services. The team is responsible for supporting ongoing delivery of client valuations and CVAs (credit valuation adjustments), by bringing together a practical knowledge of how our models...

  • Associate - Financial Modelling

    2 weeks ago

    London, United Kingdom ONE SEARCH Full time

    THE CLIENT Our client are a leading boutique who specialise within the Renewable Energies space. They are looking to add a Financial Modelling Associate to their London team. We’re looking for someone with a track record of working with others to deliver complex financial modelling transactions for clients, along with a genuine passion for renewables.THE...

  • Associate - Financial Modelling

    2 weeks ago

    London, United Kingdom ONE SEARCH Full time

    THE CLIENT Our client are a leading boutique who specialise within the Renewable Energies space. They are looking to add a Financial Modelling Associate to their London team. We’re looking for someone with a track record of working with others to deliver complex financial modelling transactions for clients, along with a genuine passion for renewables. ...

  • Associate - Financial Modelling

    4 days ago

    London, United Kingdom ONE SEARCH Full time

    THE CLIENT Our client are a leading boutique who specialise within the Renewable Energies space. They are looking to add a Financial Modelling Associate to their London team. We’re looking for someone with a track record of working with others to deliver complex financial modelling transactions for clients, along with a genuine passion for renewables. ...

  • Excel Financial Modeller

    1 month ago

    London, United Kingdom Henderson Drake Full time

    Henderson Drake is delighted to partner with a dynamic and innovative financial software company at the forefront of financial technology, to find an exceptional Excel Financial Modelling Specialist. This role is perfect for a detail-oriented and analytical professional who thrives in a fast-paced environment. The successful candidate will play a crucial...

  • Excel Financial Modeller

    2 months ago

    London, Greater London, United Kingdom Henderson Drake Full time

    Henderson Drake is delighted to partner with a dynamic and innovative financial software company at the forefront of financial technology, to find an exceptional Excel Financial Modelling Specialist. This role is perfect for a detail-oriented and analytical professional who thrives in a fast-paced environment. The successful candidate will play a crucial...

  • Excel Financial Modeller

    1 month ago

    London, United Kingdom Henderson Drake Full time

    Henderson Drake is delighted to partner with a dynamic and innovative financial software company at the forefront of financial technology, to find an exceptional Excel Financial Modelling Specialist. This role is perfect for a detail-oriented and analytical professional who thrives in a fast-paced environment. The successful candidate will play a crucial...

  • Excel Financial Modeller

    1 month ago

    London,, UK, United Kingdom Henderson Drake Full time

    Henderson Drake is delighted to partner with a dynamic and innovative financial software company at the forefront of financial technology, to find an exceptional Excel Financial Modelling Specialist. This role is perfect for a detail-oriented and analytical professional who thrives in a fast-paced environment. The successful candidate will play a crucial...

  • Financial Analyst

    3 days ago

    London, Greater London, United Kingdom Ameriprise Financial Full time

    About the RoleWe are seeking a highly skilled Financial Analyst to join our team at Ameriprise Financial. As a key member of our Commercial Finance Office, you will play a critical role in supporting our business heads with all commercial finance-related activities.Key ResponsibilitiesFinancial Modeling and Analysis: Develop, enhance, and run...

  • Financial Modelling Manager

    3 days ago

    London, Greater London, United Kingdom Reed Full time

    Job DescriptionWe are seeking an experienced Financial Modelling Manager to support our client's internal teams and business development for strategic tenders and M&A projects.The successful candidate will be instrumental in producing financial models and detailed bottom-up builds of the business, collaborating closely with multiple departments, and...

  • Associate - Financial Modelling

    3 weeks ago

    Greater London, United Kingdom ONE SEARCH Full time

    THE CLIENT Our client are a leading boutique who specialise within the Renewable Energies space. They are looking to add a Financial Modelling Associate to their London team. We’re looking for someone with a track record of working with others to deliver complex financial modelling transactions for clients, along with a genuine passion for renewables.THE...

  • Associate - Financial Modelling

    2 weeks ago

    Greater London, United Kingdom ONE SEARCH Full time

    THE CLIENT Our client are a leading boutique who specialise within the Renewable Energies space. They are looking to add a Financial Modelling Associate to their London team. We’re looking for someone with a track record of working with others to deliver complex financial modelling transactions for clients, along with a genuine passion for renewables.THE...

  • Associate - Financial Modelling

    2 weeks ago

    Greater London, United Kingdom ONE SEARCH Full time

    THE CLIENT Our client are a leading boutique who specialise within the Renewable Energies space. They are looking to add a Financial Modelling Associate to their London team. We’re looking for someone with a track record of working with others to deliver complex financial modelling transactions for clients, along with a genuine passion for renewables.THE...

  • Associate - Financial Modelling

    4 days ago

    Greater London, United Kingdom ONE SEARCH Full time

    THE CLIENT Our client are a leading boutique who specialise within the Renewable Energies space. They are looking to add a Financial Modelling Associate to their London team. We’re looking for someone with a track record of working with others to deliver complex financial modelling transactions for clients, along with a genuine passion for renewables....

  • Associate - Financial Modelling

    2 weeks ago

    London, UK, UK, United Kingdom ONE SEARCH Full time

    THE CLIENT Our client are a leading boutique who specialise within the Renewable Energies space. They are looking to add a Financial Modelling Associate to their London team. We’re looking for someone with a track record of working with others to deliver complex financial modelling transactions for clients, along with a genuine passion for renewables.THE...