CinFM Blog

14th April 2020

Why Making Good Decisions is Hard

It is worth recapping why the making of good decisions is hard. In the following, I have brought together ideas from various sources and documents and […]
10th April 2020

Using Optimisation to Calibrate Models: COVID-19 Example

The COVID-19 outbreak provides a reminder of possible uses of optimisation tools for model calibration. Recall that where the values of a model input(s) are not […]
8th April 2020

Interest Rate in the PMT and Similar Functions

I have previously posted about the need to be very careful when using the PMT and similar functions, as mistakes can easily arise. One area of […]
30th March 2020

When is a Model not a Model?

Many Excel worksheets are described as “models”. Sometimes (more often than not), the calculations are very hard to follow for someone who did not built the […]
28th March 2020

Major Update of Website for the Certificate in Financial Modelling and Data Analysis

We have now nearly finished the web-site for the Certificate in Financial Modelling and Data Analysis. It has been quite a slow process, bring together the […]
2nd December 2019

What Are Real Options and Why are They Hard to Value?

The term “Real Option” refers to an additional decision possibility that is created in any real-life situation if one extends the scope of permitted decision alternatives. […]
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: […]