![](https://assets.chathamfinancial.com/general-imagery/_1024x409_crop_center-center_90_none/57689/optimize-your-defeasance.webp)
Top 4 limitations in managing CRE debt in Excel
Summary
Commercial 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.
Disclaimers
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