What does this commercial real estate analyzer calculate?

The analyzer estimates key metrics for a commercial property: capitalization rate (cap rate), cash‑on‑cash return, debt service coverage ratio (DSCR), and a multi‑year cash flow schedule. It uses your inputs for purchase price, NOI, financing terms, and cash invested to model annual debt service and net cash flow.

How is cap rate calculated?

Cap rate is calculated as annual net operating income (NOI) divided by purchase price. It is a simple measure of the property’s income yield before financing and taxes. For example, $120,000 of NOI on a $1,500,000 purchase price yields a cap rate of 8%.

What is cash‑on‑cash return?

Cash‑on‑cash return compares annual pre‑tax cash flow to the cash you invested. It is calculated as annual cash flow after debt service divided by total cash invested (down payment, closing costs, and initial improvements). It helps you understand how hard your invested cash is working.

How is DSCR estimated?

Debt service coverage ratio (DSCR) is calculated as NOI divided by annual debt service. A DSCR above 1.0 means NOI covers debt payments; many lenders prefer DSCR of 1.20 or higher. This tool uses your NOI and loan terms to estimate annual debt service and DSCR.

Does this analyzer include taxes or appreciation?

No. The calculator focuses on operating performance and financing. It does not model income taxes, depreciation, or property value appreciation. You can combine its cash flow outputs with separate tax and appreciation models for a more complete picture.

Can I export the cash flow schedule?

Yes. Use the Export CSV button to download the year‑by‑year cash flow schedule, including NOI, debt service, net cash flow, and DSCR. You can store it with your deal notes, share it with partners, or import it into a spreadsheet for further analysis.

Commercial Real Estate Analyzer

Quickly evaluate commercial property deals with cap rate, cash‑on‑cash return, DSCR, and a multi‑year cash flow schedule based on your NOI and financing assumptions.

Purchase price ($) Annual NOI ($) Vacancy & credit loss (%)

Loan amount ($) Loan interest rate (%) Loan amortization (years)

Total cash invested ($) Analysis horizon (years) NOI growth rate per year (%)

Tip: Start with conservative NOI and growth assumptions, then test optimistic and stress‑case scenarios.

Important: This analyzer uses simplified assumptions and standard loan formulas. It does not model taxes, depreciation, capital expenditures, or complex lease structures. Use it as a starting point and refine your analysis with detailed underwriting and professional advice.

Commercial real estate analysis formulas

Commercial real estate deals are built on a handful of core metrics. This analyzer focuses on cap rate, cash‑on‑cash return, DSCR, and a simple multi‑year cash flow schedule. Understanding the formulas behind these numbers helps you interpret results and stress‑test your assumptions.

1. Net operating income (NOI)

NOI = Gross rental & other income
      − Operating expenses (excluding debt service and taxes)

NOI represents the property’s income before financing and taxes. It is the foundation for cap rate and DSCR. In this tool, you enter annual NOI directly and can optionally apply a growth rate to model changes over time.

2. Cap rate

Cap rate = Annual NOI ÷ Purchase price

Cap rate is a simple yield measure. A property with $120,000 of NOI and a $1,500,000 purchase price has a cap rate of 8%. Higher cap rates generally indicate higher income relative to price, but they may also reflect higher risk or weaker markets.

3. Loan payment and annual debt service

Monthly interest rate = Loan interest rate ÷ 12 ÷ 100
Number of payments = Loan years × 12

Monthly payment =
  Loan amount × (r × (1 + r)^n) ÷ ((1 + r)^n − 1)

Annual debt service = Monthly payment × 12

This is the standard fixed‑rate loan payment formula. The analyzer uses it to estimate annual debt service, which feeds into cash‑on‑cash and DSCR calculations.

4. Cash‑on‑cash return (Year 1)

Year 1 net cash flow = Year 1 NOI − Annual debt service

Cash‑on‑cash return (Year 1) =
  Year 1 net cash flow ÷ Total cash invested

Total cash invested typically includes your down payment, closing costs, and initial improvements. Cash‑on‑cash return shows how much pre‑tax cash flow you earn relative to that cash.

5. Debt service coverage ratio (DSCR)

DSCR = NOI ÷ Annual debt service

DSCR measures how comfortably NOI covers debt payments. A DSCR of 1.0 means NOI equals debt service; 1.25 means NOI is 25% higher than debt service. Lenders often require minimum DSCR thresholds for commercial loans.

6. Multi‑year cash flow schedule

For each year t:

NOI_t = NOI_1 × (1 + g)^(t − 1)
Annual debt service_t = constant (fixed‑rate loan)
Net cash flow_t = NOI_t − Annual debt service_t
DSCR_t = NOI_t ÷ Annual debt service_t

The analyzer applies your growth rate g to NOI each year while keeping debt service constant for a fixed‑rate loan. The schedule shows how cash flow and DSCR evolve over your chosen analysis horizon.

Using a commercial real estate analyzer to underwrite deals

Underwriting a commercial property can feel overwhelming, but most deals boil down to a few key questions: How much income does the property generate? How much debt can it support? How much cash do you need to invest? And what return do you earn on that cash? This analyzer is designed to give you quick, transparent answers to those questions.

The starting point is net operating income (NOI). NOI strips away financing and taxes so you can see the property’s core operating performance. When you enter annual NOI, you are implicitly summarizing rent rolls, expense budgets, and vacancy assumptions. If your NOI estimate is too optimistic, every downstream metric will look better than reality, so it is worth spending time to build a realistic NOI number before relying on the outputs.

Cap rate as a first filter

Cap rate is often the first number investors look at. It tells you how much income the property generates relative to its price, ignoring financing. In a market where similar properties trade at 6% cap rates, a deal at 8% may look attractive—but you need to ask why. Higher cap rates can signal distress, weaker locations, or deferred maintenance. Use the cap rate output as a quick filter, then dig deeper into the story behind the number.

Financing and debt service

Once you have a handle on NOI, the next step is financing. The loan amount, interest rate, and amortization period determine your annual debt service. A larger loan or higher rate increases debt service and reduces cash flow; a longer amortization lowers annual payments but may increase total interest over time. This analyzer uses a standard fixed‑rate loan formula to estimate annual debt service, giving you a clear view of how financing interacts with NOI.

Debt service coverage ratio (DSCR) is a key lender metric. If DSCR is below the lender’s threshold—often around 1.20 to 1.25—the deal may not qualify for the desired loan terms. By modeling DSCR, you can see whether your assumptions support the financing you want or whether you need to adjust price, NOI, or leverage.

Cash‑on‑cash return and investor perspective

From an investor’s perspective, cash‑on‑cash return is often more intuitive than cap rate. It answers the question: “Given the cash I put into this deal, how much cash do I get back each year?” A property with strong NOI but heavy leverage may have modest cash‑on‑cash returns, while a lower‑leverage deal might produce steadier cash flow. By entering your total cash invested, you can see how financing structure and operating performance combine to produce investor‑level returns.

Multi‑year cash flow and growth assumptions

Commercial properties rarely have flat income forever. Rents may grow, expenses may rise, and market conditions may shift. This analyzer lets you apply a simple growth rate to NOI and see how cash flow and DSCR evolve over time. A modest growth rate can significantly improve DSCR and cash‑on‑cash return in later years, but aggressive growth assumptions can hide risk. It is often helpful to run multiple scenarios: a conservative case with low growth, a base case, and an optimistic case.

Practical underwriting tips

Build NOI from the ground up: start with rent rolls and realistic expense budgets.
Stress‑test your deal by lowering NOI or increasing vacancy to see how DSCR responds.
Compare cash‑on‑cash returns across deals with similar risk profiles, not just headline cap rates.
Use the exported schedule as a starting point for a more detailed underwriting model that includes capital expenditures and reserves.
Remember that this tool does not model taxes or depreciation; layer in those effects separately when evaluating after‑tax returns.

Frequently Asked Questions

What should I use for NOI?

Use a realistic estimate of annual net operating income based on current or projected rents and operating expenses. Exclude debt service, income taxes, and major capital expenditures. If you are underwriting a new acquisition, build NOI from rent rolls and expense assumptions rather than relying solely on broker marketing materials.

Can I model interest‑only or variable‑rate loans?

This version assumes a fixed‑rate, fully amortizing loan. Interest‑only periods and variable rates require more complex modeling. You can approximate an interest‑only loan by using a long amortization and manually adjusting debt service in a spreadsheet after exporting the schedule.

How many years should I use for the analysis horizon?

Common horizons range from 5 to 10 years, depending on your hold strategy. Shorter horizons emphasize near‑term performance; longer horizons highlight the impact of growth and amortization. Choose a horizon that matches your expected hold period or use multiple horizons to see how the deal behaves over time.

Does this tool account for capital expenditures and reserves?

No. The analyzer focuses on NOI and debt service. Major capital expenditures, reserves for replacement, and tenant improvement costs can materially affect cash flow. You can adjust NOI downward to reflect these items or incorporate them in a separate cash flow model.

Is the growth rate applied to income or expenses?

The growth rate in this tool is applied to NOI as a whole for simplicity. In a detailed underwriting model, you would typically apply different growth rates to income and expenses. Use the growth rate here as a high‑level assumption and refine it in a more granular model if needed.

Is this analyzer a substitute for full underwriting?

No. It is a quick‑analysis tool designed to help you screen deals and understand key metrics. Full underwriting should include detailed rent rolls, expense line items, capital expenditure plans, lease structures, and tax considerations. Use this tool as a starting point, not the final word.