Does it pencil?Drop 002 / Illustrative caseMultifamily
570 Units. A 7% Cap. Does It Pencil?
A 570-apartment Class B property is 75% occupied. At an assumed 7% cap rate, the math gives one figure at today’s occupancy and a higher one at 92%. Every number here is a fictional teaching assumption.
Illustrative caseAll numbers are fictional teaching assumptions. Not a real property, offering or transaction.
01
Does it pencil?
A good opportunity starts with a question. We work through the information, test the assumptions, run the calculations, and show what supports the result — and what doesn’t.
How every drop works
The math. The code. The evidence. Your decision.
- Start with the information.What was actually provided, and by whom.
- Test the assumptions.Separate what is sourced from what is assumed.
- Run the math.Fixed formulas. Same inputs, same result.
- Check the evidence.What supports the result, and what does not.
- Let people decide.The work informs the decision. It does not make it.
Before the recommendation, show the work.
02
The opportunity
A 570-apartment Class B property is offered for sale. A quarter of the apartments are empty. The pitch is simple: fill the building and it is worth more.
That may be true. The question is how much of it the numbers support today, and how much depends on things nobody has shown yet.
03
What we know
Six numbers were stated. None came with a document. That makes each one an assumption, not a fact.
Everything in the tiles above. Stated for teaching, supported by nothing.
None. No rent roll, operating statement or other source document exists for this example.
04
What we don’t know
This model does not establish:
- Purchase price
- Actual NOI
- Renovation cost
- Lease-up cost
- Financing terms
- Hold period
- IRR
- Equity return
It does not calculate IRR, debt coverage, debt yield or any return. Those need a price, financing terms and costs that are not in this example.
| Document needed | What it would settle |
|---|---|
| Current rent roll | Unit count, rent actually collected and occupancy today |
| Trailing 12-month operating statements | Actual income, actual expenses and actual NOI |
| Lease-up plan and market study | Whether 92% is reachable, how long it takes and what it costs |
| Property condition report and renovation budget | What has to be spent before the empty apartments can be leased |
| Comparable sales | Whether a 7% cap rate fits this property in this market |
| Asking price and financing terms | What the deal costs. Without them no return can be calculated |
05
Run the numbers
One set of formulas, run twice: once at today’s occupancy and once at the stabilized assumption. Average rent, the expense ratio and the cap rate are held fixed in both. Change any input and the figures recalculate in your browser.
Showing the Drop 002 teaching assumptions. All fictional.
As-is / occupancy today
75% occupancy
- Potential gross rent
- $10,260,000
- Effective gross income
- $7,695,000
- Operating expenses
- $3,462,750
- Modeled NOI
- $4,232,250
- Implied value
- $60,460,714
- Implied value per apartment
- $106,071
Stabilized / assumed
92% occupancy
- Potential gross rent
- $10,260,000
- Effective gross income
- $9,439,200
- Operating expenses
- $4,247,640
- Modeled NOI
- $5,191,560
- Implied value
- $74,165,143
- Implied value per apartment
- $130,114
Difference
Approximately $13.70 million in implied capitalized value.
That is the gap between two modeled figures at a 7% cap rate ($13,704,429). It is not profit, an equity gain, realized appreciation or an investment return. Getting from one figure to the other costs money and time this model does not include.
The formulas and what the terms mean
potential gross rent = apartments x average monthly rent x 12 effective gross income = potential gross rent x occupancy operating expenses = effective gross income x expense ratio modeled NOI = effective gross income - operating expenses implied value = modeled NOI / cap rate value per apartment = implied value / apartments
- Potential gross rent
- What the property would collect in a year if every apartment were leased at the average rent.
- Occupancy
- The share of apartments that are leased. This model uses physical occupancy and does not adjust for unpaid rent or concessions.
- Effective gross income
- Potential gross rent multiplied by occupancy.
- Operating expense ratio
- Operating expenses as a share of effective gross income. Held fixed here, which is a simplification.
- NOI
- Net operating income: income left after operating expenses, before debt payments and capital spending. Here it is modeled, not actual.
- Cap rate
- Capitalization rate: NOI divided by value. Dividing NOI by an assumed cap rate gives an implied value.
- Implied value
- Modeled NOI divided by the assumed cap rate. A modeled figure, not an appraisal, a price or an offer.
Simplified, before vacancy and credit loss beyond physical occupancy, other income, capital spending, closing costs, debt and taxes. This is arithmetic on the numbers entered. It is not an appraisal, an offer or investment advice.
06
Defend the result
Every figure carries a record: where it came from, how it was calculated and how far it can be trusted. The arithmetic is recomputed a second way and must agree. That proves the sums. It does not prove the inputs.
| Figure | Value | Designation | Status | Exceptions |
|---|---|---|---|---|
| Units | 570 | Illustrative assumption | INCONCLUSIVE | No rent roll or unit mix supplied. |
| Average monthly rent | $1,500 a month | Illustrative assumption | INCONCLUSIVE | Not supported by a source rent roll. |
| Occupancy today | 75% | Illustrative assumption | INCONCLUSIVE | Not supported by a source rent roll. |
| Stabilized occupancy | 92% | Illustrative assumption | INCONCLUSIVE | An assumption about the future. No lease-up plan or market study supplied. |
| Operating expense ratio | 45% | Illustrative assumption | INCONCLUSIVE | Not supported by trailing operating statements. |
| Cap rate | 7% | Illustrative assumption | INCONCLUSIVE | Stated in the scenario. No comparable sales supplied. |
| Modeled NOI, as-is | $4,232,250 a year | Calculated | MATHEMATICALLY VERIFIED | Built on unverified inputs. |
| Implied value, as-is | $60,460,714 | Calculated | MATHEMATICALLY VERIFIED | Built on unverified inputs. |
| Modeled NOI, stabilized | $5,191,560 a year | Calculated | MATHEMATICALLY VERIFIED | Built on unverified inputs. |
| Implied value, stabilized | $74,165,143 | Calculated | MATHEMATICALLY VERIFIED | Built on unverified inputs. |
| Difference in implied value | $13,704,429 | Calculated | MATHEMATICALLY VERIFIED | Built on unverified inputs. |
Open the full record for each figure
- Input or output
- Units
- Value
- 570
- Units
- units
- Designation
- Illustrative assumption
- Source
- None. No source document supplied
- Verification
- INCONCLUSIVE
- Exceptions
- No rent roll or unit mix supplied.
- Result
- Included for scenario analysis only.
- Review
- Not reviewed
- Input or output
- Average monthly rent
- Value
- $1,500 a month
- Units
- USD per month
- Designation
- Illustrative assumption
- Source
- None. No source document supplied
- Verification
- INCONCLUSIVE
- Exceptions
- Not supported by a source rent roll.
- Result
- Included for scenario analysis only.
- Review
- Not reviewed
- Input or output
- Occupancy today
- Value
- 75%
- Units
- percent
- Designation
- Illustrative assumption
- Source
- None. No source document supplied
- Verification
- INCONCLUSIVE
- Exceptions
- Not supported by a source rent roll.
- Result
- Included for scenario analysis only.
- Review
- Not reviewed
- Input or output
- Stabilized occupancy
- Value
- 92%
- Units
- percent
- Designation
- Illustrative assumption
- Source
- None. No source document supplied
- Verification
- INCONCLUSIVE
- Exceptions
- An assumption about the future. No lease-up plan or market study supplied.
- Result
- Included for scenario analysis only.
- Review
- Not reviewed
- Input or output
- Operating expense ratio
- Value
- 45%
- Units
- percent
- Designation
- Illustrative assumption
- Source
- None. No source document supplied
- Verification
- INCONCLUSIVE
- Exceptions
- Not supported by trailing operating statements.
- Result
- Included for scenario analysis only.
- Review
- Not reviewed
- Input or output
- Cap rate
- Value
- 7%
- Units
- percent
- Designation
- Illustrative assumption
- Source
- None. No source document supplied
- Verification
- INCONCLUSIVE
- Exceptions
- Stated in the scenario. No comparable sales supplied.
- Result
- Included for scenario analysis only.
- Review
- Not reviewed
- Input or output
- Modeled NOI, as-is
- Value
- $4,232,250 a year
- Units
- USD per year
- Designation
- Calculated
- Source
- Calculated from the inputs above
- Formula
- Units x average rent x 12 x occupancy today, less operating expenses
- Verification
- MATHEMATICALLY VERIFIED
- Exceptions
- Built on unverified inputs.
- Result
- For scenario analysis only. Not an actual NOI.
- Review
- Not reviewed
- Input or output
- Implied value, as-is
- Value
- $60,460,714
- Units
- USD
- Designation
- Calculated
- Source
- Calculated from the inputs above
- Formula
- Modeled NOI, as-is, divided by the cap rate
- Verification
- MATHEMATICALLY VERIFIED
- Exceptions
- Built on unverified inputs.
- Result
- For scenario analysis only. Not an appraised value, a price or an offer.
- Review
- Not reviewed
- Input or output
- Modeled NOI, stabilized
- Value
- $5,191,560 a year
- Units
- USD per year
- Designation
- Calculated
- Source
- Calculated from the inputs above
- Formula
- Units x average rent x 12 x stabilized occupancy, less operating expenses
- Verification
- MATHEMATICALLY VERIFIED
- Exceptions
- Built on unverified inputs.
- Result
- For scenario analysis only. Not a forecast.
- Review
- Not reviewed
- Input or output
- Implied value, stabilized
- Value
- $74,165,143
- Units
- USD
- Designation
- Calculated
- Source
- Calculated from the inputs above
- Formula
- Modeled NOI, stabilized, divided by the cap rate
- Verification
- MATHEMATICALLY VERIFIED
- Exceptions
- Built on unverified inputs.
- Result
- For scenario analysis only. Not an appraised value, a price or an offer.
- Review
- Not reviewed
- Input or output
- Difference in implied value
- Value
- $13,704,429
- Units
- USD
- Designation
- Calculated
- Source
- Calculated from the inputs above
- Formula
- Implied value, stabilized, minus implied value, as-is
- Verification
- MATHEMATICALLY VERIFIED
- Exceptions
- Built on unverified inputs.
- Result
- A gap between two modeled figures. Not profit, an equity gain or a return.
- Review
- Not reviewed
07
Capital markets context
Does It Pencil? is BullNet’s public teaching series. Hive Capital Markets is BullNet’s capital desk. They are separate, and this page is the series, not the desk.
- On a real engagement, capital markets work would bring in a purchase price, lender terms and the cost of the lease-up.
- Those inputs are what make coverage, break-even and return questions answerable.
- None of that work is in this example, so none of those figures appear here.
Neither Does It Pencil? nor Hive Capital Markets is a brokerage or an investment advisory service. BullNet is not a lender. About Hive Capital Markets
08
The human decision
The arithmetic is checked. The inputs are not. That is the difference between a calculation and an underwriting conclusion.
A person decides what happens next: ask for the documents, test the assumptions against them, or walk away. The work shown here is there to inform that decision, not to make it.
| The question | What it decides |
|---|---|
| Why is a quarter of the building empty? | Whether this is a leasing problem, a condition problem or a market problem. Each one costs a different amount to fix. |
| What does it cost to get to 92%? | How much of the gap between the two figures is left after renovation, concessions and time. |
| Is $1,500 the rent collected or the rent asked? | Whether the income in the model exists today. |
| Does a 45% expense ratio hold at both occupancy levels? | Whether modeled NOI is overstated. Many costs do not fall when apartments are empty. |
| What supports a 7% cap rate? | The implied value moves with it. A higher rate gives a lower figure on the same income. |
| What is the price? | Everything about return. Without it, this model can only compare two modeled figures. |
Does it pencil?
An AI answer is not an underwriting conclusion.
09
Start a Flight Sheet
Have a real decision to test? A Flight Sheet sets out the question, the information you have and what a defendable answer would need.
Illustrative underwriting on stated assumptions. Not a real transaction, a market survey or a recommendation. Not investment, tax or legal advice.