A discounted cash-flow model estimates what a property’s future cash flows are worth today under a stated required return. It is useful when leases, vacancy, improvements, or financing make income uneven over time. Its strength is showing timing and assumptions; its weakness is that detailed forecasts can appear more certain than the evidence supports.
Start by choosing the cash-flow perspective. An unlevered property DCF excludes loan proceeds and debt service. A levered equity DCF includes them. Use a discount rate appropriate to that perspective and keep the distinction visible throughout the model.
What discounting actually does
A dollar received five years from now is not the same dated cash flow as a dollar available today. At an assumed 10% annual required return, $100,000 received at the end of year one has present value of approximately $90,909. The same amount at the end of year five has present value of approximately $62,092.
The formula is present value = future cash flow ÷ (1 + discount rate)^years for equally spaced annual cash flows. For irregular dates, use a date-based convention and disclose it. The discount rate is an analytical assumption; it is not automatically the mortgage interest rate or the investor’s guaranteed earnings elsewhere.
Net present value equals the sum of discounted future net cash flows less the initial investment. A positive NPV means the specified forecast exceeds the specified required return under the model’s conventions. It does not establish that the forecast will occur.
An unlevered hypothetical acquisition
Assume a commercial property requires the following initial funding:
| Initial use | Amount |
|---|---|
| Purchase price | $6,000,000 |
| Acquisition and closing costs | $180,000 |
| Initial improvement program | $300,000 |
| Initial reserve funding | $120,000 |
| Total initial cash required | $6,600,000 |
Assume projected property cash flow after the stated operating costs and subsequent capital requirements is $350,000 in year one, $380,000 in year two, $400,000 in year three, $420,000 in year four, and $440,000 in year five. These are invented forecasts for teaching the mechanics.
The model assumes sale at the end of year five using $500,000 of forward NOI and an 8% exit cap rate. Gross sale value is $6,250,000. Assumed selling costs are 2%, or $125,000, leaving $6,125,000 of unlevered sale proceeds before income taxes and other items not modeled. Year-five total cash flow is $6,565,000 including that year’s $440,000 operating cash.
Calculate present value by year
At a 10% annual discount rate, the results are:
| Year | Total modeled cash flow | Present value, rounded |
|---|---|---|
| 1 | $350,000 | $318,182 |
| 2 | $380,000 | $314,050 |
| 3 | $400,000 | $300,526 |
| 4 | $420,000 | $286,866 |
| 5, including sale | $6,565,000 | $4,076,348 |
| Total future present value | $5,295,971 | |
| Less initial funding | ($6,600,000) | |
| NPV | Approximately ($1,304,029) |
The base case does not support paying the assumed total cost at the assumed required return. That is a useful conclusion. Changing the discount rate until NPV becomes positive would conceal the economic issue rather than resolve it.
The $5,295,971 is the present value of the specified cash flows. To infer a maximum purchase price, separately subtract the other initial costs and account for costs that themselves change with price. Do not simply label this total as a defensible appraisal or market value.
Build the forecast from leases and costs
A DCF should be supported by tenant-level rents, commencement dates, rent steps, expirations, recoveries, and leasing assumptions. Schedule property taxes, insurance, utilities, repairs, and management. Separate physical improvements, tenant improvements, commissions, and reserves from operating expenses under the chosen convention.
A flat annual rent-growth assumption can be a useful simplifying sensitivity, but it should not override known contractual rent steps or a major lease expiration. The model must describe the subject investment. An office floor with substantial turnover does not behave like a fully leased warehouse simply because both use a 3% escalation cell.
Use monthly periods when annual totals conceal funding needs. A $200,000 improvement payment early in year one and equivalent rent collected late in the year can create a cash shortfall despite a positive annual result. Discounting annual net cash does not solve working-capital timing.
Treat capital and reserves consistently
In the example, $300,000 of initial work is already included in the opening $6.6 million investment. Do not deduct that same expenditure again from year-one operating cash unless the model also reflects the corresponding reserve funding or account release correctly.
An opening $120,000 reserve is an initial cash use. If an unused balance is later returned at exit, include that return explicitly. If it is consumed by modeled costs, do not return it again. Reserve rollforwards should identify opening balance, deposits, withdrawals, and ending balance.
For a program-specific example of terminology, Fannie Mae defines multifamily NCF after the underwritten replacement-reserve expense. That convention should not be mixed silently with an investor’s differently defined cash flow. Fannie Mae NCF definition
Keep debt out of an unlevered model
If loan proceeds are added to the initial sources, include debt service, draws, fees, and final payoff in the appropriate periods. The result becomes an equity cash-flow analysis. Its discount-rate assumption and interpretation must change accordingly.
For example, financing can reduce the initial equity contribution and magnify returns in a favorable case. It also creates fixed payments and a maturity obligation. Comparing the resulting equity NPV with the original unlevered NPV without recognizing the different risk and capital basis is misleading.
Maintain separate outputs when both perspectives are needed. An investor should be able to see whether an attractive levered result comes from strong real estate economics, inexpensive debt, a large future refinance, or optimistic exit assumptions.
Examine the terminal value’s share
In this example, most present value comes from year five, when the sale occurs. The investment therefore depends heavily on the terminal income and capitalization assumptions. Show that concentration instead of allowing the last column to disappear inside a single NPV output.
At a 7% exit cap rate with all other stated assumptions unchanged, net sale proceeds are $7 million and NPV is approximately negative $760,722. At a 9% exit cap rate, net sale proceeds are approximately $5,444,444 and NPV falls to approximately negative $1,726,600.
Even the more favorable 7% case remains below the assumed 10% required return at the proposed cost. The investor should investigate price, business-plan economics, or whether a different required return is actually justified by risk. The model should not assume future cap-rate compression merely to clear an acquisition hurdle.
The OCC handbook addresses direct capitalization and DCF as valuation methods. Use its underwriting context alongside property-specific evidence rather than as a source of a prescribed discount rate. OCC CRE handbook
Stress execution and duration
A six-month leasing delay can reduce first-year rent, extend carrying costs, increase financing expense, and postpone the sale. Change the schedule coherently. Do not push rent later while leaving every cost and exit date unchanged unless that is a deliberate and supported assumption.
Test a combined downside with lower collections, larger tenant costs, and a less favorable exit. Record the additional capital required and the minimum monthly cash balance. A DCF can remain positive in present-value terms while the investor lacks cash to complete the plan.
For Chicago-area properties, investigate the actual use, building condition, local approvals, and parcel-level tax circumstances. This guide supplies no current local growth rate, permit duration, or valuation yield. Those inputs need dated evidence appropriate to the specific investment.
Audit the decision rather than only the formulas
Verify units, signs, timing, terminal proceeds, and the distinction between property and equity cash flow. Recalculate a few key outputs independently. Confirm that the acquisition cost occurs at the intended date and that the sale year includes only the seller’s operating period.
Review the assumption register with the people responsible for leasing, construction, property management, and financing. A model that is mathematically correct can still be commercially implausible if the proposed tenant delivery, construction scope, or capital commitment cannot occur.
Jaken’s commercial financing overview can help frame the debt inquiry after the unlevered business plan is understood. Update the levered model with actual proposed terms rather than treating the overview as a loan commitment. Jaken commercial financing
A useful DCF makes the investment easier to challenge. It reveals which cash flows support the price, what assumptions deserve further research, and whether the investor can fund the route from acquisition to exit.
For competing investments, standardize the forecast date, holding period, cash-flow perspective, and discount-rate rationale before comparing NPVs. An investment twice as large can create more total value while requiring more capital; NPV alone does not solve a portfolio funding constraint. Report initial cash required and potential additional calls beside the valuation. If the investor must choose only one transaction, describe that actual constraint rather than pretending every positive-NPV investment can be purchased simultaneously.
The cited Fannie Mae glossary is the version effective April 30, 2026; its terminology is program-specific and should be reconciled with the applicable product and current loan documents.