Coronavirus has had a marked affect on how people want to spend their work and leisure time and has shifted priorities for building design. Gardens, recently seen as a nuisance and best avoided by some, are now sought after for the offer of private open air space and open plan is falling in popularity as … Continue reading How has Covid shaped property design?
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?
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?
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)
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)