Study for the CCIM credential by rebuilding small discounted cash flow models by hand: construct NOI line by line, rank deals on IRR and NPV rather than cap rate alone, compare the loan constant to the going-in cap rate before deciding on leverage, and trace every model assumption to a market data point or label it a sensitivity.
Building the NOI foundation the cash flow model starts from
Net operating income equals gross potential rent, minus vacancy and credit loss, plus other income, minus operating expenses and reserves. Capital expenditures are excluded from NOI but included in cash flow after it, and confusing the two categories distorts every metric downstream.
Trace a property's income statement line by line before touching any return metric. Start with gross potential rent at market, subtract vacancy and collection loss, add reimbursements, parking, and other incidental income, then deduct operating expenses such as taxes, insurance, utilities, and management. A roof replacement belongs below the NOI line as capital expenditure; expensing it there understates the cap rate and misstates the yield a buyer is actually purchasing.
Make classification a deliberate exercise, not an afterthought. Leasing commissions, tenant improvements, and replacement reserves occupy a middle ground that varies by model structure, so write down where your model places each item and stay consistent across every property you compare. Then test yourself: take any listed offering memorandum, rebuild the NOI from the rent roll on a blank sheet, and compare your figure to the broker's. Differences are where the learning is, because each discrepancy reveals either an assumption you did not see or a category you classified differently.
Why a higher cap rate can still lose the deal
A cap rate is a single-year snapshot of yield. It ignores NOI growth, capital expenditures, and exit conditions. Two properties priced at the same figure can carry different cap rates yet opposite internal rates of return over a holding period.
Consider a simplified, illustrative decision between two properties, each priced at 10,000,000. Property A shows year-one NOI of 700,000, a 7.0 percent cap rate, but needs a 600,000 roof in year three and grows NOI at 2 percent. Property B shows 650,000 of year-one NOI, a 6.5 percent cap rate, grows at 3 percent, and has no near-term capital needs. A cap-rate-only ranking picks A. Modeling a five-year hold with an exit at each property's going-in cap rate tells a different story.
Run the cash flows. Property A produces roughly 700, 714, 128 after the roof, 743, and 757 plus an 11,037 exit, giving an IRR near 7.9 percent. Property B produces 650, 670, 690, 710, and 732 plus an 11,170 exit, an IRR near 8.9 percent. The better decision is to buy the lower-cap-rate asset, because growth and capital needs dominate a one-year yield snapshot. This is why discounted cash flow, not the cap rate, is the comparison tool when holding periods and capital events differ between properties.
- Cap rate: year-one NOI divided by price; a snapshot, not a total return measure.
- IRR: the discount rate setting net present value to zero across the full holding period.
- The mistake in the scenario: ranking on cap rate while ignoring the roof outflow and the growth-rate gap.
- The better decision: model both deals over the same hold and compare IRR and NPV side by side.
Positive versus negative leverage: compare the loan constant to the cap rate
Leverage helps only when the going-in cap rate exceeds the loan's annual debt service rate, the loan constant. When financing costs more than the property yields, leverage is negative and equity returns fall, even though the deal itself may still be sound.
Work a second illustrative scenario. A property costs 5,000,000 with year-one NOI of 400,000, an 8.0 percent cap rate. A 3,000,000 interest-only loan at 6.5 percent costs 195,000 annually, leaving 205,000 on 2,000,000 of equity, a 10.25 percent cash-on-cash return. The cap rate exceeds the loan constant, so leverage is positive and equity returns are amplified above the unlevered 8 percent yield.
Now reprice the debt at 8.5 percent interest-only, 255,000 annually. Cash-on-cash falls to 7.25 percent, below the 8 percent unlevered yield, which is the definition of negative leverage. The tempting mistake is to assume debt always improves returns or to abandon the deal entirely. The better decision is to compare the loan constant against the going-in cap rate as a first screen, then test whether NOI growth or amortization changes the picture over the hold. Leverage magnifies outcomes in both directions, so the financing assumption deserves the same sensitivity testing as the exit cap rate.
When IRR and NPV point to different answers
IRR expresses return as a percentage rate; NPV expresses value created in currency at a chosen discount rate. They can disagree when deal sizes differ, because IRR ignores scale, so use NPV to compare wealth created and IRR to compare efficiency.
Suppose one investment ties up 2,000,000 and earns a 15 percent IRR while another ties up 10,000,000 and earns 11 percent. The smaller deal wins on rate, but the larger one may create far more absolute value discounted at your required return. That is the scale problem, and it is resolved by computing NPV at your opportunity cost of capital and letting the currency figure, not the percentage, settle conflicts. A high IRR on a tiny position can be worth less than a modest IRR on a large one.
The second reconciling concept is the reinvestment assumption embedded in IRR, which implicitly assumes interim cash flows earn the IRR itself. When interim distributions are large and early, IRR can overstate what you will actually compound at, which is why modified IRR exists as a refinement. For study purposes, practice stating, for any deal you model, which figure you would present to an investor and why. Being able to explain the disagreement between the two metrics is a stronger position than memorizing their definitions.
| Metric | What it measures | Strengths | Blind spots | Best use |
|---|---|---|---|---|
| Cap rate | Year-one NOI divided by price | Fast screening and quick valuation comparison | Ignores growth, capital events, financing, exit | First-pass market pricing |
| IRR | Annualized return across the full hold | Captures timing and size of every cash flow | Ignores scale; assumes reinvestment at IRR | Ranking efficiency of similar-sized deals |
| NPV | Value created at a chosen discount rate | Expresses wealth in currency; respects scale | Depends heavily on the discount rate chosen | Comparing wealth created across differently sized deals |
| Cash-on-cash | Year-one pre-tax cash flow over equity | Shows immediate equity yield with leverage | Ignores later years and sale proceeds | Judging near-term income with financing |
Feeding market analysis into model assumptions instead of guessing
The designation's coursework pairs financial analysis with market analysis, so every growth, vacancy, and exit assumption in your model should trace to a market data point or be explicitly labeled a sensitivity rather than an opinion.
Market analysis answers top-down questions that set the boundaries of your model: what supply is under construction, what demand drivers support absorption, and where rents and vacancy sit relative to comparable submarkets. Investment analysis then converts those findings into model inputs: a rent growth rate, a vacancy assumption, and an exit cap rate. The discipline to practice is tracing each input to its source. If your 3 percent rent growth comes from a submarket trend, cite it; if it is a judgment call, run it as a scenario.
The exit cap rate deserves special attention because terminal value usually dominates the present value of a five-year hold. Small changes matter enormously: shifting an exit cap by half a percentage point can move terminal value by several percent of the purchase price. Build a habit of testing exit cap, rent growth, and vacancy together in a small sensitivity grid, then ask whether the deal survives the pessimistic corner. A recommendation that depends entirely on the optimistic corner is not a recommendation; it is a hope, and modeling reveals that before capital is committed.
- Trace each assumption: market data point, comparable evidence, or explicit judgment scenario.
- Test exit cap, rent growth, and vacancy jointly, not one at a time.
- A recommendation that holds only in the optimistic corner of the grid is not a recommendation.
A hands-on build-and-grade exercise with a self-check rubric
Pick one small retail or office listing and rebuild its five-year cash flow from scratch: NOI by year, debt service, equity cash flows, and an exit value. Then grade your own model against a written rubric instead of relying on a finished spreadsheet.
Construct the exercise deliberately. Choose a listing with a published rent roll and offering memorandum, set a five-year hold, assume an exit at the going-in cap rate, and finance with an interest-only loan at a rate you select for illustration. Compute year-one cash-on-cash, unlevered IRR, levered IRR, and NPV at a discount rate you justify in one sentence. The point is not matching the broker's number; it is being able to defend every line in your version and explain why it differs from theirs.
Grade the finished model against this rubric, scoring each item from zero to two: every NOI line item classified as operating or capital with a stated reason; each growth, vacancy, and exit assumption traced to a source or labeled a sensitivity; the loan constant compared to the going-in cap rate with the leverage verdict stated; and a sensitivity grid showing the levered IRR at the optimistic and pessimistic corners of exit cap and rent growth. A total of seven or more out of eight signals a model you can defend under questioning; anything less points to the specific lines to rebuild before moving on. Repeat the exercise on a second property type so the classification habits generalize beyond one format.
- Deliverable: a hand-built five-year model with NOI, debt, equity cash flows, exit, IRR, NPV, and cash-on-cash.
- Rubric items scored 0-2: NOI classification, assumption sourcing, leverage screen, sensitivity grid.
- Seven of eight or higher signals a defensible model; lower totals identify the exact lines to rebuild.
An adaptable preparation sequence and readiness checks before exam day
Sequence your preparation in three passes: rebuild fundamentals by hand, apply them to varied case properties, then simulate decision-making under time pressure. Finish only when you can produce a defensible go or no-go recommendation from a cold fact pattern.
A realistic sequence starts with a fundamentals pass, where you rebuild the NOI-to-IRR chain by hand until classification and timing require no deliberation. The second pass is application: work unfamiliar case properties across at least two property types and two financing structures, forcing yourself to write the leverage verdict and the metric disagreement explanation each time. The third pass is timed decision practice: give yourself a fixed short window to read a fact pattern, state a preliminary go or no-go, and list the two assumptions your answer depends on most. This mirrors the applied decision-making the designation's coursework emphasizes, in which analysis must end in a defensible recommendation.
Readiness checks keep the sequence honest. You are ready to move between passes when you can, without notes: rebuild a full NOI from a rent roll and state where each borderline item sits; compute the loan constant and compare it to the going-in cap rate in under a minute on a clean deal; and explain, in two sentences, when you would trust NPV over IRR. For administrative details such as coursework requirements, scheduling, and designation pathways, rely on the CCIM Institute directly rather than secondary summaries. Keep all practice scenarios on paper or in a spreadsheet; none of this preparation requires live transactions or client data.
- Pass one: hand-rebuild NOI, debt service, and equity cash flows until classification is automatic.
- Pass two: apply the chain to varied case properties and financing structures, writing verdicts each time.
- Pass three: timed cold fact patterns ending in a go or no-go with named key assumptions.
- Readiness checks: clean NOI rebuild, one-minute loan constant comparison, two-sentence NPV-versus-IRR explanation.
References and further reading
Use these references to explore the concepts and check the latest information from the relevant organizations.