Blog

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.

dutch cycle

How do the Dutch know how to do this? I learned a joke about developers when I arrived in Holland: ‘

What is the first thing a developer does? He makes the land’. Ha ha.

The Dutch grow up to the national tune, Living with Water, not taking it for granted that our land is permanent and knowing that we are together collectively responsible for its stability. There is also the inbuilt advantage of being brought up on bicycles: as soon as you are old enough to sit up straight at a few months old, you can expect to be riding along on a seat out front on your parent’s bike. Being a very small baby projected into town traffic makes you brave in life. It is hardly surprising that these people grow up to be creative engineers and responsible investors, intuitively understanding environmental protection and not being easily fazed by life. Some of the most innovative, sustainable and thought-provoking investments and construction projects stem from Dutch activities which have served Dutch investment returns well. It is no accident that GRESB, the leading sustainability performance measurement, has its roots in Holland working with that other seat of innovation, California.

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

Financial metrics commonly used by loan underwriters (part 02)

By Victor Alarsa

If you are looking to get into Real Estate financier, here you will find a few metrics commonly used by loan underwriters.

As discussed in part 01, covenants are financial metrics used by lenders to determine how risky lending capital might be for a given project. We learnt about LTV/LTGDV/LTC, and now we are going to find out a bit more about two other important ratios: DSCR and ICR.

DSCR (Debt Service Coverage Ratio)

In short, DSCR is the ratio between cash available and cash required for debt servicing. In other words, it is the ratio of the right amount of cash to repay the debt.

Commercial lenders use the DSCR to assess how large a commercial loan can be supported by the cash flow generated by the asset.

Continue reading Financial metrics commonly used by loan underwriters (part 02)

Financial metrics commonly used by loan underwriters (part 01)

By Victor Alarsa

If you are looking to get into Real Estate financier or just being more familiarised with its vocabulary, here you will find a few metrics commonly used by loan underwriters.

The daily life of a developer is not easy. They need lenders to help them to finance their developments, but lenders do not lend money without a thorough due diligence on the investment, starting with the covenants. Covenants imposes a limit on the amount of money a financier can lend to a development. In this article and the next, we are going to run through the most common covenant metrics used by loan underwriters.

Continue reading Financial metrics commonly used by loan underwriters (part 01)

Is England’s planning system in the wrong direction?

By Victor Alarsa

From a developer perspective, sometimes the UK planning system can be quite intricate and vague. One of the reasons is due to its uncertainty at the initial stage.

Before starting a site negotiation with the landowner, the developer needs to calculate the residual land value. However, to appraise the prospective development, the developer needs to know precisely the maximum number of unities, max stories height, and all other building metrics. That is only possible if the developer officially consults the local planning authority (pre-application), which is going to charge for the information (ranging from a few dozens to thousands of pounds).

That is a dilemma: the developer needs to decide whether it is worth to pay a pre-application fee for each and every new deal to verify the residual land value.

Continue reading Is England’s planning system in the wrong direction?

An overview of the “UK-complex-housing-planning-permission-system”

By Victor Alarsa

Who’s responsible for granting planning permissions?

The planning system is designed to be applied by local authorities. There are three layers of authorities:

  • Nationally (national plan)
  • County councils (regional plan)
  • Unitary authorities such as districts, boroughs or city councils, hereafter referred as to Local Planning Authority (LPA)

LPA is ultimately responsible for designing local plans and granting planning permission.

Continue reading An overview of the “UK-complex-housing-planning-permission-system”

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 cells meeting only one condition and a single range, whereas COUNTIFS accepts several criteria.

The formula is comprised of ( criteria range 1, criteria 1 ), this is the required argument. In case you want to add new criteria, just add after the first two arguments

E.g. ( criteria range 1, criteria 1, criteria range 2, criteria 2).

You could add as many criteria as you want. The criteria range accounts for the array you want to count (highlighting them), and the criteria are the condition to be tested against those values.

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

The UK Private Rented Sector (PRS) perspectives and Build to Rent (B2R) opportunities

By Victor Alarsa

The PRS is the fastest-growing sector in the UK properties market. It is England’s second-largest housing tenure after owner occupied, 62% against 20%, as shown below:

Image 1

Source: Alex Bate, Building the new private rented sector: issues and prospects (England), 2017

Continue reading The UK Private Rented Sector (PRS) perspectives and Build to Rent (B2R) opportunities

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 of a property with different floor sizes and rents per square foot, then you simply need to multiply each floor size by its corresponding rent and sum up everything in the end.

Continue reading The benefits of SUMPRODUCT?

London: Density vs. Price, Challenges & Opportunities

By Victor Alarsa (valarsa@cambridgerefinance.com)
& Maria Wiedner (mwiedner@cambridgerefinance.com)

We are living in the age of the City. Larger and denser cities are likelier to be more innovative and generate more wealth. For instance, as the population of a city increases by 100%, its residents get 115% more innovative, productive and hence 15% wealthier1. This attracts more people, which, in turn, makes the city larger, denser, more innovative, wealthier. This cycle continues up until a point when pollution, house unaffordability, traffic and crime outweigh the benefits of agglomeration, i.e. when a city becomes too large for its own sake.

Density in general is massively beneficial, for example in 2015, London represented 14% of the UK population but was responsible for 23% of its GDP. However, the virtuous cycle of agglomeration needs to be accompanied by a housing expansion, which many cities struggle with. In London, finding housing accommodation is a challenge; land is scarce and restrictions in planning permission deter new constructions. Demand, on the other hand, is further growing as people want to move to London where jobs are available and the clustering of people has made public goods such as entertainment, health and transport more accessible.

Continue reading London: Density vs. Price, Challenges & Opportunities

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.

  1. Don’t hard code values, instead use input tables
  2. Don’t use CTRL + Shift + Enter command
  3. Use intermediate calculations to help simplify your formulas
  4. Don’t use more than 4 (four) “IF” functions per formula
  5. Use data validation
  6. Build error checks
  7. Create one formula per row (or column)
  8. Protect your workbook
  9. Avoid circular references
  10. Keep it simple and elegant

Continue reading Top 10 ‘Golden Rules’ of Financial Modelling in Excel