Skip to main content

Task guide

Read and verify the cash-flow projection

Read the Multi-Year Cash Flow line by line, from base rent to cash flow after debt, so you can explain every number to a buyer.

15 to 30 minutesFor brokers and analysts reviewing a cash-flow projectionAdvancedLast verified October 5, 2026

Outcome

You can explain every major line in the In-Place and projected years, including why Year 1 differs from In-Place.

Navigation path

Document wizard > Valuation > Cash Flow Projection

Access

Full Financials with Multi-Year Cash Flow

On this page

Before you start

Data, sources, and access to prepare

  • A saved rent roll
  • Saved income and expense rows
  • Saved cash-flow assumptions

Follow the Multi-Year Cash Flow waterfall

Annual cash-flow waterfall

Read each column from base rent down to cash flow after debt.

  • Base Rental RevenueVacancy deductions
  • Vacancy deductionsEffective Gross Income
  • Effective Gross IncomeNOI
  • NOIBelow NOI
  • Below NOICash Flow After Debt
What each column and row means.
Column or rowHow CREBuilder calculates it
Base Rental RevenueOccupied plus vacant-space base rent. Hospitality labels it Room Revenue and Mobile Home Parks labels it Gross Pad Income.
Less: VacancyIn-Place deducts all vacant-space rent. Projected years deduct only the share not yet leased under the Lease-Up Scenario.
Less: Vacancy FactorGeneral Vacancy Factor % x base rent after Less: Vacancy, in every column. Reimbursements and other income are not reduced.
In-PlaceCurrent annual economics before growth
Year 1One full year of growth and lease-up after In-Place
Cap RateNOI divided by the selling price, shown under NOI
Cash-on-Cash ReturnCash Flow After Debt divided by selling price less loan amount; shown when financing is on. Closing costs are not included.
Exit PriceExit-year NOI divided by exit cap rate, before selling costs

Know the calculation order

  • Tenant rent grows by its custom escalation schedule first, or its annual growth rate.
  • If a tenant, vacancy, or reimbursement growth field is blank, an older document-level rate may apply; most documents have none, so blank usually means 0%. Enter an explicit rate, including 0, on every row you want to control.
  • Additional-income and operating-expense rows grow at their own rate, with zero as the default.
  • Expenses are grouped into Property Tax, Insurance, Management Fee, and General Expenses based on their names.
  • Reserves are the same dollar amount in every column.
  • Debt is interest-only for the I/O years, amortizing afterward, and stops after the loan term. In-Place carries the same debt service as Year 1.
  • CREBuilder does not calculate IRR or equity multiple.

Lease dates do not prorate the projection

The annual engine does not automatically stop, start, or prorate rent from tenant lease dates. Review whole-year assumptions explicitly.

Reconcile one layer at a time

Cash-flow review steps

  1. 1

    Start with In-Place rent

    Valuation, Cash Flow Projection

    Compare Base Rental Revenue and reimbursements with the saved rent-roll totals.

    Expected result: The first income layer reconciles.

    If this step does not work

    Return to the first mismatched tenant, vacancy, count, rent basis, or reimbursement.

  2. 2

    Reconcile vacancy and EGI

    Cash Flow Projection

    Compare Less: Vacancy, Less: Vacancy Factor, reimbursements, other income, and the resulting EGI.

    Expected result: The bridge from base rent to EGI is clear.

    If this step does not work

    Vacancy rows and the vacancy factor stack. Use both only when you want both physical vacancy and a general allowance.

  3. 3

    Reconcile expenses

    Cash Flow Projection

    Compare expense buckets and total expenses with Income & Expenses.

    Expected result: The preview expense total agrees with the saved statement.

    If this step does not work

    Rename or correct expense rows if a category is grouped unexpectedly.

  4. 4

    Recalculate NOI

    Cash Flow Projection

    Subtract total operating expenses from EGI.

    Expected result: Displayed NOI equals the independently calculated amount.

    If this step does not work

    Return to the first mismatched income or expense subtotal.

    Valuation workspace containing the Cash Flow Projection and its annual results.
    Read the projection from In-Place through later years, including NOI, debt service, cash after debt, and sale proceeds.
  5. 5

    Compare Year 1 growth

    Cash Flow Projection, Year 1 column

    Trace each change to a row growth rate, custom schedule, lease-up, vacancy factor, or expense growth.

    Expected result: Every Year 1 change has an input explanation.

    If this step does not work

    Return to the responsible input rather than editing a calculated total.

  6. 6

    Verify below-NOI items

    Cash Flow Projection

    Check reserves, debt service, and Cash Flow After Debt against the assumptions.

    Expected result: Below-NOI deductions match your loan and reserve inputs.

    If this step does not work

    Recheck financing term, I/O period, amortization, and reserve dollars.

  7. 7

    Verify exit

    Assumptions and preview

    Confirm selected exit year, its NOI, and exit cap calculation.

    Expected result: Exit price matches the independent calculation.

    If this step does not work

    Correct the year or cap rate and wait for autosave if it does not match.

Explain unexpected values

Vacancy seems counted twice

Likely cause: Vacancy rows and the General Vacancy Factor % are separate deductions that stack.

  1. Reconcile physical vacancy rows.
  2. Review the vacancy factor assumption.
  3. Use both only when you want both deductions.
A Mixed-Use component row differs from its source total

Likely cause: The preview allocates component gross potential rent using current in-place shares.

  1. Reconcile the combined total first.
  2. Then review the component allocation as a presentation breakdown.
IRR or equity multiple is absent

Likely cause: The cash-flow projection reports NOI, cash flow after debt, cash-on-cash, and exit price, not IRR or equity multiple.

  1. Calculate them in your own model from the annual cash flows and exit price if a buyer needs them.
Year 1 NOI is much higher than In-Place

Likely cause: In-Place deducts all vacant-space rent. Year 1 counts the leased-up share from the Lease-Up Scenario, which defaults to 100% Immediate.

  1. Open Assumptions.
  2. Choose a slower Lease-Up Scenario and a Stabilized Year.
  3. Compare the Less: Vacancy row again.

Projection ready

  • In-Place income ties to the rent roll
  • Year 1 growth and lease-up are explained
  • EGI and NOI tie out
  • Reserves and debt match your assumptions
  • Exit price matches exit-year NOI and cap rate

Your next OM, done this afternoon

Turn your property facts, photos and financials into a polished, branded offering memorandum. Most brokers finish in 30 to 90 minutes.

No credit card required.

Was this guide helpful?