Key Commercial Real-Estate Loan Terms Extraction

Hello again. In the previous lesson, you mapped the entities and contracts surrounding a real-estate financing: the fund may bear the economics, but the borrower owes the debt and is often the natural hedge entity. We now move one layer closer to the actual exposure. Before anyone can recommend a cap or request dealer quotations, the loan’s interest and repayment mechanics must be converted from prose into a reliable, hedge-ready data set.

By the end of this lesson, you should be able to take a commercial real-estate loan summary, term sheet, or facility extract and identify the benchmark, margin, reset convention, day-count basis, maturity, amortisation, and prepayment terms. You will also be able to distinguish what is expressly stated from what must still be confirmed in the definitive facility agreement.

---

Treat the loan summary as an exposure specification

A loan summary is not just a financing overview. For hedge coordination, it is the first version of an exposure specification: a compact statement of what rate risk exists, when it exists, and how the underlying debt balance may change or disappear.

The core task is to extract the commercial terms without silently filling in missing detail. A term sheet might state:

Floating rate: Daily Simple SOFR plus 325 basis points.
Interest payable monthly.
Five-year term, 30-year amortisation.
Voluntary prepayment permitted subject to notice and fee.

This is useful, but it does not automatically tell you every convention needed for a precise hedge assessment. In particular, “payable monthly” does not necessarily mean “resets monthly,” and “five-year term” does not necessarily mean the hedge should run for five years.

A disciplined extraction has three layers:

Layer	What you record	Example
Source wording	The actual language and document location.	“Daily Simple SOFR plus 325 bp.”
Normalised term	A standardised interpretation for analysis.	USD, Daily Simple SOFR, margin of 3.25 percent per annum.
Status and follow-up	Whether it is confirmed, assumed, or missing.	Confirm lookback, floor, business-day convention, and benchmark fallback.

This approach matters operationally as well as analytically. A recommendation based on “monthly SOFR plus 325” may look reasonable, yet fail to match a daily-compounded loan with a five-business-day lookback. The difference may be modest in cash terms, but it can create basis risk, settlement reconciliation problems, or a failure to satisfy a lender’s hedging covenant.

The following short reading is a practical orientation to the fields typically found in a commercial real-estate term sheet. It is U.S.-oriented and uses LIBOR in an older example, but its distinctions between rate, maturity, payment terms, and amortisation remain useful.

A first-pass extraction sheet should have, at minimum, these headings:

1. Loan identity: borrower, facility name, currency, lender, document date.
2. Rate mechanics: benchmark, margin, any floor or cap, interest period, reset convention, payment dates, and day-count basis.
3. Debt profile: commitment, current drawn balance, future draws, amortisation, balloon balance, and maturity.
4. Prepayment mechanics: voluntary and mandatory prepayments, notice periods, fees, restrictions, and consequences.
5. Evidence gaps: terms absent from the summary or requiring confirmation in definitive documents.

The rest of this lesson explains how to populate each field accurately.

---

Benchmark and margin: identify both parts of the floating rate

For a conventional floating-rate loan, the annualised contractual interest rate is usually:

$$r_t=B_t+M$$

where:

• $B_t$ is the applicable floating benchmark at time $t$;
• $M$ is the contractual margin, also called the spread or applicable margin.

If the loan says “Daily Simple SOFR plus 325 basis points,” the benchmark is Daily Simple SOFR and the margin is:

$$325\text{ bp}=3.25\%$$

The benchmark is not merely “SOFR.” It needs to be captured with enough precision to identify the calculation method. Common formulations include:

• Term SOFR for a stated one-month or three-month period;
• Daily Simple SOFR;
• Compounded SOFR in arrears;
• a benchmark average such as 30-Day Average SOFR;
• in sterling financings, a SONIA-based rate;
• in euro financings, a EURIBOR or EURSTR-based rate.

For the hedge process, record the benchmark in the loan’s own words first. Then extract the features embedded in that label. “Three-month Term SOFR” and “Daily Simple SOFR” are both SOFR-based, but they are not the same cash-flow exposure.

The margin is normally a credit component determined by lender risk, leverage, asset type, and market conditions. It is usually fixed for the loan life, but do not assume that. In some facilities, the margin steps up or down with loan-to-value, debt-service coverage, rating, or another covenant test.

For example:

Raw loan wording	Proper extraction
“SOFR plus 325 bp.”	Benchmark is incomplete unless the definition of SOFR identifies term, daily simple, compounded, or another methodology. Margin is 3.25 percent per annum.
“One-month Term SOFR plus 300 bp, subject to a 0.50 percent floor.”	One-month Term SOFR; margin of 3.00 percent; benchmark floor of 0.50 percent.
“Daily Simple SOFR plus applicable margin.”	Daily Simple SOFR; margin must be found in the pricing grid or definition of Applicable Margin.
“Fixed rate of 6.25 percent.”	Fixed-rate loan. There is no floating benchmark exposure during the fixed period, although refinancing exposure may remain.

A floor is especially important. If the contractual benchmark is floored, the effective rate becomes:

$$r_t=\max (B_t,F)+M$$

where $F$ is the floor. A 0.50 percent floor means the borrower does not benefit from benchmark rates below 0.50 percent, even if the observed benchmark falls lower. A hedge intended to protect against rising rates may still be appropriate, but the floor affects the loan’s economics and the precise comparison with dealer terms.

This video gives a brief commercial explanation of the distinction between the market index and the lender’s spread.

A critical discipline for an advisory offering is to avoid calling the total coupon “the benchmark.” If a borrower pays 7.40 percent, that might consist of a 4.15 percent benchmark, a 3.25 percent margin, and perhaps a floor or other adjustment. The hedge normally addresses the benchmark component, not the lender margin.

---

Reset convention: establish how and when the benchmark becomes payable

“Reset convention” is a practical umbrella term. It answers two connected questions:

1. Which rate observations determine the benchmark?
2. When does the borrower know and pay the resulting interest amount?

The reset convention is often the most overlooked field in a high-level loan summary. It matters because the loan and hedge should use compatible benchmark definitions, observation periods, business-day rules, and payment dates.

A term rate set in advance

Under a typical term-rate convention, the benchmark for an interest period is known before that period begins. For example, a one-month Term SOFR rate may be fixed at the start of the month and apply until the next reset date.

The borrower knows the applicable rate at the outset, subject to changes in principal. In shorthand:

$$\text{Interest for period}\approx P\times (B_{\text{start}}+M)\times \frac{d}{D}$$

where:

• $P$ is principal outstanding;
• $B_{\text{start}}$ is the rate fixed at the start of the period;
• $d$ is the number of accrual days;
• $D$ is the day-count denominator.

A “one-month interest period” is not enough information by itself. You must also record the rate determination date, the business-day convention, and any rule for month ends.

A daily rate observed in arrears

A daily SOFR loan can instead accrue interest using overnight rates observed over the actual interest period. In a daily-simple structure, the loan rate changes each day as the reference rate changes, although it may be observed with a specified lag.

Conceptually:

$$I=\sum _{t=1}^n{P}_t\left(B_{\text{obs},t}+M\right)\frac{d_t}{D}$$

where $B_{\text{obs},t}$ is the benchmark observation applied to day $t$.

This rate structure may pay interest monthly, but it is not therefore a monthly-reset loan. The borrower may pay once per month while interest has accrued from a daily sequence of rates.

Lookbacks, lockouts, and payment delay

Daily overnight-rate loans commonly use conventions intended to give the borrower notice of the payment due.

• A lookback uses the published rate from a stated number of business days earlier. A five-business-day lookback is common in certain business-loan conventions.
• A lockout freezes the applicable rate for the final number of days of the interest period.
• A payment delay allows payment a few days after the end of the accrual period.
• An in-advance average determines the rate before the interest period begins, often by referring to an earlier published average.
• An in-arrears average reflects rates observed during the current interest period.

These distinctions affect hedge alignment. A standard overnight indexed swap may naturally track compounded overnight rates in arrears, while a loan may use daily simple SOFR with a lookback and no observation shift. The hedge can still be economically useful, but the difference is real and must be identified rather than ignored.

The ARRC guide below is technical, but the selected extracts are valuable because they show both the logic of these conventions and actual template facility wording.

When extracting reset mechanics, use this checklist:

Field	Example of a complete entry	Why it matters
Benchmark	Daily Simple SOFR	Identifies the reference rate.
Observation method	Five U.S. government securities business-day lookback, no observation shift	Determines which historical rates apply.
Interest period	Calendar month	Defines the accrual period.
Reset frequency	Daily, using observed SOFR for each interest day	Prevents “monthly payment” being mistaken for “monthly reset.”
Interest determination date	Two business days before period start	Relevant for a term or in-advance rate.
Interest payment date	Last business day of each calendar month and maturity	Determines cash-flow timing.
Business-day convention	Modified Following, adjusted	Can change period dates and payment dates.
Floor	Zero percent SOFR floor	Changes the minimum applicable benchmark.
Fallback	Contractual replacement-benchmark provisions	Determines what happens if the benchmark is unavailable or discontinued.

At this stage, the objective is not to negotiate these provisions. It is to extract them accurately and flag any missing data before comparing instruments.

---

Day-count basis: the denominator behind the interest bill

The day-count convention determines how an annualised interest rate becomes a cash amount for a particular interest period.

A common convention for USD commercial lending is Actual/360:

$$I=P\times r\times \frac{\text{actual days}}{360}$$

Suppose a USD 40 million loan accrues at an annualised all-in rate of 7.00 percent for 31 days on an Actual/360 basis. Ignoring changes in principal:

$$I=40,000,000\times 0.07\times \frac{31}{360}$$ $$I=241,111.11$$

If the same rate and 31-day period used Actual/365, the amount would be lower:

$$I=40,000,000\times 0.07\times \frac{31}{365}$$ $$I=237,808.22$$

The difference is not normally the primary economic risk, but it is material enough to matter in reconciliations, modelling, and hedge-basis analysis.

Common conventions include:

Convention	Meaning
Actual/360	Actual number of calendar days divided by 360. Common in USD money-market and loan conventions.
Actual/365 Fixed	Actual number of calendar days divided by 365. Often seen in sterling contexts.
30/360	Treats months and years according to a stylised 30-day-month, 360-day-year method.
Actual/Actual	Uses actual days and an actual year denominator, subject to the specified variant.

Do not infer the day-count basis from the currency or benchmark alone. Record what the facility says. If the summary only says “interest is calculated daily,” that is not sufficient. You still need the denominator and, for an overnight rate, the weekend and holiday treatment.

---

Maturity and amortisation: separate the legal end date from the repayment profile

Maturity is the date on which all amounts due under the facility become payable, subject to any valid extension or refinancing. It is the legal end point of the debt, not necessarily the date on which principal has been fully repaid through periodic instalments.

Amortisation describes how principal is scheduled to reduce before maturity.

Commercial real-estate debt commonly combines a relatively short legal term with a longer amortisation period. A five-year facility may calculate monthly principal-and-interest payments using a 25-year or 30-year amortisation schedule. That makes periodic debt service more manageable but leaves a substantial balance payable at maturity: the balloon payment.

This video illustrates the distinction and its commercial consequences.

For hedge coordination, extract the principal profile in a form that can later become a hedge-notional schedule:

Loan repayment structure	What to extract	Hedge relevance
Interest-only	Principal remains unchanged until maturity or another specified event.	A flat hedge notional may align initially.
Straight-line amortisation	Fixed principal reductions on stated dates.	Hedge notional may need scheduled step-downs.
Mortgage-style amortisation	Payments calculated by reference to a stated amortisation period.	Principal reduces gradually, but the actual schedule must be obtained.
Cash sweep	Excess cash must repay debt under specified conditions.	Principal may reduce unpredictably; creates over-hedging risk if not managed.
Bullet or balloon	Balance due at maturity after limited or no amortisation.	Exposure can stay high until repayment, refinancing, or sale.
Delayed-draw facility	Commitment may be drawn later for acquisition, works, or capital expenditure.	A hedge on the full commitment could exceed debt outstanding before draws occur.

A loan summary may state “five-year term, 30-year amortisation” but not give the actual monthly principal schedule. Mark the schedule as required rather than estimating it informally. The next lesson will focus on constructing projected debt notionals; this lesson is about identifying the inputs required to do so.

Also capture:

• the original commitment;
• the current drawn amount;
• any undrawn commitment and draw-stop date;
• interest-only periods;
• amortisation start date;
• scheduled repayment dates;
• maturity date;
• extension options and their conditions;
• whether the lender, borrower, or both control an extension.

An extension option should not be treated as guaranteed hedge tenor. It may be subject to loan-to-value tests, no-default conditions, payment of an extension fee, lender consent, or a continuing hedging covenant.

---

Prepayment: identify the debt event before considering hedge consequences

Prepayment is the repayment of principal before its scheduled maturity. It is one of the most important terms to extract because a loan can disappear while a hedge remains outstanding.

There are two broad categories.

Voluntary prepayment

The borrower elects to repay all or part of the loan, often in connection with a sale, refinancing, recapitalisation, or excess cash position. The facility may require:

• a minimum prepayment amount;
• a specified notice period;
• payment on an interest payment date only;
• a prepayment fee;
• lender consent in specified circumstances;
• payment of accrued interest, break funding costs, or other amounts.

Mandatory prepayment

The facility requires repayment after a defined event. Common triggers can include:

• sale or disposal of the property;
• receipt of insurance proceeds;
• certain condemnation or compulsory-acquisition proceeds;
• excess proceeds from a refinancing;
• illegality or lender funding issues;
• asset-level cash sweeps;
• a change in control;
• default and acceleration.

The hedge adviser does not decide whether a particular clause is enforceable or how it should be interpreted legally. But the adviser must identify that the clause exists, capture its operative terms, and escalate it for legal and commercial review.

Prepayment cost is not hedge termination cost

These are separate exposures.

Cost or consequence	Origin	Typical question
Loan prepayment fee	Facility agreement	What does the borrower owe the lender for early repayment?
Yield maintenance or defeasance	Facility agreement and related documents	Must the lender's expected cash flow be preserved or substituted?
Hedge close-out amount	ISDA documentation and trade confirmation	What is the market value of terminating the cap, swap, or collar?
Residual hedge exposure	Mismatch between loan repayment and hedge termination	Does the hedge remain live after the loan is repaid?

A lockout period can be commercially decisive. If voluntary repayment is prohibited for two years, an investor may be unable to sell or refinance freely even if it is willing to pay a fee. Conversely, if a loan can be prepaid at any time with only five business days’ notice, a long-dated swap may create significant early-termination uncertainty.

When extracting prepayment terms, do not write merely “prepayable.” Use a structured statement such as:

Voluntary partial or full prepayment permitted after the first anniversary on five business days’ prior notice, subject to a fee of 2 percent in year two and 1 percent in year three; mandatory prepayment required from net sale proceeds; confirm whether lender consent is required for property disposals and whether a hedge must be terminated concurrently.

That single sentence creates a usable bridge between the facility documents, the investment exit plan, and later hedge design.

---

Worked extraction: turning a loan summary into a hedge-ready record

Assume the borrower provides the following summary:

USD 40 million senior term loan to Warehouse PropCo LLC. Interest at Daily Simple SOFR, subject to a zero percent floor, plus 325 basis points. SOFR observed five U.S. government securities business days prior to the relevant interest day, without observation shift. Interest is paid on the last business day of each calendar month. Interest is calculated on an Actual/360 basis. Maturity is 30 September 2029. The loan is interest-only for twelve months, then amortises through monthly payments calculated on a 30-year schedule, with all remaining principal due at maturity. Voluntary prepayment is permitted in whole or in part on five business days’ notice, subject to a 2 percent fee in year two and a 1 percent fee in year three. Net sale proceeds must be applied in mandatory prepayment.

A strong extraction sheet would look like this:

Field	Extracted term	Status and comment
Borrower	Warehouse PropCo LLC	Confirm legal name, jurisdiction, and whether it is also proposed hedge entity.
Currency	USD	Confirm hedge currency must be USD unless another exposure is intentionally addressed.
Benchmark	Daily Simple SOFR	Confirm full defined term and benchmark-fallback provisions in facility agreement.
Margin	325 bp per annum	Equivalent to 3.25 percent per annum. Check whether margin can change under a pricing grid.
Benchmark floor	Zero percent	No negative benchmark benefit below zero.
Observation convention	Five U.S. government securities business-day lookback; no observation shift	Must be compared with dealer hedge convention.
Reset frequency	Daily rate application	Monthly payment does not mean monthly reset.
Payment frequency	Monthly, on last business day	Confirm payment date adjustment and final maturity payment treatment.
Day-count basis	Actual/360	Use in debt-service projections and reconciliations.
Maturity	30 September 2029	Confirm whether extension options exist and whether they are borrower-controlled.
Amortisation	Twelve months interest-only; then monthly payments based on 30-year amortisation	Obtain actual amortisation schedule and amortisation commencement date.
Balloon	Remaining principal due at maturity	A refinancing or sale may be needed if the asset is not sold before maturity.
Voluntary prepayment	Whole or partial; five business days’ notice; stated year-two and year-three fees	Confirm prepayment terms for year one, year four onward, and whether prepayment is restricted to payment dates.
Mandatory prepayment	Net sale proceeds	Confirm definition of sale, permitted reinvestment rights, release provisions, and timing.
Hedging covenant	Not stated	Must be confirmed. Do not assume that a hedge is optional merely because the summary does not mention one.

Notice the difference between a conclusion and an assumption. It is appropriate to conclude that the loan has daily SOFR exposure and a changing principal balance after the interest-only period. It would not be appropriate to conclude that a five-year cap is required, that the hedge must have a five-day lookback, or that the lender accepts any hedge dealer. Those require separate information.

---

A practical extraction standard for your future client offering

For a hedge-coordination service, the output should be more rigorous than a note saying “floating-rate loan, five years, 325 over SOFR.” A useful internal standard is:

• Quote the source language for every economically material term.
• State the document name, date, and page or clause reference.
• Separate confirmed terms from assumptions and open points.
• Use the borrower’s legal name and facility currency.
• Capture calculations, not merely labels: “Daily Simple SOFR with five-business-day lookback” is more useful than “SOFR.”
• Record the debt balance profile separately from commitment amount.
• Flag prepayment and sale provisions early, because the property business plan may be inconsistent with the nominal loan maturity.
• Do not rely on a term sheet where the executed facility agreement, amendments, notices, or fee letters may alter the economics.

A concise loan summary can be sufficient to begin a preliminary discussion, but it is not a substitute for the executed facility and relevant schedules when moving toward trade execution.

---

Key takeaways

A hedge starts with accurate loan extraction.

• The benchmark is the floating reference rate; the margin is the lender’s contractual spread. Record both separately, along with any floor.
• A monthly interest payment can still arise from a daily-reset benchmark. Capture the full reset convention, including observation method, lookback, lockout, payment timing, and business-day rules.
• The day-count basis converts an annualised rate into a cash amount and must be taken from the facility rather than inferred.
• Maturity is the legal repayment end date; amortisation describes scheduled principal reduction before that date. A long amortisation period with a shorter term creates a balloon balance.
• Prepayment may be voluntary or mandatory, may be restricted or expensive, and must be distinguished from the separate economics of hedge termination.
• A professional extraction preserves source wording, normalises it for analysis, and labels uncertainties clearly.

Next, you will use these extracted terms to construct a projected debt-notional schedule for drawn, delayed-draw, and amortising real-estate loans.