A recent report from the Federal Deposit Insurance Corporation (FDIC) states that Commercial Real Estate (CRE) lenders are about to come under greater scrutiny. In the report, titled “Supervisory Insights Summer 2022”, the agency adds that there will be an increased focus on new lending activity, along with CRE sectors and geographic areas that are “under stress.”
This comes on the back of a record year, with “the volume of CRE loans held by banks recently peaking at more than USD2.7 trillion.” And while FDIC doesn’t oversee all these institutes, banks supervised by the FDIC account for around USD1.1 trillion of that amount.
The agency adds that there will be increased emphasis on transaction testing (i.e. sampling individual lending transactions), saying:
“Given the uncertain long-term impacts of changes in work and commerce in the wake of the pandemic, the effects of rising interest rates, inflationary pressures, and supply chain issues, examiners will be increasing their focus on CRE transaction testing in the upcoming examination cycle.”
Areas of concern
During 2021, FDIC examiners noted some specific CRE loan concerns, including poor risk analyses and improper assessments of whether loans could be successfully repaid. For example, some assessments failed to check whether a borrower’s business would be able to repay the loan when stimulus or other relief funds were no longer in the balance sheet.
Another area where some banks seemed to fall flat was in conducting a thorough and up-to-date analysis of prevailing market conditions. The agency added that examiners also saw cases where banks have “applied segmentation techniques ineffectively” or “have not drawn conclusions from the analyses performed.”
CRE lending outlook
Specific sectors identified as challenging for valuation in 2021 included some hospitality properties, offices, and malls, along with “some geographies, such as the Manhattan borough of New York City, [which] lagged.” In a Bloomberg article on the report, Brandywine Global portfolio manager, Tracy Chen added that “there are some challenges in pockets of CRE debt, such as offices and retails.”
In an environment where some banks have already announced cutbacks on CRE lending, the additional scrutiny may mean those lenders adopt an even more cautious disposition, especially for sectors they consider “high risk.”
Have there been any effects from changing lending policies on deal-making in your area?
Few innovations have had more of an impact on investment analysis than spreadsheet software. Dominated by Microsoft Excel for the last 25 years, this sector is currently used by an estimated 78% of U.S. businesses. While most know how to quickly copy, sum, drag and format, fewer may know about the real power of this software – a whole host of integrated functions and formulas.
I ran into a long-time reader a few weeks ago, who remarked on covering some ‘soft content’ during recent columns. As a result, this month we are going back to school to discuss some useful but perhaps little-known functions to help get your Excel game in gear.
Present value is a foundational concept and represents a value today for a series of cash flows to be received in the future at a specific discount rate. This concept has tremendous value to a real estate investor, as it allows us to determine what this series of cash flows is worth today. The formula is =PV(discount rate, time periods, periodic payments, future value).
Future value is also useful and is the exact opposite of present value. It rep- resents that value at some point in the future of a present lump sum value and/or a series of periodic payments, collectively compounded at a given compounding rate to a specific point in the future. The formula is =FV(compounding rate, time periods, periodic payment, present value).
We have discussed the concept of net present value several times over the years in these very pages. A kissing cousin to IRR, this concept adds a slight twist by discounting all future cash flows back at a target discount rate and nets the sum against the initial investment. The initial investment can be entered as zero, which makes this formula a very common way to determine the current value of an investment at a given discount rate. The formula is =NPV(target discount rate, series of periodic cash flows).
The addition of the ‘x’ allows for more specific control over the timing of cash flows. While NPV considers annual periodic cash flows, XNPV can distinguish between monthly, quarterly, semi-annual or annual periods, all within the same range of cash flows. The formula is =XNPV(target discount rate, series of periodic cash flows, range of associated dates).
Enter NPV’s kissing cousin. Most of us think of IRR as the rate of return that each dollar earns in an investment while it’s invested. But there is an alternative definition – IRR determines the exact rate at which all future cash flows dis- counted back to the present and netted against the initial investment equals zero. As a result, the IRR of an investment will be the same as NPV’s target discount rate when NPV equals zero. IRR is a very important metric to many investors but thankfully, the formula is simple: =IRR(series of periodic cash flows).
Similar to NPV, the addition of the ‘x’ allows for more control over timing. While IRR is an annual measure, XIRR can accurately calculate a mixture of time periods, including monthly, quarterly, semi-annually or annually. The formula is =XIRR(series of periodic cash flows, range of associated dates)
Back in the day, any real estate professional worth their salt would have a little red covered book called the “Ellwood Tables for Real Estate Appraising and Financing” right by their side. Filled with page after page of tables, it allowed the reader to quickly figure out the annual loan payment at a variety of nominal interest rates and amortization periods. This function in Excel makes the process a snap: =PMT(nominal interest rate, amortization period, initial loan amount). One word of caution – most loans are amortized and paid on a monthly basis so be sure that the nominal interest rate and amortization period both reflect this.
FV to find loan balance
Once you determine the loan payment, you can easily find the loan balance at any point during the life of that loan. The only time the future value (FV) will be zero is once the final payment is made and the loan is fully amortized. The formula is =FV(nominal interest rate, specific period for loan balance, periodic loan payment, original loan amount). Two input items of note. First, be sure that the interest rate, specific period and periodic loan payment all reflect months if using monthly compounding. And second, be sure to enter the periodic payment as a negative if the original loan amount is entered in as a positive.
Sticking with the loan theme, we know that the concept of classic loan amortization results in a portion of each periodic payment representing interest and a portion representing principal, which in turn reduces the outstanding loan balance. While both portions are important, we can use the IPMT function to determine exactly how much interest is associated with a particular periodic payment. The formula is =IPMT(nominal interest rate, specific payment period for interest component, total amortization period, original loan amount). Once again, be sure that all of the components represent months if using monthly compounding.
While IRR is a very useful tool, it has limitations related to its treatment of both negative and positive cash flows that the primary investment produce. Diving into the nuances associated with the treatment of negative cash flows can be the subject of an entire column (spoiler alert) so for now, just set that one aside. As for positive cash flows, IRR makes no assumption for cash flows that come out of an investment. The only thing that IRR cares about money coming out of a deal is that it is no longer in that deal. That’s an issue because, as an investor, I can re-invest that money into another investment. A concept known as Modified Internal Rate of Return (or MIRR) addresses this limitation by introducing consideration of a secondary investment, and associated reinvestment rate, for any positive cash flows that are generated by the primary investment. The formula is =MIRR(series of cash flows, safe rate applied to negative cash flows, reinvestment rate applied to positive cash flows).
While Excel has certainly changed the landscape of accounting and financial analysis, it wasn’t the pioneer. If you have a long enough memory, you may be thinking about Lotus 1-2-3, which was introduced in 1983. But four years prior to that was the OG – VisiCalc was the first spreadsheet software developed for personal computers in 1979. It is rumored that when co-founder Dan Bricklin, then a student at Harvard, showed his creation to a group of accountants, they sat in stunned belief at the ease by which simply changing a number would automatically update the sum total. And then, one of them started to cry. We certainly have come a long way, baby.
Financial Strategies by Alec J. Pacella, for October 2022 Properties Magazine.
CRED iQ regularly monitors distressed rates and market performance for nearly 400 Metropolitan Statistical Areas (MSAs) across the US, an enormous data set that includes some $900 billion in outstanding CRE debt.
Month-by-month improvements In the report, they’ve laid out distressed rates and month-over-month changes for the month of June 2022, for the 50 largest MSAs, as well as a breakdown by property type (see below). “Distressed rates (DQ + SS%),” they write, “include loans that are specially serviced, delinquent, or a combination of both.”
Standout areas Of the top 50 MSAs, some 43 showed month-over-month improvements “in the percentage of distressed CRE loans within the CMBS universe”. New Orleans (-9.57%) and Louisville (-3.41%) were two of the MSAs with the acutest declines [in distress rate] this month.
On the other end of the scale, Charlotte (+1.15%) and Virginia Beach (+1.12%) were among the seven MSAs showing increases in distress rates last month.
By property type “For a granular view of distress by market-sector”, the report also delves into distress by property type, which potentially holds strategic insight for regional commercial real estate professionals.
“Hotel and retail were the property types that contributed the most to the many improvements in distressed rates across the Top 50 MSAs,” they detail. “Loans secured by lodging and retail properties accounted for the 10 largest declines in distress by market-sector. This included the lodging sectors for New Orleans and Detroit as well as the retail sectors for Tampa and Cincinnati.”
SOCIAL: What data metrics do you find most useful for understanding the health of CRE in your region?
Credit for commercial real estate (CRE) looks to be entering a crunch state in the second half of 2022 as a number of the big lenders announced in July that they were pulling back in that sphere.
The latest to make such an announcement are Signature Bank and M&T Bank. The former said it “expected to cut back on lending for multifamily and other commercial real estate assets”, and the latter laid the blame squarely at the feet of higher interest rates in its decision to make “fewer CRE loans this year”.
M&T’s CRE loan balances decline by 2%, or $830m in Q2 2022, as reported by the Real Deal, who extracted key takeaways from an earnings call hosted by M&T chief financial officer Darren King. King reportedly specified that construction loans declined, alongside a decline in completed projects and new developments coming online.
Interest rates and inflation
King said the rates moves were “affecting cap rates and asset values” and that they were “not seeing the turnover in properties like you might have under normal circumstances. And that will affect the pace of decline and our growth in permanent CRE.”
According to BisNow reporting, “Interest rates, raised in an attempt to beat back record-high inflation, have contributed to a drop in investment volume from the highs of 2021 and early 2022, slowing CRE deal volume”.
In broad term, these economic conditions are seen at varying rates around the world right now. As S&P’s recent update explains: “Economic growth is slowing. Interest rates remain stubbornly high. Estimates of the risk of recession or even stagflation creep upward and questions persist on whether central banks are under- or over-reacting in pursuit of monetary normalization.”
Additionally, on the residential side, their PMI research indicates “a steep contraction in demand for real estate amid tightening financial cost of living”.
Social: How is the rising cost of living playing out in your market?
A new report out from JP Morgan Chase provides an interesting mid-year review for commercial real estate (CRE), showing positivity in the first half of 2022, despite the various headwinds the industry faces.
“Despite rising interest rates—with the potential for more hikes in the coming months—commercial real estate has seen success in 2022,” writes Al Brooks, Head of Commercial Real Estate, Commercial Banking at JPMorgan Chase.
Giving retail a boost Even the beleaguered retail space has some standouts, according to JPMorgan. The report highlights a handful of factors that have bolstered strip malls in highly populated residential areas, underpinned by the likes of “grocery stores, fast-casual restaurants, and other retailers offering in-person services”, reads MPAMag’s coverage of the findings.
“JPMorgan observed that walk-in MRIs, testing clinics, and other non-traditional tenants may fill more shopping centers as retail evolves and adapts,” they add.
Class B and C malls, however, “continue to struggle” and the report authors call them “prime candidates for adaptive reuse” – into affordable housing and even industrial use, like fulfillment centers.
Industrial still booming Given the huge demand for industrial space – a trend that continues unabated – the report posits that we may start to see this category of property maturing in interesting ways. This could include adding the kinds of facilities and amenities which we associate with offices, such as gyms, complimentary snacks, nursing rooms, and so on.
This would fit with the evolution towards “multiple business purposes” within industrial sites, “such as a shipment center with offices or a showroom”, according to the report authors.
Casting forward As for the next six months, the report has a tone of tentative positivity, writing: “Multifamily and industrial properties have thrived in 2022. With healthy balance sheets, consumer demand could bolster retail, multifamily and industrial asset classes.”
But, they say, they’re keeping an eye on how “the country navigates hybrid work” and “on interest rate hikes, supply chain issues and geopolitical events, as well as ongoing relationships between public and private entities in affordable housing”.
For more information, and a link to the webinar replay, click here.
Social: What was the state of CRE in the first six months of 2022 in your region?