Resources

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.

General NewsHca

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 ...

Excel - TechnicalFinance

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” ...

AuditFile Hash

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 ...

Best PracticeExcel - Technical

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.

General News

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....

Best PracticeExcel - Technical

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 ...

Best PracticeFinance: Excel - Technical

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 ...

FinanceForecasts

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 ...