CinFM Blog

19th November 2019

Take Care when Using PMT, PPMT and Similar Functions!

Another slightly geeky post from me 😊 about the PMT, PPMT and similar functions. It is very easy to use the functions in ways that can […]
18th October 2019

Circular References versus Continuous Compounding of Interest?

I couldn’t resist this slightly geeky comment about a subject that comes up occasionally and to which I have not seen an answer elsewhere else, namely: […]
12th February 2019

The Role of Risk Modelling and Monte Carlo Simulation in Cash Flow Valuation

Since 1989, I have been using risk modelling combined with Monte Carlo simulation to improve the robustness, transparency and accuracy of cash flow valuation models. This […]
10th February 2019

Six Reasons to Avoid Using VLOOKUP and HLOOKUP Functions

It never ceases to amaze me when I open an Excel worksheet and see VLOOKUP or HLOOKUP functions. These functions should basically never be used! In […]
10th February 2019
To simplify a recent post about the use of the FVSCHEDULE function to return the total and compound average growth rates (or asset returns), this demonstrates […]
9th February 2019

The Meaning and Uses of Monte Carlo Simulation

Monte Carlo Simulation is simply the calculation of a model many times using an automated process that randomly samples the possible values for the model’s inputs. […]
9th February 2019

The FVSCHEDULE Function in Excel

As part of our occasional series on lesser-known Excel functions, this post highlights a key use of the FVSCHEDULE function in financial modelling. The FVSCHEDULE function […]
14th November 2018

The Role of Risk Assessment in Decision Quality

I had the pleasure of attending The Decision Quality Conference 2018 in London last week. This provided a good reminder of some of the close linkages […]
13th November 2018

Are Risk Register Heat Maps a Waste of Time?

Some commentators on risk assessment consider that “heat maps” are a waste of time. This posting discusses some of their advantages and disadvantages. A much more […]