How to document a rate sensitivity test without forecasting interest rates
A practical guide for CRE sponsors to prepare a rate sensitivity analysis that shows lenders how a property's cash flows hold up under different interest rate scenarios, without trying to predict where rates are headed.
A practical guide for CRE sponsors to prepare a rate sensitivity analysis that shows lenders how a property's cash flows hold up under different interest rate scenarios, without trying to predict where rates are headed.
This guide explains how to document a rate sensitivity test for your commercial real estate financing request. The goal is to show a lender how your property's net operating income (NOI) and debt service coverage would change under different interest rate assumptions, without making any forecast about future rate movements. This is a distinct exercise from a budget or pro forma: it tests resilience, not projections.
Identify the base case from your current underwriting
Start with the interest rate assumption already in your financing scenario. This is your base case. Record the rate, the loan amount, and the resulting annual debt service (principal and interest payments). Do not adjust this rate up or down yet. The base case is your starting point, not a prediction. The base case gives you a single point of comparison for the next steps.
Build a simple rate sensitivity table
Create a table with three or four alternative interest rates. Choose round numbers that are higher and lower than your base case, for example base plus 100 basis points, base plus 200 basis points, and base minus 100 basis points. For each alternative rate, calculate the new annual debt service. Use a simple calculator or spreadsheet; you do not need to model amortization schedules. The key is to show how debt service changes when the rate moves. Label this table "Rate Sensitivity Test — Alternative Scenarios." This is your own workpaper, not a lender form. It documents the range you are testing and the method you used.
Add a brief narrative explaining the test's limits
Write a short paragraph under your table. State clearly that this test does not predict future interest rates. Explain that it is a sensitivity analysis based on the property's current NOI and the loan amount you are requesting. Note that actual lender underwriting will include additional factors such as lease expirations, market rent trends, and capital expenditure needs. This narrative keeps the test grounded in facts and avoids any appearance of rate forecasting. It also shows the lender you understand the difference between a sensitivity test and a projection.
Prepare a supporting document for your financing request
Create a one-page document titled "Rate Sensitivity Workpaper." Include your base case rate and loan amount, your sensitivity table with three alternative rates and the resulting DSCRs, and your brief narrative. Attach this workpaper to your financing request when you submit supporting files. This workpaper is your own analysis; it is not automatically verified or sent to lenders without your submission . It becomes part of your deal file and helps the reviewer understand your approach.
Ask the actual lender about their rate stress assumptions
Before you finalize your workpaper, ask your lender or their representative what rate stress assumptions they typically apply. Some lenders test a fixed spread over a benchmark rate; others use a specific stress scenario like a 200-basis-point increase. Do not guess or assume a standard. Record their answer and, if it differs from your table, add a note showing how your property would perform under their stress scenario. This step turns your generic test into a lender-specific analysis. The OCC handbook discusses how lenders evaluate external factors such as interest rates [1]. Asking the lender directly aligns your workpaper with their underwriting framework.
Reconcile timing differences between your T-12 and current rent roll
Your T-12 covers twelve historical months, while your current rent roll is a snapshot of today's occupancy and rents . These two documents may show different totals. Before you use NOI from the T-12 in your sensitivity test, compare it to the current rent roll. Identify any material differences, such as a recent lease-up or a vacancy that changed after the T-12 period ended. Write a short reconciliation note explaining the difference and which figure you used for your test. This note prevents confusion when the lender reviews your workpaper alongside your other documents.
Frequently asked questions
What if my property has floating rate debt?
If your loan will have a floating rate, your sensitivity test becomes even more important. The OCC notes that when a project has floating rate debt and fixed rents, increasing interest rates can have a negative effect on the borrower's repayment capacity [1]. In your workpaper, add a scenario where the rate increases by 300 basis points over the base case. This shows the lender you have considered the full range of possible rate movements.
Can I use projected NOI instead of historical NOI?
You can, but label it clearly as projected NOI and explain the basis for the projection. Lenders typically give more weight to historical performance. If you use projected NOI, include a separate column in your table showing the same sensitivity test using historical NOI. This allows the lender to compare both sets of results.
Does this test replace a full underwriting analysis?
No. This sensitivity test is a supporting document, not a substitute for lender underwriting. It helps you prepare for the financing discussion and shows the lender you have thought through rate risk. The actual underwriting will include many other factors, some of which are discussed in the OCC handbook [1]. Your workpaper is a tool for your own preparation, not a guarantee of any loan term.
Ready to test your property's numbers? The workbench lets you build your scenario and submit a preliminary financing request for review.
Model this deal and request financing
Run a multifamily acquisition or value-add model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.
Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.
Talk through your financing
Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).