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?