Second Period

Alec J. Pacella

Last month, we went back to school and discussed some useful financial calculations incorporated within Microsoft Excel formulas. This month, we are going to continue the school day and, along the way, weave in the theme of renovation being covered throughout this issue of Properties. Both fit perfectly for me; I teach a course at the University of Denver and just finished writing a question for the midterm exam, as follows:

An investor is contemplating installing an automated ticketing system in their parking garage. If continued to be operated with a manned attendant, the garage is expected to produce $100,000 next year and anticipated to grow $2,500 annually in subsequent years as a result of planned increases in the parking rate. The reversion value at the end of five years is expected to be $1,200,000.

The automated system is anticipated to cost $250,000 but income will increase to $125,000 in the first year, as a result of no longer needing an attendant and thus realizing lower expenses. Annual increases are projected to remain the same, $2,500 per year, and the reversion value at the end of five years is expected to be $1,500,000, based on the higher income level.

Using a discount rate of 10%, which alternative should the investor choose?

This is a classic renovation analysis – should the investor keep on keeping on, as-is, and not incur the upfront expense which will result in lower annual cash flows and lower reversion. Or should the renovation be completed, which will result in a significant upfront expense but higher annual cash flow and higher reversion. Who’s ready to go back to school?

We are going to use a three-step approach to solve this problem, dragging in our old friend the CCIM T-bar to help. The first step is to model the cash flows associated with doing nothing. The present value (PV) component would be zero, as no initial money is being spent. The payment (PMT) component would start at $100,000 in the first year and increase $2,500 each subsequent year of the holding period. And the future value (FV) would be $1,200,000. Figure 1 represents the T-bar for these cash flows. The second step is to model the cash flows associated with making the renovation. The PV component would be ($250,000), reflecting the cost of installing the automation system. The PMT component would start at $125,000 in the first year and increase $2,500 each subsequent year of the holding period.

And the FV would be $1,500,000, which is the anticipated value of the garage at the end of the holding period. Figure 2 represents the T-bar for these cash flows.

The third step is to calculate the net present value (NPV) of each T-bar, using the 10% target rate. You’ll need a financial calculator to perform this function (unless you were paying attention to last month’s column). Once completed, you will discover the “as-is” scenario has a NPV of $1,141,339 while the “renovate” scenario has a NPV of $1,172,385. At this point, the decision is simple; based on the assumptions provided, it is worth it to pursue the renovation.

We are not done yet – the university students also have a related bonus question, so why shouldn’t you? We can take this analysis one step further by using a concept known as “IRR of the differential.” Calculating it is straightforward and is the IRR of the difference between the renovated series of cash flows less the as-is series of cash flows. As you can see in Figure 3, the PV of ($250,000) is found by subtracting the PV of the renovated T-bar (Figure 2) minus the as-is T-bar (Figure 1). The PMT in year one in Figure 3 is found by subtracting the year one PMT of the renovated T-bar minus the as-is T-bar. Lather, rinse, repeat for the cash flows in years two through five and the reversions. Plug these into a financial calculator (unless, again, you were paying attention to last month’s column) and we come up with an IRR of the differential of 13.08%.

But the bonus question on this insidious mid-term exam doesn’t ask for the IRR of the differential. C’mon, these are graduate students! It asks what this concept means – because to me, this is the most important number on the board. And I’ll save you the grief. From a purely mathematical perspective, 13.08% is the exact rate at which the NPV of the as-is scenario and the NPV of the renovate $1,500,000, which is the anticipated value of the garage at the end of the holding period. Figure 2 represents the T-bar for these cash flows.

scenario are equal. You are welcome to try it but, trust me, you will come up with an NPV of $1,015,465-ish for either scenario if you use a discount rate of 13.08%. But mathematics doesn’t pay the bills, understanding the practical application is what’s important. The 13.08% discount rate is considered the point of indifference or cross-over point. At that exact rate, there is no difference between the as-is and the renovate scenario. They are equivalent decisions. But at any rate less than 13.08%, the decision swings to the renovate scenario and the lower the rate, the more pronounced the renovate decision becomes. Conversely, at any discount rate greater than 13.08%, the decision swings to the as-is scenario and the higher the rate, the more pronounced the as-is decision becomes.

Gang, our business is all about under- standing and quantifying risk, and the concept of IRR of the differential is a hallmark example. The break-even risk versus return for this proposed renovation is 13.08%. If you believe the risk associated with this proposed renovation demands a return greater than this point of indifference, you are better off to not spend the money and keep on keeping on. But if you perceive a low degree of risk associated with the renovation, and are good earning a return at some rate less than this break-even rate, you are better off to spend the money. And if you liked second period, just wait to see what we have in store for third period!

by Alec Pacella for Properties Magazine, November 2022

Advertisement

What’s happening in… Hamilton, NZ?

New Zealand’s city of Hamilton – or Kirikiriroa in Maori – sits on the banks of the famous Waikato River which features heavily in its sights and site. In this city known for its beautiful greenery and walks, the most popular tourist attraction is the 54-hectare Hamilton Gardens.

With a population of just under 200,000 people, Hamilton is the fourth most populous city in the country. In 2020, it was named ‘most beautiful large city in New Zealand’. The wider Hamilton Urban Area includes Ngāruawāhia, Te Awamutu, and Cambridge, which collectively cover some 110 square kilometers of land. It is also the third fastest-growing urban area.

Leading industries and outputs

Hamilton’s economic heritage is as an agricultural services hub, particularly dairy cattle, and vegetable farming, but it also has thriving business services, construction, and health and community services. Additionally, R&D is an emerging sphere, given the city’s high tertiary educated population.

Residential market factors

New Zealand has typically seen high demand and low supply for residential housing in recent years which has kept prices elevated. There are, however, some movements in the markets, and new regulations around lending coming into play that could mean fewer residential buyers would qualify and those that do could be in for “bargains” in 2022 – according to a January 2022 report from Stuff.co.nz citing Mortgage Lab chief executive Rupert Gough.

Additionally, Realestate.co.nz recently reported new house listings in November 2021 were hitting their highest level in seven years, and Stuff.co.nz added that data from Infometric showing consent and permissions for new build projects were also much increased, compared year on year.

The latest CoreLogic Home Price Index (HPI) report shows that property values have declined in Hamilton, where housing values were down 0.9% in March.

Commercial property outlook

New property rating valuations from Hamilton City Council – released in April 2022 – put the city’s worth at NZ$ 71.4 billion.

Our Hamilton reports that the city’s “total property Capital Value (the total value of the land and any buildings on it) increased 53%, and Land Value 67% since 2018”. “On average,” the article continues, ‘Capital Values for commercial and industrial property have increased by 40% across the city”.

Insight from NAI Harcourts in the country suggests that industrial will remain “the darling of the three commercial property sectors”, but also that there is momentum in the Hamilton office market, which they characterized as coming from a “flight to quality” that was pushing local business in the central business districts to up their game.For more regional insight, contact NAI Global’s partners in Hamilton and surrounds.

Report says CRE leaders expect post covid resurgence

In May, law firm DLA Piper released the 2022 edition of their Annual State of the Market Survey report, highlighting that “optimism about the future of commercial real estate (CRE)” remains strong despite the headwinds the industry faces.

The survey on which the report is built was conducted in February and March of 2022, by collating and analyzing input from CRE leaders and professionals in the US – specifically their take on matters including “pandemic recovery, economic outlook, attractiveness of investment markets and overall expectations over the next 12 months”. This input is further contextualized with additional research, presented the report.

Highlights

Overall, the report [PDF] shows “increased bullishness”, with “more respondents in 2022 [having] a higher level of confidence for the real estate industry’s next 12 months”.

Findings from the report also include that 73 percent of respondents are “expecting a bullish market”. This is consistent with 2021 expectations. “However,” they added, “this year, respondents reported feeling a higher level of confidence in a bull market over the next 12 months; 33 percent described their bullishness as an 8 or higher in 2022, compared to just 16 percent in 2021.”

Top contributing reasons include the apparent availability of capital in the market, with over half of the respondents citing this as the main source of their confidence.

Viewed per sector, Commercial Property Executive says in their analysis of the report, “Industrial (66 percent) and multifamily (57 percent) remain the property types that investors believe offer the best risk-adjusted returns over the next 12 months.”

Shaping CRE

Inflation and interest rate changes were ranked most likely to have an impact specifically in the CRE market in the coming year, but ecommerce, migration of workers out of city centers, and the “redesign/reimagining use of office and other commercial spaces” were also common responses.

Concerns remain

Top concerns included interest rate increases (cited by 26 percent of respondents), inflation (18 percent), as well as the Russian invasion of Ukraine.

US gains and advice

Finally, respondents to the survey said they felt the US would be seen as a safe and stable option, attracting non-US investment. “During times of uncertainty – like the pandemic or the conflict in Ukraine — investors often flock to safe havens,” the report reads, adding “a well-defined legal system, transparency and proven economic resiliency” are among the US’s assets.  

In the face of global uncertainty though, the report authors caution that CRE professionals and firms must “remain agile and prioritize adaption, with an eye towards staying ahead of the curve”.

SOCIAL: Do you see the US CRE market as a safe haven in times of global uncertainty? How do you expect inflation to make itself known in your CRE specialty?

Market analysis: NYC counts the costs of Covid

New York City (NYC) is virtually synonymous with commercial real estate. It’s a mega sector there, with legendary dealmakers and eye-watering costs. With an incredibly dense population and as a home to a huge number of global headquarters, the city was not only hit hard by the Covid-19 pandemic, but also responded with some of the strongest mitigation tactics seen stateside and in the world. A report from the New York State Comptroller Thomas DiNapoli (published late 2021) now shows the true costs of Covid on NYC’s iconic commercial real estate (CRE).

Setting the scene

In 2019, reads the report, the office sector in NYC employed 1.6 million people, or a third of all city jobs. In the preceding decade, office market property values and billable values (on which property taxes are levied) had “more than doubled”. Off this incredibly strong base, employment in the office sector shrunk by 5.7% in 2020 – certainly a blow, but less than the 11.1% drop in total employment.

The gap here lies in remote work as a mitigation strategy, but that resulted in reduced office space demand. “Asking rents are down 4.2% in the second quarter of 2021, while vacancy rates are at 18.3%, a level not seen in over 30 years in New York City,” according to the report.

Market values down

The result is a steep drop in the full market value of office buildings (463 million square feet of inventory), which fell $28.6 billion citywide – based on the 2022 financial year (FY) final assessment roll. This is the first decline in total office property market values since FY 2000.

In turn, Market Watch’s analysis says, the declines “cost more than $850 million in property taxes in the city’s fiscal 2022 budget.

Charting the return

What the ledger numbers don’t indicate, though, is “what next?”. Partnership for New York says that while the labor market recovery “remains sluggish”, NYC saw “strong income and sales tax revenues and pandemic-era highs in hotel occupancy and transit ridership” during Q3 2021.

The New York City Recovery Index – a joint project of Investopedia and NY1 – puts the state of the city’s recovery at a score of 85 out of 100, or “over four-fifths of the way back to early March 2020 levels”.

The CRE shakeup has also led to some much needed strategic thought and speculation about the future for NYC, including suggestions that empty office space be converted to residential to address the city’s need for affordable housing.

Work smarter not harder: The impact of blockchain on CRE

So far in this blog series, we’ve looked at some of the most cutting-edge emerging technologies: The Internet of Things (IoT), robotics, and virtual reality. We’ve discussed the potential these developments have to revolutionize the way we do business and work in the real estate space. 

While each of those has its applications, none hold quite the same promise for changing the fundamental aspects of how we make, and document, commercial real estate (CRE) deals as blockchain. In this fourth entry in the emerging tech series, we have a look at the implications of this pivotal technology.

Blockchain basics

Nowadays, blockchain is a term everyone’s hearing with increasing regularity. To start, it’s worth having a brief recap of exactly what the tech is. At its simplest, a blockchain is a ledger – a record of information. Not all that different from the databases you’re already using to record details of properties, clients, or transactions. 

The feature that makes blockchain unique is the way that information is recorded. Each “block” can hold a certain amount of data. Once a block is full, a new block is started and the previous block forms part of an immutable chain – essentially a timeline extending outwards from the first block to the current one. 

Information on the blockchain is public and distributed across a network of computer systems – meaning that it’s very, very difficult for one person to hack or alter the information stored in the chain. 

Streamlined data

The opportunity blockchain presents for the CRE space, is the ability to streamline a lot of time-consuming tasks. Imagine having all of the paperwork for a given property digitized, accessible to everyone involved in the deal, and confirmed as accurate by multiple parties. 

Steve Weikal, MIT’s Head of Industry Relations at the Center for Real Estate, describes it like this:

“There are two areas where I think the blockchain is. There’s going to be the intersection with legal tech, so that’s land registry and recording and ownership, and all of that paperwork that exists in the system… the other is the intersection with fintech.”

Of course, an issue that comes up here is how this system can be used with potentially sensitive information – client details that shouldn’t be a matter of public record. For business networks, private blockchains can be set up to only allow access to specified parties. In this case, the identity of participants is verified in the network as well, unlike public blockchain where users can remain anonymous. Private blockchains function more like a traditional database in this sense, trading off some of the immutability of their data for privileged access. 

Sealing the smart deal

Maybe the most promising application of blockchain for CRE deals is being able to deploy “Smart Contracts” for things like tenancy agreements. Smart contracts hard code the details of an agreement on the blockchain, and are uniquely suited to real estate deals, because they can handle conditional clauses. 

As an example, startups like UK-based Midasium are already providing a prototype platform that replaces traditional landlord-tenant agreements. Using smart tenancy contracts, clauses of the agreement are automatically enforced when certain conditions are met. This can include paying rent, returning a security deposit, and directly deducting maintenance costs from the rental amount paid across to the landlord. 

It’s a system designed for transparency and rapid settlement, and the concept is gaining traction in other parts of the world. An added bonus of using smart contracts for tenancy is the possibility of building up a database of real-time data for rental prices and trends in the rental market.

A growing sector

Overall, enterprise reliance on blockchain is set for rapid acceleration. Forbes, quoting an International Data Corporation (IDC) report notes that:

“Investment in blockchain technology by businesses is forecast to reach almost $16 billion by 2023. By comparison, spending was said to be around $2.7 billion in 2019, and we will see this acceleration ramping up over the coming year.”

Blockchain adoption in CRE, however, is still in the early stages. The tech still needs to overcome a few growing pains – in terms of privacy concerns, operational complexity, and a lack of standardized processes – before we’ll necessarily see it forming the backbone of CRE transactions.

That said, it’s a space well worth keeping an eye on. There’s been growing interest, for example, in CRE tokenization –  splitting the value of a given asset into separately buyable blockchain-based tokens. What this means in practice is that instead of looking for one buyer for an expensive asset the value gets subdivided and opened to a much broader market. Which in turn may actually boost the value of the underlying asset.

There’s a lot of potential and little doubt that blockchain will make its way into CRE one way or another. But, like many things in the cryptocurrency and blockchain space, the real challenge will be separating the wheat from the chaff, the fact from the hype, and identifying functional applications of the tech rather than purely fanciful ones.