News
Our solutions are effective and simple to use. Have a look through our wealth of modelling-related white papers, videos, brochures, articles and tips & tricks, curated for you.
  • All
  • Blog
  • Business Modelling
  • General News
  • Model Risk Management
  • News
  • Uncategorized
All
  • All
  • Blog
  • Business Modelling
  • General News
  • Model Risk Management
  • News
  • Uncategorized

Light relief from the Brexit Debate

A maths problem (which, apparently, most people get wrong) caused merriment here at Numeritas and we can draw some parallels with the Brexit debate, so we thought we’d share them for your enjoyment.

Read On

New regulatory framework for social housing

The Homes and Communities Agency (HCA), the UK regulator of social housing introduced new regulations that took effect on 1 April 2015. Providers of social housing will now be required to maintain a register of assets and liabilities and to subject their business plans to rigorous stress testing.

Read On

Do you really need to model VAT

For many businesses, VAT (“Value Added Tax” ie sales tax) is a tax that has little effect on profits. “Now that’s my kind of tax” I hear you say – a tax that doesn’t affect profits might sound like nothing to worry about, but that’s not the whole story.

Read On

Using file hashes to prove two models are the same

In the past, when signing off on the review of a model, the sign-off letter would make reference to the file name of the model and the last modified date of that file as a way of identifying which file the review was performed on. This has never really been a good way of identifying a specific version of a specific file and recently we’ve been using file hashes to identify files instead.

Read On

To rebuild or not to rebuild that is the question

If Hamlet were around today, looking at his tired spreadsheet, surely he would be asking himself this question; it comes up time and again.

Read On

Top tips for linking workbooks

Linking workbook files together can be risky, but the question of how to link files comes up frequently. How can you minimise the risk?

Read On

The ‘dark art of R1C1 notation

Most people who use Excel are familiar with the default A1 style of referencing, but there is another way – the dark art of R1C1….

Read On

Bringing Excel charts or data tables into Powerpoint or Word using Office 2010

Having built your flexible and robust model in excel, based on Numeritas’ financial modelling SCILS no doubt, you will be eager to share the key insights which you have gained from the process.

Read On

Problems with the IRR in Excel

Many organisations rely on the IRR as a measure of the success of a project. There are, however, some technical issues with using the IRR function in Excel, as well as some general issues that the user should be aware of.

Read On

Model Structure – Periodicity

This (potentially made-up) word refers to the length of the time periods in a financial forecasting model. Forecasts will be divided into time slices eg months, years or quarters.

Read On

Cheaper model reviews

The way you build your spreadsheet model can dramatically affect the time and cost of having it reviewed – read on to find out how:

Read On

Should my forecast include inflation

When looking to the future, we don’t know what the inflation rate will be, but isn’t it reasonable to think interest rates will move in line with inflation? So if inflation and interest are going to move more or less together, why not build all our forecasts in real terms?

Read On