Cash-on-Cash Calculator for CRE: A Practical Guide
A field guide to calculating simple and levered cash-on-cash returns, interpreting what the number means, and pairing it with DSCR and cap rate analysis in your underwriting workflow.
By crematic editorial team
What a cash-on-cash calculator actually tells you
Cash-on-cash return is one of the most misunderstood metrics in commercial real estate. It is not a total return measure. It does not capture appreciation, principal paydown, or tax benefits. It is a simple cash flow ratio: the cash you receive in a year divided by the cash you invested. That simplicity makes it useful, but it also makes it easy to abuse.
The basic formula and why equity matters more than price
Annual pre-tax cash flow divided by equity invested. That is the entire formula. The denominator is not purchase price. It is the actual cash you put into the deal after financing, closing costs, and reserves. This distinction matters because two deals with identical cap rates can produce wildly different cash-on-cash returns depending on leverage.
A deal bought at a 5.5% cap rate with 65% leverage at 6.5% interest produces roughly 7% cash-on-cash. The same cap rate with 75% leverage at 6.0% interest produces closer to 9%. The cap rate did not change. The capital structure did. A cash on cash return calculator that forces you to specify equity, not just price, prevents the common error of conflating unlevered yield with investor cash flow.
Simple versus levered cash-on-cash
The simple version uses unlevered cash flow. It tells you what the property generates before debt service. This is useful for comparing assets on an apples-to-apples basis, but it does not tell an equity investor what they actually earn. The levered version subtracts debt service from NOI and divides by equity invested. That is the number investors care about.
The danger is running the simple version and presenting it as investor return. A sponsor might show an 8% simple cash-on-cash and let limited partners assume that is their yield. In reality, with leverage, the levered return could be 12% or 4% depending on the debt terms. A disciplined calculator offers both modes and labels them clearly so the committee knows which number is being discussed.
Why it is not the same as IRR or equity multiple
Cash-on-cash is a one-year snapshot. IRR is a time-weighted return across the entire hold period. Equity multiple is total cash out divided by total cash in. These three metrics often disagree. A deal with strong Year 1 cash-on-cash can have a mediocre IRR if cash flows drop in later years. A deal with weak early cash-on-cash can have a strong equity multiple if the exit cap compresses.
This is why cash-on-cash vs cap rate comparisons are incomplete. Cap rate measures unlevered yield at a point in time. Cash-on-cash measures levered cash flow at a point in time. IRR measures total return over time. A complete underwriting package presents all three, with clear labels on what each metric assumes and what it ignores.
How to run levered cash-on-cash analysis before committee
The levered version is where most underwriting mistakes happen. Debt magnifies returns, but it also magnifies errors. A 25-basis-point mistake in the interest rate assumption can swing the cash-on-cash by 100 basis points or more when leverage is above 70%. Getting the debt stack right is not a footnote. It is the core of the analysis.
Building the debt stack inputs: loan amount, rate, and amortization
The three inputs that matter most are loan amount, interest rate, and amortization period. Loan amount is usually expressed as loan-to-value or loan-to-cost, but the cash-on-cash calculation needs the absolute dollar amount because debt service is a dollar obligation. Interest rate should include the full coupon, not just the index. If the loan is floating, use the current index plus margin, not the margin alone.
Amortization is where many analysts get sloppy. A 30-year amortization produces lower annual debt service than a 25-year amortization, which flatters the cash-on-cash. But if the loan term is only 5 years and the property is not fully stabilized, the balloon payment risk matters more than the annual payment. A good calculator lets you toggle amortization and see both the annual cash-on-cash and the balloon exposure at maturity.
Stress-testing interest rate and amortization assumptions
In April 2026, with the 10-year Treasury at 4.33%, a 75-basis-point rate buffer is a reasonable starting point for stress testing. If your base case assumes 6.25% interest, the stress case should run at 7.00%. The question is not whether the deal works at 6.25%. It is whether the deal still clears your minimum cash-on-cash threshold at 7.00%.
The second stress test is amortization compression. What happens if the lender requires 25-year amortization instead of 30? For a $7.5 million loan, that shift can add $40,000 to $60,000 in annual debt service. On a deal with thin cash flow, that is the difference between a positive and negative cash-on-cash. The best underwriters run both stresses and present the worst-case combination to committee.
When to pair cash-on-cash with DSCR analysis
Cash-on-cash tells you what the equity earns. Debt service coverage ratio tells you whether the property generates enough NOI to cover the debt. These are related but distinct. A deal can have an attractive cash-on-cash but a fragile DSCR if leverage is high and NOI is thin.
Most institutional lenders require a minimum DSCR of 1.20x to 1.35x. If your underwritten DSCR is 1.15x, the deal may not get financed, regardless of how good the cash-on-cash looks. A disciplined workflow requires both metrics. The cash on cash return calculator should show debt service and DSCR alongside the return so the committee can see both the upside and the financing risk in one view.
If your team is still rebuilding debt service math in Excel for every deal, a standardized cash-on-cash calculator cuts error and saves time.
Try the free cash-on-cash calculatorHow to interpret cash-on-cash by strategy and capital structure
A 10% cash-on-cash means something different for a core-plus apartment building than for a ground-up development. Strategy changes what the metric signals, and capital structure changes how much you should trust it. Interpreting cash-on-cash without context is like judging a restaurant by the speed of its kitchen without asking what kind of food it serves.
Core-plus versus value-add versus opportunistic
Core-plus deals should produce stable, predictable cash-on-cash from Day 1. If a core-plus multifamily deal is underwritten at 5% cash-on-cash, that is a warning sign, not a conservative assumption. The investor is paying for stability and should demand current yield in exchange for limited upside.
Value-add deals often show lower initial cash-on-cash because renovation downtime, tenant turnover, and lease-up concessions suppress early cash flow. A Year 1 cash-on-cash of 3% might be acceptable if the stabilized Year 2 projection is 10%. The metric to watch is the trajectory, not the starting point. Opportunistic deals may show negative cash-on-cash for the first 18 months. In that context, the metric is almost irrelevant. What matters is the exit multiple and the timeline to stabilization.
How leverage changes the signal
Higher leverage raises cash-on-cash when the cost of debt sits below the property's unlevered yield. It destroys cash-on-cash when the cost of debt rises above the yield. Because of that asymmetry, cash-on-cash is not a property-level metric. It is a property-plus-capital-structure metric.
A deal with 80% leverage and a 6% interest rate might show a 12% cash-on-cash. That looks attractive until you model a 100-basis-point rate increase, which could drop the return to 6% or lower. The same deal at 50% leverage might show 8% cash-on-cash, but the rate increase only drops it to 7%. Lower leverage produces a lower headline return but a more durable one. Committees should understand which version they are being sold.
Using cash-on-cash alongside cap rate for a complete picture
Cap rate and cash-on-cash are complementary, not competing. Cap rate tells you what the market thinks the property is worth on an unlevered basis. Cash-on-cash tells you what you earn as an equity investor after financing. The gap between the two is where leverage lives.
If the cap rate is 5.5% and your levered cash-on-cash is 8.0%, the 250-basis-point spread is your leverage premium. If the cap rate is 5.5% and your cash-on-cash is 4.0%, you are paying more for debt than the property yields, which is a structure problem, not a property problem. Presenting both numbers together makes that distinction obvious. Presenting cash-on-cash alone hides it.
The best underwriting packages show cap rate, cash-on-cash, IRR, and equity multiple in one table with clear assumptions for each. That table is what turns a spreadsheet into a decision document. It gives the committee four lenses on the same deal and lets them choose which one matters most for the strategy at hand.
Anonymized case study
Southeast multifamily acquisitions team (anonymized)
Challenge: A six-person team was screening value-add deals with inconsistent debt assumptions. Some analysts used 30-year amortization while others used 25, and interest rate buffers varied from 50 to 150 basis points. The result was a 300-basis-point spread in levered cash-on-cash projections for the same deal.
Approach: The team adopted a standardized cash on cash return calculator with built-in levered logic, fixed amortization at 30 years for multifamily, set a 75-basis-point rate buffer, and required DSCR verification alongside every cash-on-cash output before a deal moved to committee.
Outcome: Within one quarter, assumption variance between analysts dropped below 50 basis points, IC discussions shifted from debt-math disputes to investment merit, and the team caught two deals that looked attractive on cash-on-cash but failed DSCR thresholds under stress.
Data points and sources
- The Federal Reserve's H.15 release from April 14, 2026, shows the 10-year Treasury at 4.33%, which directly affects debt service assumptions and levered cash-on-cash projections for commercial real estate acquisitions. Federal Reserve - H.15 Selected Interest Rates
- Fannie Mae reported approximately $74 billion in multifamily financing volume in 2025, reflecting sustained institutional appetite for leveraged CRE strategies where cash-on-cash analysis is a primary screening metric. Fannie Mae - 2025 Multifamily Production
- According to CBRE's Q1 2026 US Cap Rate Survey, typical multifamily debt service coverage ratios range from 1.20x to 1.35x for institutional-quality assets, a threshold that directly constrains how much leverage can support a target cash-on-cash return. CBRE - Q1 2026 US Cap Rate Survey
Next step
If you want cash-on-cash analysis integrated into your live IC process with pro forma automation, debt logic, and governed assumptions, we can show you how it works.
Book a walkthroughRelated articles
- Cap Rate Calculator for CRE: A Practical Guide
April 23, 2026
- Market data triangulation for submarket risk
February 27, 2026
- Pro forma modeling from T-12 actuals in 2 minutes
March 31, 2026
- Excel and CSV ingestion for CRE underwriting
March 8, 2026