The Quote Matrix: How to Compare Multiple Term Sheets Like a Pro

You ran a competitive financing process. Five lenders responded. Three issued term sheets. Now you have to pick one.

This is where most borrowers make the wrong decision.

The instinct is to compare interest rates. Lender A is at 6.25%, Lender B is at 6.50%, Lender C is at 6.40%, so Lender A wins. Term sheet signed, move to closing.

That logic costs borrowers real money on almost every deal. Interest rate is one input among ten that determine the true cost and risk of a loan. The borrower who picks based on rate alone routinely ends up with worse net economics than the borrower who builds a proper comparison.

This week we're walking through how to build a quote matrix, the side-by-side analysis sophisticated sponsors use to compare term sheets across every dimension that matters. It's the single biggest leverage point in any financing process.

Why Rate Comparisons Mislead

Two term sheets with the same headline rate can produce radically different all-in economics.

Consider two offers on a $10M loan:

Lender A: 6.25% fixed, 1.00% origination fee, full recourse, 65% LTV, yield maintenance prepayment.

Lender B: 6.50% fixed, 0.50% origination fee, non-recourse, 70% LTV, 3-2-1 step-down prepayment.

Rate says A wins. But:

• B's origination fee is $50K lower upfront
• B's higher LTV means $500K less equity required, freeing capital for other deals
• B's non-recourse structure removes personal liability
• B's prepayment is far more flexible if you refinance early

Run the math across the full hold period including fees, opportunity cost on equity, and prepayment exposure, and B is almost certainly the better deal even at the higher rate.

The borrower who compares rates picks A. The borrower who builds a quote matrix picks B.

What Goes in the Matrix

A proper quote matrix compares every term sheet across the same dimensions. At minimum:

Loan Structure

• Loan amount
• LTV (and basis: as-is vs. as-stabilized)
• Term (years)
• Amortization (years, including interest-only periods)
• Interest-only period (months)

Rate

• Interest rate (current all-in)
• Index (Treasury, SOFR, Prime)
• Spread (basis points over index)
• Fixed or floating
• Rate lock timing (application, commitment, closing)

Fees

• Origination fee (% and dollar amount)
• Exit fee (if any)
• Application or processing fees
• Legal fees (lender's counsel)
• Third-party report costs (appraisal, environmental, property condition)
• Rate lock fees (if applicable)

Prepayment

• Lockout period (months)
• Prepayment structure (yield maintenance, defeasance, step-down, open)
• Open window before maturity
• Partial prepayment rights
• Casualty/condemnation carve-outs

Recourse and Guarantees

• Recourse type (full, partial, non-recourse)
• Carve-out scope (standard bad-boy, expanded)
• Burn-down provisions (if applicable)
• Multiple guarantor structure

Reserves and Escrows

• Tax and insurance escrows (required or waived)
• CapEx reserves ($/SF or $/unit annually)
• TI/LC reserves (if commercial)
• Debt service reserves (months)
• Earnout or holdback provisions

Covenants

• Minimum DSCR trigger
• Maximum LTV trigger
• Cash management triggers (cash sweep, cash trap)
• Reporting requirements (monthly, quarterly, annual)
• Financial covenants (sponsor net worth, liquidity)

Process and Timing

• Closing timeline (days from application)
• Due diligence requirements
• Internal approval status (committee approved, conditional)
• Extension options
• Assumability

Building the Matrix: A Simple Template

Lay out a spreadsheet with each term sheet in a column and each comparison point in a row. Color-code green for the most favorable in each row, yellow for middle, red for least favorable.

Here's a simplified example for a $10M loan request:

Now the trade-offs are visible. Lender C has the best rate but lowest leverage and slowest closing. Lender B has the highest rate but most flexibility and fastest execution. Lender A is in the middle but requires full recourse.

The right choice depends on your specific deal and strategy, not on any single line of the matrix.

The Hidden Cost: All-In Cost of Capital

Beyond the matrix itself, sophisticated borrowers calculate the all-in cost of capital for each option. This unifies fees, rate, and structure into a single comparable number.

Basic All-In Cost Calculation

For each lender, calculate:

Total Loan Cost = Interest paid over hold + Origination fee + Exit fee + Rate cap cost (if floating) + Legal fees + Other closing costs

Effective rate = Total loan cost / loan amount / hold period (years)

This effective rate captures everything you actually pay, not just the headline rate.

Example

On a $10M loan held for 3 years:

Lender A (6.25% fixed, 1% origination, no exit fee, $25K legal):

• Interest: ~$1.87M (3 years at 6.25%)
• Origination: $100K
• Exit fee: $0
• Legal: $25K
• Total: $1.995M
• Effective rate: 6.65%

Lender B (6.90% floating, 1.25% origination, 0.5% exit fee, $30K legal, $130K rate cap):

• Interest: ~$2.07M (3 years at 6.90%)
• Origination: $125K
• Exit fee: $50K
• Legal: $30K
• Rate cap: $130K
• Total: $2.405M
• Effective rate: 8.02%

Lender B costs ~140 bps more per year than its headline rate suggests. That's not necessarily a reason to pick Lender A. It might be worth paying for non-recourse, higher leverage, and speed. But the trade-off is now quantified, not hidden.

The Three Trade-offs That Actually Drive Decisions

Once you have the matrix and the all-in cost calculation, the decision usually comes down to three trade-offs:

1. Rate vs. Recourse

How much extra rate is worth removing personal recourse?

A 50-75 bps premium for non-recourse is typical. If you're building a portfolio and don't want personal liability stacked across multiple deals, that premium can be worth it many times over. If you have a strong personal balance sheet and the deal is conservative, full recourse with the lower rate may make sense.

2. Rate vs. Leverage

How much extra rate is worth higher leverage?

Higher leverage frees up equity for other deals, improves returns on the equity invested, and reduces your equity-at-risk on this specific deal. But it also costs basis points. The calculus depends on the opportunity cost of your equity capital.

3. Rate vs. Flexibility

How much extra rate is worth prepayment flexibility, faster closing, or more flexible covenants?

A debt fund at 6.90% with open prepayment after 18 months may be better than a CMBS loan at 6.25% with yield maintenance if your business plan calls for a refinance in 24 months. The cheaper rate is more expensive if you have to break it.

Common Mistakes Borrowers Make

Mistake #1: Comparing Only the Rate

We've covered this. Don't do it.

Mistake #2: Ignoring Fees

Origination and exit fees can add 100-200 bps of effective cost to a loan. They're paid in dollars, not percentages, so they hit hardest on shorter holds.

Mistake #3: Skipping the Rate Cap

If you're taking floating-rate debt, the cap cost is real. A 2-year cap on a $10M loan can run $75K-$150K depending on strike and market conditions. Include it in your all-in math.

Mistake #4: Underweighting Recourse

If your deal goes sideways, full recourse can cost you everything you own. Personally guaranteeing a multi-million dollar loan is not a minor term. Price it like the contingent liability it is.

Mistake #5: Ignoring Reserves

Reserve requirements vary widely between lenders. Higher reserves mean more cash tied up at closing and less available for other deals. Calculate the opportunity cost.

Mistake #6: Not Pressure-Testing the Covenants

A 1.25x DSCR covenant with no cushion above the current operating ratio means a small drop in NOI triggers a default. A 1.15x covenant on the same property gives you breathing room.

Mistake #7: Ignoring Closing Speed

If your acquisition closing is in 45 days and the lender quotes 60 to close, the cheaper rate doesn't matter. The deal dies.

How to Use the Matrix to Negotiate

The quote matrix isn't just a decision tool. It's a negotiation tool.

When you have multiple credible term sheets, you can go back to your preferred lender with specific asks backed by competing offers:

• "Your origination fee is 1.25%. Lender X is at 0.75%. Can you come down to 1.00%?"
• "Your DSCR covenant is 1.25x. Lender Y is at 1.15x with cure period. Can you match?"
• "Your prepayment is yield maintenance. Lender Z is offering step-down. Open to discussing?"

Specific asks backed by competing offers move terms. Vague pressure doesn't.

On a $10M loan, even modest negotiation wins, 25 bps off origination, a 0.10x improvement in DSCR covenant, an extra 6 months of open prepayment, add up to meaningful value.

The Bottom Line

Comparing term sheets on interest rate alone is the single most expensive mistake in CRE financing.

A proper quote matrix looks at:

• Loan structure (amount, LTV, term, amortization)
• Rate components (index, spread, fixed vs. floating)
• All fees (origination, exit, processing, legal, third-party)
• Prepayment provisions (lockout, structure, open window)
• Recourse and guarantees (type, scope, burn-down)
• Reserves and escrows (taxes, insurance, CapEx, debt service)
• Covenants (DSCR, LTV, cash management)
• Process and timing (closing speed, due diligence requirements)

Layer in an all-in cost of capital calculation, and the right answer usually becomes obvious.

The borrowers who consistently win in CRE financing aren't the ones who chase the lowest rate. They're the ones who build the right matrix, do the math, and pick the structure that actually fits their deal and strategy.

Want to compare term sheets from multiple lenders side by side? Submit your deal on LenderAve and run a competitive process with our built-in quote comparison tools.

About Debt Fridays

Debt Fridays is LenderAve's weekly blog series delivering practical insights on commercial real estate financing. Published every Friday, we cover everything from lending basics to advanced deal strategies. Subscribe to never miss an issue.

Have a topic you'd like us to cover? Email us at info@lenderave.com

Tags: Debt Fridays, Commercial Real Estate, CRE Financing, Deal Strategies, Term Sheet Comparison, Quote Matrix, Loan Comparison, CRE Negotiation