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

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?

The Evolution of the Modern Office

Evolution of the modern office How has the modern day office evolved since the 1950's? Looking at the evolution of the modern office from cubicles with typewriters and filo faxes through the age of electronics coming in, the integration of the sexes in the workplace and then today a more flexible approach, hot-desking and virtual … Continue reading The Evolution of the Modern Office

UK Government – planning for the future

Written By Danass Maddison Proposals intended to streamline and modernise the planning process Current system Currently, the government uses the system based on the Town and Country Planning Act 1947. The act calls for local authorities to prepare local plans setting out proposals for the use and development of land within their area, showing an … Continue reading UK Government – planning for the future

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?

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 … 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 … Continue reading Financial metrics commonly used by loan underwriters (part 01)

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 … Continue reading An overview of the “UK-complex-housing-planning-permission-system”

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 … Continue reading London: Density vs. Price, Challenges & Opportunities