Corporate
Financial Modelling
We build best practice financial models using Excel
Remote FP&A Consulting Services
We are still holding off scheduling any training workshops in the near future.
What this means is that we now have additional capacity to take on more consulting and development work. A large proportion of our work is traditionally carried out off site, so we are experienced in using remote technology such as Zoom or Skype.
We also have robust security procedures.
Contact Us
today for a confidential and obligation free conversation.
Our London consultancy specialises in the development of corporate financial models in Excel.
We appreciate each business is unique and therefore each model we build is bespoke, drawing on previous experience rather than adapting a template to suit.
We work with both SME's and FTSE listed businesses and are available for any size of project.
Some examples of models we can build are: Project Finance Financial Models, Long Range Plan Financial Models, DCF Capital Investment Financial Models, Budget Financial Models, Property Financial Models, M&A Financial Models, KPI Financial Models, Consolidation Financial Models
and LBO Financial Models.
We have over 20 years real world experience and have planned and developed models across a wide range of industries including: Renewable Energy, Entertainment, Retail, Banking, Healthcare, Information Technology, Insurance, Private Equity and Transport.
We provide a quality real world modelling solution. There is no charge for our initial meetings and preparation of our proposal. Once we understand the scope of the project, we can provide a fixed cost estimate if required. Our rates
are very competitive and excellent value.
All our models are built using industry best practice. We are a signatory to the ICAEW financial modelling code. Due to the commercially sensitive nature of our work, we follow robust
data security procedures.
Our Articles
Scenario Analysis
There are a number of approaches to creating scenario analysis in Excel to anticipate a range of potential economic impacts.
• Use the Scenario Manager tool that comes with Excel.
• Manually change an input value and record the results.
• Copy the model several times and save a new version each time.
• Create multiple input sheets within the model.
• Use Excel Data Tables.
Each approach has its advantages and disadvantages
Click
to read the full article
Spill Error - Why doesn’t my Index Match work in Excel 365.
This something we are starting to see as we work across a number of different versions of Excel.
Recently, Microsoft rolled out something called dynamic array formulas in Excel 365, which is a substantial change from previous versions. Dynamic array formulas automatically spill in to neighbouring blank cells.
In general, the @ character should overcome the compatibility issues with models build in other versions to work in Excel 365.
Click
to read the full article
CITY FINANCIAL MODELS LTD
We plan, build and test bespoke Excel financial models and provide Excel and financial modelling training.
Get in touch today
to see how we can help your organisation train and develop robust best practice financial models
