Financial Modelling – What, Why & How?

At Cambridge Finance we train professionals in the construction, development and analysis of financial models. We believe this is a hugely valuable skill in real estate and the financial industries. Why? Please read further. What? Before delving into why we need financial modelling, let us first look at a definition. A financial model is a tool (typically … Continue reading Financial Modelling – What, Why & How?

Valuation in crisis – Art versus Science – The Science View

The Science View on Valuation Estimating Property Values in Times of Significant Uncertainty In times of Covid-19 pandemic, property market or fair values are harder than ever to estimate. Valuers desperately trying to find enough ‘evidence’, but property is an illiquid asset by definition and as such, transactional evidence disappears during periods of market unrest. … Continue reading Valuation in crisis – Art versus Science – The Science View

Valuation in crisis– Art versus Science – The Art View

The Art View on Valuation The life of a valuer is pretty tough at the best of times, even with the benefit of good comparable evidence. This is because valuers are carrying out transaction analysis in the most imperfect market that exists. This is why valuation is often described as both an art and a … Continue reading Valuation in crisis– Art versus Science – The Art View

Will Green Credentials Impact Property Values – Let’s Go Dutch

By Morag Beers Going Dutch does not always have particularly positive connotations; but Going Dutch in green investments is a whole other matter. The Dutch do it well, and the results are increasingly being recognised as beneficial. How do the Dutch know how to do this? I learned a joke about developers when I arrived … Continue reading Will Green Credentials Impact Property Values – Let’s Go Dutch

Demystifying real estate financial models

Real Estate financial models are mainly spreadsheets used extensively as an aid in decision support in the areas of property investment and lending. These spreadsheets will ascertain the present value of a stream of cash flows and generate risk / return ratios. How do I create a real estate financial model? Being proficient in real … Continue reading Demystifying real estate financial models

5 Things Highly Productive Financial Analysts Do Differently

Being a highly productive financial analyst is not an innate talent; it’s simply a matter of organising your spreadsheets so that you can efficiently get the right calculations and analysis done. Real estate financial analysts in particular... So, what behaviours define highly productive financial analysts?  What habits and strategies make them consistently more productive than others?  And … Continue reading 5 Things Highly Productive Financial Analysts Do Differently

What is the relationship between yields, risk, rents and price/value in property?

Yields have many different meanings in finance - yield to maturity, running yield, dividend yield, interest yield - and in property finance, the case is very similar. We can talk about initial yield, equivalent yield, reversionary yield etc. It is, therefore, really easy to get lost in a “yield” conversation, unless you stop the other person and ask: “which yield?!”

If you are emotionally intelligent enough (and I bet you are if you are reading this!), you won’t do this so blatantly. So, let’s break down this “yield” conversation first to ascertain the relationship between yields, risk etc.

First, it is safe to assume that “yield” refers to initial yield...

The benefits of SUMPRODUCT?

By Victor Alarsa If you are one of those who loves to model using lots of “IF”, “AND” and “OR” functions, then this article is for you. Let’s discuss the SUMPRODUCT, which literally means summing up the multiplication (product) of two or more different arrays. For example, if you want to calculate total rental value … Continue reading The benefits of SUMPRODUCT?

Top 10 ‘Golden Rules’ of Financial Modelling in Excel

In our financial modelling courses, we discuss what makes a great financial model in Excel and here are the top 10 ‘Golden Rules’ that I find will help you to achieve that. Don’t hard code values, instead use input tables Don’t use CTRL + Shift + Enter command Use intermediate calculations to help simplify your … Continue reading Top 10 ‘Golden Rules’ of Financial Modelling in Excel

Do you know how to count the number of cells filtering several different criteria using Excel?

By Victor Alarsa In essence, the COUNTIFS function is used to count the number of cells that meet one or multiple criteria, given a specific range of the array. You may have noticed that COUNTIFS has an "S" in the end, which differs from its cousin COUNTIF, which is programmed to count the number of … Continue reading Do you know how to count the number of cells filtering several different criteria using Excel?