Top 4 limitations in managing CRE debt in Excel
SummaryCommercial real estate (CRE) professionals are turning their attention toward technology to optimize workflows and focus on the core of their business: managing properties/portfolios and generating returns.
While Excel serves many purposes, it was not designed to assist CRE professionals in managing their loan portfolios and therefore has many inherent limitations when used for this purpose.
- Data integrity risk. Without a series of robust processes and controls, the use of Excel to track loan-related information can increase the risk of relying on inaccurate or outdated data. This can lead to failures in compliance and ill-informed strategic decisions, yet many CRE investors track loan- and debt-related information in Excel. Given how tedious loan review and term extraction can be, coupled with the need to manually transfer this information into Excel, the use of spreadsheets is highly susceptible to human error. In addition, when loans are modified (e.g., refinance, principal draw or paydown), the “right” person needs to know that this has happened, update the spreadsheet(s), and ensure that the “right” others within the organization know where to access the most current and complete information. Excel provides limited audit trail functionality for purposes of understanding how loan terms have changed over time and who has made what edits to any places that data is stored.
- Time- and labor-intensive. Managing a portfolio of CRE loans in Excel is both time- and labor-intensive, which can limit the productivity of real estate acquisitions, capital markets, and asset management teams, particularly those that run lean. Members of these teams add the most value by focusing on achieving organizational targets through optimizing asset performance and identifying opportunities to acquire, sell, or refinance properties. Yet many of them spend too much time locating and poring over loan documents, loading and updating data, and ensuring that nothing “breaks” in the “master spreadsheet” and anything that’s linked to it.
- Limited insights and actionability. Beyond simply capturing terms, how do you use them to derive insights and drive action? Most debt tracking spreadsheets, or abstracts prepared by counsel, contain static data relevant at the time it was entered (and likely no longer). However, markets are constantly in flux, and it is critical to understand your loan in the context of current market conditions, avoiding the pitfalls of making important decisions based on outdated information. An effective debt management program calls for consumption of various historical and live projected interest rates for purposes of budgeting and forecasting, double-checking payment notices from lenders, and calculating prepayment costs in connection with evaluating a potential sale or refinance.
- Incomplete solution. Because Excel was not designed to assist CRE professionals in managing their loan portfolios, it fails to address common needs to execute on an effective debt management strategy. For example:
- Key terms. Which terms and attributes are most important to track at the level of a specific asset, fund, or portfolio? Spreadsheets serve as a blank canvas that provides flexibility to capture and analyze an infinite amount of data, but you must know what to track.
- Key date reminders. Effective debt management requires prompts as various relevant deadlines/timetables approach (e.g., extension notifications, amortization, maturity, covenant compliance)
- Easy access to the right documents. CRE teams often store their loan documents in some combination of shared drives, active or archived email, or even in hard copy. Not all team members have easy access to the same documents, leading to version control issues, where somebody relies on a document that is not the latest/final. Teams also can lose documents when somebody leaves the firm abruptly.
- Managing enterprise/key person risk. A single team member often manages data extraction and capture, increasing enterprise risk if this team member abruptly leaves the firm or switches roles, potentially creating a single point of failure.
These are four of the many limitations of using Excel to manage a loan portfolio. If you're ready to explore alternatives, please reach out to us via the form below.
Ready to learn more about Chatham Debt Management?
Schedule an introductory call with one of our advisors.
Chatham Hedging Advisors, LLC (CHA) is a subsidiary of Chatham Financial Corp. and provides hedge advisory, accounting and execution services related to swap transactions in the United States. CHA is registered with the Commodity Futures Trading Commission (CFTC) as a commodity trading advisor and is a member of the National Futures Association (NFA); however, neither the CFTC nor the NFA have passed upon the merits of participating in any advisory services offered by CHA. For further information, please visit chathamfinancial.com/legal-notices.
Transactions in over-the-counter derivatives (or “swaps”) have significant risks, including, but not limited to, substantial risk of loss. You should consult your own business, legal, tax and accounting advisers with respect to proposed swap transaction and you should refrain from entering into any swap transaction unless you have fully understood the terms and risks of the transaction, including the extent of your potential risk of loss. This material has been prepared by a sales or trading employee or agent of Chatham Hedging Advisors and could be deemed a solicitation for entering into a derivatives transaction. This material is not a research report prepared by Chatham Hedging Advisors. If you are not an experienced user of the derivatives markets, capable of making independent trading decisions, then you should not rely solely on this communication in making trading decisions. All rights reserved.20-0229
Our featured insights
Matt Henry: 30 years of partnership and innovation with our clients
Matt Henry reveals how our clients rely on Chatham's independence and innovation to ensure they are making informed financial risk management decisions. Chatham Financial is celebrating 30 years of serving our clients.
Request your Q3 2021 Average Market Credit Spreads report
The information presented in this report represents average credit spread conclusions segregated by property type and grouped by LTV for the quarter ending June 30, 2021.Fixed mortgage spreads were moderately flat in Q3. However, debt mark-to-market had a slightly negative impact on equity fund...
Debt Valuation Market Update Q3 2021
In this webinar Jaran and Karina will highlight the key drivers of debt valuation for the third quarter 2021. They will also cover lending markets and the mark-to-market impact.
Common pitfalls in CRE loan portfolios
An examination of the common, yet critical, questions from real estate finance professionals on debt and derivatives structuring and placement.
How do leading CRE investors manage their debt portfolios?
Leading commercial real estate investors realize that minimizing risk and maximizing returns requires accurate, proactive management of their debt. They combine CRE-specific debt technology and industry-leading support for implementation/maintenance with advice on best practices.
Are debt management technology solutions worth the investment?
Commercial real estate (CRE) investors must evaluate the benefits of a debt management solution against the financial costs and internal efforts of implementation and maintenance.
Successful debt management: technology and workflow integration
Implementing a technology solution requires commitment across the organization and regular communication with your implementation team. Understanding existing internal workflows and business requirements is crucial in determining the appropriate system for managing and maintaining a debt portfolio.
Capital markets and accounting considerations in real estate M&A
Mergers and acquisitions involve a multitude of complexities and risks. Speed and accuracy at every stage of an acquisition is critical to not only winning the deal but also giving the transaction the best chance of financial and strategic success. Financial risk associated with the valuation of...