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?
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:
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
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?
By Victor Alarsa (email@example.com)
& Maria Wiedner (firstname.lastname@example.org)
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
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 formulas
- Don’t use more than 4 (four) “IF” functions per formula
- Use data validation
- Build error checks
- Create one formula per row (or column)
- Protect your workbook
- Avoid circular references
- Keep it simple and elegant
Continue reading Top 10 ‘Golden Rules’ of Financial Modelling in Excel
By Cleo Folkes
As House of Fraser announced the closure of 31 stores earlier this month and Debenhams issued their third profit warnings in the year today, we hear that landlords worry about covenant strength. What is it exactly that they worry about?
In property you often hear the word covenant strength when people talk about a tenant or the quality of an investment property or real estate loan. When you Google the definition for covenant it will tell you it is “an agreement” or something you “agree by lease, deed, or other legal contract”. Thus, when people talk about covenant strength, they are talking about how secure the income is coming from a lease with a tenant. Continue reading What is covenant strength and why does it matter?
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. Continue reading What is the relationship between yields, risk, rents and price/value in property?
The Royal Institution of Chartered Surveyors (RICS) is delighted to announce a collaboration with Cambridge Finance to develop a comprehensive training course that will help bridging the gap between real estate and finance education.
The growing sophistication of the property and financial markets has meant that investment surveyors have not only been requested to advise on property location, covenants and physical structure of buildings, but also on debt, Continue reading RICS and Cambridge Finance collaborate to bridge the skills gap between real estate and finance
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.
Continue reading Demystifying real estate financial models
First, we need to understand what a financial modelling is so we can keep this in mind throughout the test and better accept why companies are asking us more and more to go through Excel tests in order to proceed to the next round of interviews.
Financial Modelling in real estate is used as a decision making tool for investment purposes. Companies use financial models to forecast the future of a real estate asset or portfolio with several assets, including partially owned assets such as the case of joint-ventures. Continue reading How to prepare for a real estate financial modelling test