What does a financial analyst do?

There are several types of financial analysts, one size does not fit all! The day-to-day tasks of financial analysts may differ greatly, however, the skills these professionals need are often very similar. Here are four examples of financial analysts: Portfolio managers A portfolio manager is responsible for the supervision and the necessary support of a … Continue reading What does a financial analyst do?

Why has the government encouraged training whilst on furlough?

The government rules for staff whilst on furlough have been strict, and incorporate the following: You cannot ask staff to do any work that makes money for your business or any business linked to yours, orprovide any service for your business or linked to your business However, your staff can: Take part in trainingvolunteer for … Continue reading Why has the government encouraged training whilst on furlough?

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?