Financial Modelling Manager

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 Modelling Manager 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) for the Real Estate Investment Trust (REIT)
• Using the model to forecast the cash funding requirements as fully occupied villages are acquired by the 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 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
• Exceptional Microsoft Excel financial modelling skills. Ability to develop complex financial models with prior experience of having built or worked with 3-way financial statement models and discounted cash flow valuation calculations, and to apply best practice financial modelling principles.
• 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:

• £75,000 to £85,000 per annum + up to 20% 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. 

More enjoyment. More satisfaction. More like one big family. If you’re looking for a career that means more and gives you more, hit that apply button!